external reference error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: shawnvb (shawnvb.1g87dc_at_excelforum-nospam.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 06:47:01 -0600

I have a spreadsheet that contains many sheets and there are references
to particular ranges all over the place. My aim is to remove a lot of
the sheets to an external spreadsheet. I don't want to create named
ranges as this would take too much time setting up specific range
values. So I want to simply change the reference to an external
spreadsheet. An example,

I would like to change,
form.RowSource = "Functions!a1:a54"

to (using H:\[template.xls] as an example)

FunctionFormSelector.RowSource = "H:\[template.xls]Functions!a1:a54"
(this returns a "Cannot set RowSource property" error, but is just an
example as it will be reference elsewhere and not just when setting
rowsource)

I have searched excel's comprehensive help and haven't been able to
find anything. Any clues on correct syntax?

Thanks 

-- 
shawnvb
------------------------------------------------------------------------
shawnvb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16810
View this thread: http://www.excelforum.com/showthread.php?threadid=320066

Relevant Pages

  • Re: how do the macros get data from te reference tables?
    ... Data can be in hidden worksheets or hidden ranges. ... Check the formulas you can see to find out what sheets and ranges they ... >>>a) how the macros get data from the reference tables ...
    (microsoft.public.excel.misc)
  • Re: How to programatically control a 3D-sum?
    ... >Now I want to extend this to get the sum of all sheets from sheet"0" to ... >gives me #REFERENCE. ... You can't do this because of formula syntax. ... 3D references aren't ranges. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: HELP! Excel Lookup formula
    ... "tommie" wrote: ... > I have a spreadsheet with data in it that ranges from A to Q. There are two ... > sheets that hold info on eachother. ...
    (microsoft.public.excel.worksheet.functions)
  • HELP! Excel Lookup formula
    ... I have a spreadsheet with data in it that ranges from A to Q. There are two ... sheets that hold info on eachother. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: vlookup or IF
    ... A Name B Ref ... Another spreadsheet which has only name ... I need to get the reference which matches the name on both sheets into a new ...
    (microsoft.public.excel.misc)