Thread
:
Strange problem: Computer's date changes when importing data
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 1,071
Strange problem: Computer's date changes when importing data
Somewhere in your code there is a Date *statement* as in Date={date}
For more see the XL VBA help for the 'date statement' (w/o the quotes).
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I wrote a small VBA routine that imports the data from an Excel spreadsheet
into another spreadsheet.
The second spreadsheet contains a button. When I click on the button it
opens a dialog where I can select the first spreadsheet and import data from
it. I haven't included any error handling, the data seems to import without
problems.
Here's what's weird. After I've imported the data, my computer system's
date/time are change. I've noticed that the system's date matches the date of
the file that I've just imported. I can't figure out why. Has anybody
experienced this? I can provide the code if needed. I'm using Excel 2002.
Franco
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta