Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LuiCiphier
- Order by date
-
Accessing Variables Between Excel Spreadsheets
Got it! The other workbook has to be added as a reference (like plugins). And there is no mention of this in Excel help (that I could see!) Cheers anyway.- LuiCiphier
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Accessing Variables Between Excel Spreadsheets
I tried declaring the array as global and this had the same effect. Basically, I want to something like this: CalcArray() contains the data within the called (hidden WBk1) spreadsheet NewTotal() Is the array within the current Workbook(WBk2) - the Workbook that is calling the macros within...- LuiCiphier
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Accessing Variables Between Excel Spreadsheets
Hello all, I've written a spreadsheet (WBk1) that runs macros within another spreadsheet (WBk2) to create an array of data. How do I access this array from WBk1? I think I'm overlooking something obvious but I always get "Object doesn't support this property or method" errors. The...- LuiCiphier
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
