Re-opening an Add-In

[Jim May]

I've just encountered/learned that if I wish to "open" Test.xla file that I
earlier created -- and to add content to Sheet1, I cannot!!

When I double-click on Test.xla - up comes Book1.

Switching to the VBE - I do see the Test.xla project,
but with it currently selected I a unable to get to
the spreadsheet (App window) by clicking on the Excel
Icon (top - left).

What is someone to do if they need to do this?

Happy New Year !!

 

[Bernard Liengme]

Did you save TEXT.XLS before saving as XLA?

 

[Dave Peterson]

Addins are hidden.

You can open the VBE
Show the project explorer (ctrl-r)
Select the ThisWorkbook object in your project
Hit F4 to see the properties window

Change the IsAddin property to False
Back to excel to do what you want to

Then resave it as an addin.
(Not just an excel file with a .xla extension.)

 

[Jim May]

da..... are you suggesting that I should LOL, LOL
Ok, I understand. Opening Test.xls modifying and then
saving (again) then doing a Save-as to Test.xla REPLACE
is the route, no doubt..
Tks Bernard

 

[Jim May]

Tks, always appreciated Dave...

Addins are hidden.

You can open the VBE
Show the project explorer (ctrl-r)
Select the ThisWorkbook object in your project
Hit F4 to see the properties window

Change the IsAddin property to False
Back to excel to do what you want to

Then resave it as an addin.
(Not just an excel file with a .xla extension.)