how can i get data from an un_opened excel file using codes

's Computer Specifications

i want to write codes to retrieve data from an unopened excel file. how can
get it? thanks a lot.

's Computer Specifications

Hi hf

See
http://www.rondebruin.nl/ado.htm

Or
http://www.rondebruin.nl/copy7.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"hf" <(E-Mail Removed)> wrote in message news:B8C1E00B-C874-4972-8082-(E-Mail Removed)...
>i want to write codes to retrieve data from an unopened excel file. how can
> get it? thanks a lot.

's Computer Specifications

HF,

You can try this one :

Sub TESTretrieve()
With Activeworkbook.sheets(1).range("A1")
.FormulaArray = "='C:\[Book1.XLS]Sheet4'!$A$1"
.Value= .Value
End With
End sub

note that file C:\Book1.xls is must be available .!
--

Regards,

Halim

"hf" wrote:

> i want to write codes to retrieve data from an unopened excel file. how can
> get it? thanks a lot.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOW CAN I CONVERT EXCEL DATA TO BAR CODES?	=?Utf-8?B?Z3V5aW5yZW50b24=?=	Microsoft Excel Misc	1	14th Sep 2005 06:10 PM
text file data include zip codes w/ leading zero should not be dro	=?Utf-8?B?U2VuaW9yQmlsbA==?=	Microsoft Excel Crashes	3	9th May 2005 07:34 AM
Word field codes in Excel data file Includetext	=?Utf-8?B?bXJhbno=?=	Microsoft Excel Misc	1	7th Dec 2004 11:19 PM
Importing Zip Codes from Excel File	=?Utf-8?B?Q2hhcmxpZQ==?=	Microsoft Word Document Management	3	29th Mar 2004 04:36 PM
How do I update the zip codes file for use in Geo Mapping in Excel?	=?Utf-8?B?Rmllc3RhRnJlZA==?=	Microsoft Excel Misc	0	23rd Dec 2003 04:11 PM