Strange problem: Computer's date changes when importing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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



============
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import External Data by Date Automatically 0
Data type issues adding data from vbscript 7
Import Data - from Excel 4
Access Importing csv daily files into access 2007 1
import data from excel command button 2
Access Problems loading "External Data" in Access. 0
Running MS Access From Excel VBA: Communication Between Processes? 2
Scroll when importing data 2

Back
Top