INDIRECT function

  • Thread starter Thread starter howiechc
  • Start date Start date
H

howiechc

As we all know an INDIRECT function returns the reference specified by
text string. References are then immediately evaluated to display thei
contents.

My problem is this, because the reference is done immediately t
evaluate the content, the moment I shut off my reference workbook, al
my fields became #REF! which is normal...

How can I unable this, because I would like to retain the data that i
being parse to it, just like the normal book to book linking...wher
the user willl be prompt asking to update the link or to retain th
data. I can't use this linking route as I am parsing a variable int
the formula field. I did something like this :

=INDIRECT("["& sg &"]Summary!$I$7")

where "sg" is a variable I created to pass me a string in this case
filename.

I hope I make myself as clear as possible...above all I just want t
have my data retain when I shut the workbook down because I want m
friends to be able to view them without opening the correspondin
workbooks....

thanks in advance. all ideas welcome...

cheers,
Howie
http://www.digiwerkz.co
 
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.
Click to expand...
...

Can SQL.REQUEST pull any data from closed workbooks? Or does it only work with
ranges that look like database tables? For example, if all I wanted was the
value in cell A1 on some worksheet in a closed file, how would I use SQL.REQUEST
to get it?
 
Back
Top