Saving Active Workbook as Variable

**amyxkatexx** · 03-09-2010, 02:56 PM

Okay, so I have quite a few scenarios where I am needing within my macro to activate multiple workbooks.

These workbooks are often named different names, including one of which I use regularly that is a template, so every time it opens, it has a number at the end of it.

I had an epiphany that if there was a way that I could get excel to assign a variable name to an active workbook so that later in the code, it is able to go back to that workbook that is no longer active now because it has moved on to other workbooks since then, that would make life a whole lot easier.

I googled a bit, but all I could find was code that activates workbooks.

So in a nutshell, I am not needing a code that can activate a workbook. I need a code that can sort of grab whatever the name is of the current active workbook and allow me to use that later.

Any ideas?

**JBeaucaire** · 03-09-2010, 04:08 PM

Like so:

Please Login or Register  to view this content.

With this, you can use wbTemp as the template object through the rest of the macro.

**amyxkatexx** · 03-09-2010, 04:44 PM

Okay, so right now I use this code to open the workbook.

Please Login or Register  to view this content.

I have some code before it and then more code after it. But at the end, I am wanting to go back to that open template to use it again.

Where would I put that "Dim wbTemp as Workbook" part?

Would it be like this? (your code is in bold)

Please Login or Register  to view this content.

And also, what would the activate workbook code look like using that object?

Like this?

Please Login or Register  to view this content.

**JBeaucaire** · 03-09-2010, 08:36 PM

Maybe like so...the wbTemp is an object, so you can use it as such, no need to try and nest it inside an Sheet reference.

Please Login or Register  to view this content.

**royUK** · 03-10-2010, 02:27 AM

You generally do not need to activate workbooks,sheets or ranges

If your workbook is actually a template (*.xlt) then when it opens it creates a new workbook (*.xls) based on the template. So each time your code opens the template a new workbook will be created so it will need renaming.

Just a guess from your posted code

Please Login or Register  to view this content.

Saving Active Workbook as Variable

LinkBack

Thread Tools

Rate This Thread

Display

Saving Active Workbook as Variable

Re: Saving Active Workbook as Variable

Re: Saving Active Workbook as Variable

Re: Saving Active Workbook as Variable

Re: Saving Active Workbook as Variable

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions