add-in back to spreadsheet


A

Andrew McMichael

A colleague (no, seriously) here accidentally saved her spreadsheet as
an add-in. Is there any way of getting it back to spreadsheet? (Office
2000, no copy of VBasic).




Andrew McMichael
 
Ad

Advertisements

A

Andrew McMichael

Andrew said:
When I open it, nothing appears in the spreadsheet.



I should also add that the add-in shows a size of 29k, so there's
*something* there. But when I try to open it, Excel clearly loads
*something*, but nothing appears in the spreadsheet.




Andrew
 
A

Anders S

You can use the VBA Editor to fix this.

- start Excel
- open the addin, "nothing" will happen, as you have noticed
- open the VBA editor - Alt+F11
- if not already open, open the Project Browser - Ctrl+R or View->Project
Browser
- find the addin in the Project Browser, expand it and select "ThisWorkbook"
- if not already open, open the Properties window - F4 or View->Properties
- find the IsAddin property and change it to False
- go back to Excel. The former addin is now visible. Save it as .xls and your'e
done.

HTH
Anders Silvén
I don't have a US/English version of Excel so the menu choices may not be
excactly correct, but you will get it.
 
D

Dave Peterson

Open your addin.
Hit alt-F11 to get to the VBE (where macros live)
hit ctrl-R to show the project explorer (like windows explorer)

click on your workbook/project.
Hit the asterisk on the number keypad to view all the components
click on the "ThisWorkbook" module
hit F4 to view the properties

Scroll down until you see IsAddin. Change that to False

Back to Excel and save your workbook normally.

======
If you like typing:
load your addin
hit alt-f11 (back to the VBE)
hit ctrl-G to see the immediate window.

type this and hit enter:
workbooks("myaddin.xls").isaddin = false
(change myaddin.xls to your filename.)
Back to excel and save normally.
 
Ad

Advertisements

Ad

Advertisements


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

Top