Hey everyone,
I am very new to VBA and trying to program my excel sheet to save itself, everyday at 6:30am and 6:30pm, to a folder outside the current file destination, with the date and time stamp. This sheet will be left open at all times for our guys out on the line to use. I have tried putting in different times in timevalue to get it to run so I can see, but nothing happens.
I am not sure why it isn't working. Does anyone see any issues with this code?
This is what I have so far in the 'ThisWorkbook' - not in the ActiveSheet.
Thanks for your help.
Bookmarks