Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create XLA?
Hello,
I have an Excel file with macro. Can I create an Excel addin (XLA) with that macro, and how? I was playing around creating XLA by creating a macro Custom Menu Item in the Customize section of Excel. Then I attached the macro to the menu item and dragged the menu item into the Tools menu list. Then I saved the Excel file as .XLA. It saved in the XLA directory in C:. When I click on the addin under Tools, I got a Security Warnings window. First of all, am I supposed to receive the Security Warnings window? All the Excel addins that I have seen do not have the Security Warnings windows. Did I do something wrong? How can I avoid it? Secondly, did I do it correctly as far as creating an XLA? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create XLA?
First read:
http://www.cpearson.com/excel/createaddin.aspx -- Gary''s Student - gsnu200757 "Please Help" wrote: Hello, I have an Excel file with macro. Can I create an Excel addin (XLA) with that macro, and how? I was playing around creating XLA by creating a macro Custom Menu Item in the Customize section of Excel. Then I attached the macro to the menu item and dragged the menu item into the Tools menu list. Then I saved the Excel file as .XLA. It saved in the XLA directory in C:. When I click on the addin under Tools, I got a Security Warnings window. First of all, am I supposed to receive the Security Warnings window? All the Excel addins that I have seen do not have the Security Warnings windows. Did I do something wrong? How can I avoid it? Secondly, did I do it correctly as far as creating an XLA? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create XLA?
Hi Gary's Student,
Thanks for the source. I have briefly looked up it, and I think that is what I need. Thanks. "Gary''s Student" wrote: First read: http://www.cpearson.com/excel/createaddin.aspx -- Gary''s Student - gsnu200757 "Please Help" wrote: Hello, I have an Excel file with macro. Can I create an Excel addin (XLA) with that macro, and how? I was playing around creating XLA by creating a macro Custom Menu Item in the Customize section of Excel. Then I attached the macro to the menu item and dragged the menu item into the Tools menu list. Then I saved the Excel file as .XLA. It saved in the XLA directory in C:. When I click on the addin under Tools, I got a Security Warnings window. First of all, am I supposed to receive the Security Warnings window? All the Excel addins that I have seen do not have the Security Warnings windows. Did I do something wrong? How can I avoid it? Secondly, did I do it correctly as far as creating an XLA? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
create Macro €“ select data, sort by acc no., yr, part no, create P | Excel Programming | |||
How to create adress list so can mail merge and create labels? | Excel Discussion (Misc queries) | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
Create dictionary of terms, create first time user site | New Users to Excel |