I have a script that saves an Excel File to my Desktop.
The following line in my script is used to set the naming convention:
StyleMaster::Factory &" "& " ShipSchedule" & Get(CurrentDate)
I want this to output FactoryName ShipsSchedule Todays Date, but I am getting an error message regarding the date.
When I remove the Get(CurrentDate) parameter the script works fine and I get “Factory Name ShipSchedule” . I can’t figure out why the Get command is messing things up- but I have a feeling it has to do with Excel not being able to accept the way the Date is formatted..
Please help. Thanks!