Hi Marcus, I don't think I'm explaining it correctly. Say I want to do something simple like this: RenameFile>C:\Temp\CITI_MT940*.*,C:\Temp\CITI.rpt Goto>End Nothing happens. From my research, I believe the error is due to the fact that I'm using a variable *.* in my original file search. The file n...

Hi All, I understand that if you try to find a file by using a wildcard, you will be unable to move and rename the file. For example, I have a file named "CITI_MT940_201505050710.SNL18240D11430824221593539S". When it loads into a specific folder, I would like to copy it, rename, and place it in a di...

Thanks for the help! I have it up and running.

Dom

Hi All, I have only launched a macroscheduler macro from clicking on a job inside a program. In this instance I would like MS to watch a folder, then run a job when a file is detected. A few questions: How can I have MS "on" all the time? In other words, if the machine I want this job on has been re...

I'll give this a shot - thanks so much for your help!

DR

Thanks for the quick reply! I would like to first make sure the file exists, then open it (there could be 5+ files in the folder, but only one with that filename). After this is found I would like to open it, rename it then close it. Obviously this should be fully automated. I'm not sure I follow wh...

**Note: I think I posted this in an incorrect forum before so I'm posting it here again. Sorry for the double post** I have a file that needs to be opened and renamed on a daily basis. PART of the filename changes daily so I want to open the file using the "*". Here is part of the script I have so ...

I have a file that needs to be opened and renamed on a daily basis. PART of the filename changes daily so I want to open the file using the "*". Here is part of the script I have so far: I first want to locate the file and see if the file is there. In this case the file name is " ETCTXT02292295P.091...

JRL,

Thanks so much - it worked perfectly!

DR

Hi All,

If I need to get a macro to print todays date I can use:

GetDate>theDate
Send Character/Text>%theDate%

How can I print out yesterday's date? Can you subtract 1 from a variable?
Sorry for the basic question, but I'm a bit stumped.

Thanks in advance.
DR

I apologize for asking so many questions. I'm now testing this: FindWindowWithText>rover,1,result MessageModal>result If>result="NOT FOUND",Here,There Label>Here MessageModal>This is working correctly Goto>End Label>There MessageModal>This is WRONG Label>End And get two messages. The first reads "NO...

Your syntax looks OK. But your current example will always show "This is WRONG". After completing the section in Here it will continue into There. You need to skip There as shown here: FindWindowWithText>rover,1,result If>result="NOT FOUND",Here,There Label>Here Message>This is working correctly Go...

I recently found this VB script on the boards that lets a webpage fully load before executing the next command: VBSTART Public oIE Sub CreateIE Set oIE = CreateObject("InternetExplorer.Application") oIE.visible = 1 End Sub Sub Navigate(URL) oIE.navigate URL End Sub Sub WaitBusy do while oIE.Busy loo...

Of course! Thanks!

I am trying to compare the result of a "FindWithWindowText" in an "if" statement but I dont think I'm using the correct syntax. Can someone please take a look at this and see if it's correct? FindWindowWithText>rover,1,result If>result="NOT FOUND",Here,There Label>Here Message>This is working correc...