LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default AddIn - how to create?


Hi. I'd like to ask how to create new AddIn with my own macros. It is
easy in Excel: File - Save as ... (ms addin).

BUT I want to do this with help of another macro. I tried this:

ActiveWorkbook.SaveAs _
Filename:="C:\MyMacros\MyAddin.xla", _
FileFormat:=xlAddIn
ThisWorkbook.IsAddin = True

but it doesn't work - there is something wrong with file MyAddin.xla.

Can you help me to create correct AddIn ba macro? Thanks for help,
jiri.
Excel 2002


--
antelao
------------------------------------------------------------------------
antelao's Profile: http://www.excelforum.com/member.php...o&userid=31039
View this thread: http://www.excelforum.com/showthread...hreadid=507572

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create custom menu with addin connect/disconnect dayanand108[_4_] Excel Programming 1 September 10th 05 01:27 PM
What is an addin (in Excel) and how can we create one? shajueasow Excel Discussion (Misc queries) 1 July 17th 05 04:08 AM
Mapland Excel Addin - Programatically Create 1000 distinct maps Rich Cooper[_4_] Excel Programming 1 July 27th 04 06:07 AM
Create button with addin/reference macro in another file netzig Excel Programming 2 February 6th 04 10:36 PM
Confused on MS Products to Create COM addin Bill Bell Excel Programming 2 November 9th 03 03:42 AM


All times are GMT +1. The time now is 09:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"