ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cross-Workbook Data/Function Referance (https://www.excelbanter.com/excel-programming/317195-cross-workbook-data-function-referance.html)

Good_Ol_glr

Cross-Workbook Data/Function Referance
 
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 ?



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com