Cross-Workbook Data/Function Referance

G

Good_Ol_glr

I am in the habit of writing data-processing & computation functions in
my 'XLSTART/PERSONAL.XLS' workbook ( PRX) VBA modules> Normally , I reference
data in the active worksheet by renge or name reference.
Recently I got clever and decided that some 'global' data was better
left in my PRX workbook on a (named) worksheet, to be referenced by functions
in PRX . However, any attempt to reference data in PRX seems to fail -
aborting Excel(97).
The statements
Dim xb as workbook,xs as worksheet '1
Set xb = Workbooks("personal.xls") '2
set xs = xb.Worksheets("mydata") '3
fail at line 3.
Am I breaking some rule here ? Is their some option I need to set.
Am I just being a bad person ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross reference drop down not activating 1
Make a Sub/Function global to ALL WorkBooks? 2
VBA for Dependents shortcut menu 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Cell values to an array, then array transpose to another workbook 8
User Defined Function being called by changes to an independent workbook 13
Data aggregation with multiple workbooks 1
Reference active worksheet from macro in personal.xls 2

Top