Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Accessing data from files with variable names

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Accessing data from files with variable names

Resolved · Medium Priority · Version 2007

Reply Thu 16 Dec 2010, 15:58Delegate Alex said...

Alex has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Accessing data from files with variable names

I am looking to pull data from various files that each have varaible names (they are saved by date) but fixed data locations and formats.

I am looking to run a macro which prompts you to open the required file, where the data range is already known.

This will be repeated to pull data from several diff locations.

For upcoming training course dates see: Pricing & availability

Reply Fri 17 Dec 2010, 11:51Trainer Stephen said...

RE: accessing data from files with variable names

Hi Alex

Thanks for your question

As discussed, I will investigate your problem further and provide an answer within the next 24 hours

Regards

Stephen

Excel articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Discover How To Use Fill In Excel
· What Do The Formula Error Messages Mean In Excel?
· Chart Creation Simplified - in 4 Simple Steps
· What Is A Sparkline And How Do They Work?

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips