Posted to microsoft.public.excel.programming

rickey24[_8_] rickey24[_8_] is offline

external usenet poster

Posts: 1

File open with Path Name

Hi

If you have the whole file path name (eg
C:\Pen\Data\Worlds\Global.xls) in Excel Cell B2, how do you call tha
in my macro with, for e.g.
Workbooks.opentext Filename:= B2. Is that possible? Thanks.

R

--
Message posted from http://www.ExcelForum.com

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
Excel 2002: How to reveal path of an open file ?	Mr. Low	Excel Discussion (Misc queries)	6	July 28th 09 05:13 PM
my vlookup path changes when I open the file	AliGoLightly	Excel Worksheet Functions	1	February 23rd 09 09:52 PM
How to find file-path of open workbook?	Larryq22	Excel Discussion (Misc queries)	7	January 24th 08 03:38 AM
How set file open path to filepath of file opened with Explorer ?	RandyDtg1	Excel Programming	0	May 14th 04 02:05 AM
Getting the full path when from a File Open Dialog Box	Ric Payne	Excel Programming	3	July 10th 03 04:58 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us