ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to upload a Macro "Add-In" file onto EXCEL 07 workbook (https://www.excelbanter.com/excel-discussion-misc-queries/189781-re-how-upload-macro-add-file-onto-excel-07-workbook.html)

Stephane

How to upload a Macro "Add-In" file onto EXCEL 07 workbook
 
I recently upgraded to Excel 2007 from Excel 2003 and now have a unexpected
issue.

I have a file that was sent to me with a Macro "Add-In" that I need to
install on my Excel 2007 Workbook. (I new how to do it on 2003 Excel but do
not know how on 2007 Excel).

{Just to recap procedure} on 2003 MS Excel , I would save the "Add-In" file
that was e-mailed to me on my "Desktop". Then I would "open" my workbook,
click on "Tools", then click on "Add-Ins", click on "Browse", find my
"add-in" on my "Desktop" , "highlight" it , then click "OK".
That was it.

(Questions) My 1st question is, will a "ADD-IN" Macro made for 2003 Excel
work for 2007 EXCEL?

If yes, could someone help me with this procedure for MS EXCEL 2007?

PLEASE NOTE: I AM A BEGINNER USER.

THANK YOU!

stephane




Harry

How to upload a Macro "Add-In" file onto EXCEL 07 workbook
 
You can open an Excel add-in in Excel 2007 by doing the following:
1)Click the Office Button (Upper left hand corner)
2)Click Excel Options (at the bottom of the box that pops up)
3)Click Add-ins (7th line from the top on the left side)
4)Make sure Excel Add-ins is selected in the drop down box next to Manage
(at the bottom of the screen) and click GO
At this point, the screen should resemble adding an add-in from Excel 2003.
5)Click Browse
6)Click Desktop and select your add in
7)Click OK

Most add-ins from Excel 2003 should work.

Harry


"Stephane" wrote:

I recently upgraded to Excel 2007 from Excel 2003 and now have a unexpected
issue.

I have a file that was sent to me with a Macro "Add-In" that I need to
install on my Excel 2007 Workbook. (I new how to do it on 2003 Excel but do
not know how on 2007 Excel).

{Just to recap procedure} on 2003 MS Excel , I would save the "Add-In" file
that was e-mailed to me on my "Desktop". Then I would "open" my workbook,
click on "Tools", then click on "Add-Ins", click on "Browse", find my
"add-in" on my "Desktop" , "highlight" it , then click "OK".
That was it.

(Questions) My 1st question is, will a "ADD-IN" Macro made for 2003 Excel
work for 2007 EXCEL?

If yes, could someone help me with this procedure for MS EXCEL 2007?

PLEASE NOTE: I AM A BEGINNER USER.

THANK YOU!

stephane





All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com