Posted to microsoft.public.excel.programming

Ing. Luis Fernando Ortiz M. Ing. Luis Fernando Ortiz M. is offline

external usenet poster

Posts: 4

data from external file without opening

delali:

Try with Vlookup

Regards.

Luis Fernando Ortiz M.

"delali" escribió en el mensaje
...
Hi All,

Is it possible to get data from an external excel file without opening the
file?

using workbooks("fname").worksheets("shtname").range("A1 ").value only
works
when fname is open.

thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Opening An External File	Matthew[_2_]	Excel Discussion (Misc queries)	3	October 5th 09 03:33 PM
Code to select 'Disable Macro' when opening an EXTERNAL FILE	G rumpy O ld D uffer	Excel Programming	1	March 22nd 05 05:32 PM
Opening an external file	lilnuba	Excel Programming	1	August 18th 04 04:56 PM
Autorefreshing excell external data while opening from VBA code	Devendra[_2_]	Excel Programming	1	January 7th 04 06:37 AM
Get External Data, Import Text File, File name problem	Scott Riddle	Excel Programming	1	July 11th 03 05:40 PM

All times are GMT +1. The time now is 12:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us