The Andrew N. Wiggins Consultancy

Contact me at webmaster@anw.biz

Experimental Site

 

This site designed by Byg Software Ltd

 

The ANW.BIZ Home Page
Up

Save as Xla

Save a file as an add-in
   
Sub SaveAsAddin()
    Application.DisplayAlerts = False
    Windows("xla_test.xls").Activate
    With ActiveWorkbook
        .IsAddin = True
        .SaveAs "c:\byg\xla_test.xla", FileFormat:=xlAddIn
    End With
    Application.DisplayAlerts = True
End Sub
   

Published: 17 January 2004
Last edited: 19 May 2008 16:43