Edit a .xls add-in

[theta]

Hi, I am using Excel 2007 and wish to open (holding shift) a .xls add-in file.

I get a message from excel stating that :

"Cannot open Microsoft Office Excel Add-In for editing. Please edit the source document instead."

There are tabs in this add-in that contain data I need to change. I have the password / access required as it is an internal product. Just this error is preventing me from accessing the .xls as a workbook.

 

[shg]

You mean an xla file?

Open Excel normally and load the add-in if it isn't already. Select the add-in's VBA project in the Project Explorer window, and in the Immediate window, enter

Thisworkbook.IsAddin=False

 

[Jonmo1]

In the VBA window
Expand the Addin Project - Microsoft Excel Objects - ThisWorkbook
click View - Properties Window
Find the property - IsAddin
Change to False
click SAVE.

Now you can open it as a workbook.
But of course it will no longer function as your addin..

make sure to set it back to true and save when done.

 

[theta]

Nope it is a .xls but think in the auto_open it has been defined to open as an addin.

Just started to use the immediate window - this is a way of running quick changes to a VBA project and change variable values? (any help appreciated)

How could I print every active (declared) variable with values and type?

 

[shg]

this is a way of running quick changes to a VBA project and change variable values?

Yes, for any variable in scope when the code is paused; e.g.,

myString = "Bob"
 
set myRange = range("a1:b3")

 

[theta]

And is there any way to debug.print every declared/used variable along with type (boolean, string, byte) and value?

This would be very useful when debugging!

 

[shg]

None I know of, but you can hover over variables to see their values, or look in the Locals window.

 

[theta]

The code worked thanks now have access to all tabs.

With regards to 'locating' the property - I do not get this option?

Do you mean locate it in the code, or by exploring the properties of an actual object?

The types command in the immediate windows did the trick, just asking for my own education.

 

[shg]

Press F4 in the VBE to see the Properties window.