How do I assign a workbook to a variable?

**bishoposiris** · 04-09-2015, 12:37 PM

I have several workbooks open. I have my VBA code in IOAlarmVBA. I have a separate workbook PLK14A_IOL_001.xlsx that I'm trying to get information from. I don't know the syntax for assigning that workbook to a variable. Here is my code:

Please Login or Register  to view this content.

**Norie** · 04-09-2015, 12:56 PM

Try this.

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 04-09-2015, 01:45 PM

Maybe:

Please Login or Register  to view this content.

How do I assign a workbook to a variable?

LinkBack

Thread Tools

Rate This Thread

Display

How do I assign a workbook to a variable?

Re: How do I assign a workbook to a variable?

Re: How do I assign a workbook to a variable?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] assign sheet to variable by code name in another workbook

[SOLVED] Assign entire row to variable, how do you paste variable values in a new workbook?

[SOLVED] Assign a variable a cell number based off off another variable that is assigned a cell num

assign variable name to the workbook

Assign the name of the workbook to a variable?

Bookmarks

Bookmarks

Posting Permissions