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

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 <[email protected]>,
[email protected] 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
>

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 <[email protected]>,
> [email protected] 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
> >
>