Posted to microsoft.public.excel.misc

John[_22_] John[_22_] is offline

external usenet poster

Posts: 694

accessing a cell from another .xls file

Hi Mike
Not sure what you need but this is syntax to another workbook,tab "Invoice, cell
A1 ='[INVOICE MultiDbase.xls]Invoice'!$A$1
HTH
John
"Mike s." <Mike wrote in message
...
Wonder if anyone can provide the syntax to be able to access the numerical
value of a cell located in an .xls file other than the current one.

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
Accessing information from an encrypted file	Ringside	New Users to Excel	0	June 16th 08 04:13 PM
Accessing Attached xls File	shannyshanhan	Excel Worksheet Functions	0	August 9th 06 10:04 PM
Accessing Attached XLS file	shannyshanhan	Excel Worksheet Functions	0	August 9th 06 02:57 AM
Multiple accessing of an excel file	[email protected]	Excel Discussion (Misc queries)	5	February 26th 06 06:56 PM
Multiple accessing of an excel file	[email protected]	Excel Worksheet Functions	2	February 26th 06 12:10 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us