VBA Code - Working with multiple files

Resolved · High Priority · Version 2003

Wed 13 Jan 2010, 15:12 Delegate Aleksejs said...

Aleksejs has attended:
Excel VBA Intro Intermediate course

VBA Code - Working with multiple files

Hi,

I am interested to see how I can open files (saved in a certain location with a given name) and move data from one file to another.

Thanks

Fri 15 Jan 2010, 09:45 Trainer Stephen said...

RE: VBA Code - Working with multiple files

Hi Aleksejs

Thanks for your question

As discussed I will ammend the code to meet your needs and upload it to this post within the next few days.

Hope all is well, and that you are sucessfully using your new knowledge.

Regards

Stephen

Thu 21 Jan 2010: Automatically marked as resolved.

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

VBA Code - Working with multiple files

VBA Code - Working with multiple files

RE: VBA Code - Working with multiple files

Excel articles

Excel tip:

Difference between Two Dates