Posted to microsoft.public.excel.programming

BEAST

external usenet poster

Posts: 3

creating a value for a file name

hello is it possible to create a variable for a file name:
for example x.xls where x=cell A1
I am trying to create a vlook up formula that can access differnt xls files
=vlookup([x.xls]!,A2:A4,2) something like that
I can't get x to be a variable equal to whatever is in cell A1
this one is a toughy....

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a help file	Paul B	Excel Programming	1	January 2nd 07 08:32 PM
Creating cub file using VBA	Tecnet	Excel Programming	1	June 14th 06 10:56 AM
Creating a new excel file from an existing file using macro	Macro	Excel Programming	2	July 28th 05 06:40 PM
Creating a help file	Yoam69	Excel Programming	2	June 2nd 05 05:39 PM
creating an exe file with visual basic (installation file for Macros and Userforms)	[email protected]	Excel Programming	3	August 5th 04 10:16 AM

All times are GMT +1. The time now is 08:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us