For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic > April 2006 > Why Statement Doesn't Execute









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Why Statement Doesn't Execute
Billy

2006-04-29, 3:56 am

I have the following:

Sub ResetToED2()
Application.Replace Field:="Duration", Test:="contains",
Value:="1d?", Replacement:="1ed", ReplaceAll:=True, Next:=False,
MatchCase:=False
End Sub

I acquired this code by using "Record Macro" in Microsoft Project.

I have tested this macro, and it doesn't seem to run. In other words,
it is not doing what I intended, which is to find all 1d? durations and
change them to 1ed. This line seems to be ignored. What do I need to
modify in order to get this statement to be executed?

Jeff Johnson

2006-04-30, 3:56 am


"Billy" <googledude@godfearer.com> wrote in message
news:1146295299.428243.105060@j73g2000cwa.googlegroups.com...

> I acquired this code by using "Record Macro" in Microsoft Project.


I recommend you post in microsoft.public.project.vba.


Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com