Posted to microsoft.public.excel.misc

Chad Portman[_2_] Chad Portman[_2_] is offline

external usenet poster

Posts: 1

INDIRECT

I am trying to link to a another file on my work server using the INDIRECT
function. The following is my equation:

=INDIRECT("'"&B13&B14&B15&".xls]"&B16)

This ends up creating a link to a cell on a certain sheet of the workbook
based on the filepath to get to the file.

This function works no problem with the reference file open but I need to
have it work without the reference file being open. Is this possible?

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
INDIRECT	INDIRECT	Excel Worksheet Functions	6	July 14th 08 05:38 PM
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4)	Dave F[_2_]	Excel Discussion (Misc queries)	3	September 20th 07 08:36 PM
INDIRECT.EXT	Danny Lewis	Excel Worksheet Functions	0	July 14th 06 11:00 AM
Help with INDIRECT	Spreadsheet	Excel Worksheet Functions	3	June 7th 06 06:22 PM

All times are GMT +1. The time now is 04:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us