Two quick questions...
A) A file I am opening updates everyday at noon & the end of the filename is the day of the month it was updated.
April 26th
Filename = test26
I have no problems if the user runs my macro on the 26th because it inserts the day. The problem I am having is if the user runs the macro in the morning of the 27th. 27 inserts at the end of the filename, rather than the 26 that I need.
How would I code this since I want the day to equal the 26th if it is After 12pm EST on the 26th and before 12pm EST on the 27th.
B) Is there a way to determine which Excel version the user is running? Users of my programs are running anywhere from version 97 through XP.
Thanks, Derek_35
A) A file I am opening updates everyday at noon & the end of the filename is the day of the month it was updated.
April 26th
Filename = test26
I have no problems if the user runs my macro on the 26th because it inserts the day. The problem I am having is if the user runs the macro in the morning of the 27th. 27 inserts at the end of the filename, rather than the 26 that I need.
How would I code this since I want the day to equal the 26th if it is After 12pm EST on the 26th and before 12pm EST on the 27th.
B) Is there a way to determine which Excel version the user is running? Users of my programs are running anywhere from version 97 through XP.
Thanks, Derek_35