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 !!

Did you save TEXT.XLS before saving as XLA?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jim May" wrote in message
...
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 !!

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 wrote:

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 !!

--

Dave Peterson

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

"Bernard Liengme" wrote:

Did you save TEXT.XLS before saving as XLA?
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jim May" wrote in message
...
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 !!

Tks, always appreciated Dave...

"Dave Peterson" wrote:

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 wrote:

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 !!

--

Dave Peterson