Been using VB for a number of years now, great product, we love it. I've taken it a step further and have been using it to automate our company backups...
I have one script, that locks up completely (I often have to kill the process). On the rare occasion, I can see the script window and see that its 'building' this step..
The Step Properties is a VBScript type. Its 3 lines of code to get a 'file friendly date MM-DD-YY' so I can rename the .log file.
Nothing special on General/More tabs..
Code:
Dim TodaysDate
TodaysDate = Year(Now) & "-" & Month(Now) & "-" & Day(Now)
' set our date in a file friendly name
Application.Macros(vbldMacroTemporary).Add "FRIENDLY_DATE", TodaysDate
When I run this using "Test" - all is OK.
Any suggestions? Perhaps even a work around for what I'm trying to do?
THx.
m.