How to call a "xla" object itself?

  • Thread starter Thread starter JohnDing
  • Start date Start date
J

JohnDing

When open a "xla" file I find that the Activeworkbook
object is Nothing, so I don't know how to call this object.
Could s.b. tell me how to do that. I need the function to
perform further actions, such as Saveas, etc..
 
How do you open the xla, by installing it, or opening like a regular file?

Where is the code referencing Activeworkbook?

HAve you tried Thisworkbook?
 
You must log in or register to reply here.

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

location of an installed xla 2
XLA problem 1
Handling a worksheet calculate event in XLA code 4
Saving a .xla File 3
Two functions of the same name in seperate xla's 1
culture mismatch with Button name and get_Caller 1
XLA development best practices 3
.XLA's Code Not Available? 2

Back
Top