Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem: Computer's date changes when importing data
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strange problem: Computer's date changes when importing data
Thank you, Tushar.
Your suggestion was extremely helpful. I changed the Date= statement to something like FormDate= and it solved the problem. I will also read through help to learn more about it. Kind regards, Franco ============ "Tushar Mehta" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange New Line text when importing from Access 97 | Links and Linking in Excel | |||
strange behaviour in Excel 2003 when importing XML | Excel Discussion (Misc queries) | |||
Strange Data Look Up Problem | Excel Worksheet Functions | |||
importing csv files, problem with date formats | Excel Worksheet Functions | |||
Strange date formatting problem | Excel Programming |