Posted to microsoft.public.excel.programming

K[_2_]

external usenet poster

Posts: 557

Open File Macro

Hi Joel, I have tried your code and i am getting error on code line
(see below). Please help

Workbooks.Open Filename:=Fl & "\" & fname

See below the error message

Run-time error '1004'
"C:\My Document\Records\Record A" could not be found. Check the
spelling of the file name, and verify that the file location is
correct
If you are trying to open the file from you list of most recently used
files, make sure that the file has not been renamed, moved, or deleted

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
Open Excel file from VB and open MACRO	no1jimmyman	Excel Discussion (Misc queries)	0	February 14th 11 10:10 PM
Open a file do a macro ( made) and open next succesive file	SVTman74	Excel Programming	5	April 21st 06 10:14 PM
Macro to call a file that has a auto open macro in the file itself	[email protected]	Excel Programming	1	August 5th 05 06:39 AM
Automate open file, update links, run macro, close and save file	Geoff[_7_]	Excel Programming	2	August 26th 03 10:13 PM

All times are GMT +1. The time now is 03:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us