Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saveas addin from VBA
I have a complex addin that I modify frequently. I'd like to be able to
make changes while using it, and then directly save a modified addin. I've successfully written VBA code that turns the modified addin into a workbook, and I can save that workbook, reopen it, and then save it as an addin. But if I try the shortcut of saving the workbook directly to an addin using Workbook.SaveAs FileName := S FileFormat := xlAddin, the file saved is always a workbook, not an addin, regardless of whether filename S includes a .xla extension. This is in Excel 2001 on a Mac running OS 10.3.3. Any ideas? Thanks, Dave Ring |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
saveas addin from VBA
I'd like to be able to make changes while using it, and then directly save
a modified addin. Just save it from the VBE - click the Save toolbutton while the add-in is the active project. No need to save it as a workbook first. -- Jim Rech Excel MVP "Dave Ring" wrote in message ... |I have a complex addin that I modify frequently. I'd like to be able to | make changes while using it, and then directly save a modified addin. | I've successfully written VBA code that turns the modified addin into a | workbook, and I can save that workbook, reopen it, and then save it as | an addin. But if I try the shortcut of saving the workbook directly to | an addin using Workbook.SaveAs FileName := S FileFormat := xlAddin, the | file saved is always a workbook, not an addin, regardless of whether | filename S includes a .xla extension. | | This is in Excel 2001 on a Mac running OS 10.3.3. | | Any ideas? | | Thanks, | | Dave Ring | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
saveas addin from VBA
Thanks. Didn't realize it could be that simple. But any guess why my
SaveAs addin in VBA doesn't? Dave Jim Rech wrote: I'd like to be able to make changes while using it, and then directly save a modified addin. Just save it from the VBE - click the Save toolbutton while the add-in is the active project. No need to save it as a workbook first. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
saveas addin from VBA
Hello Dave,
ThisWorkbook.IsAddin = True (before ThisWorkbook.SaveAs) does the job ... You can read more at: http://tinyurl.com/4yl33 It's an another approach, I haven't tried it, seems to be used for th older versions of Office. Good Luck, Kiril -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using SaveAs | Excel Discussion (Misc queries) | |||
Saveas | Excel Programming | |||
More help with SaveAs | Excel Programming | |||
Help with SaveAs | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |