| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to add a Macro (.bas file) in Excel?
I am a newbie when it comes to this.
Someone has a macro as a .bas file. How do I go about importing this as a button in excel? Thank you in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to add a Macro (.bas file) in Excel?
In the VBE select select File | Import and then browse to find the
appropriate .bas file. -- HTH... Jim Thomlinson "cizzo" wrote: I am a newbie when it comes to this. Someone has a macro as a .bas file. How do I go about importing this as a button in excel? Thank you in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to add a Macro (.bas file) in Excel?
I'm not sure about importing as a button, but to import a .bas file...in the
VBE go to File\Import, navigate to the folder location of the .bas file, then click the OK button. Maybe the .bas file has some commandbar code which creates a button? "cizzo" wrote in message ... I am a newbie when it comes to this. Someone has a macro as a .bas file. How do I go about importing this as a button in excel? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel '00, 1st file has macros, how to stop macro in 2nd file? | Excel Discussion (Misc queries) | |||
| how can i call macro in powerpoint file from excel file | Excel Programming | |||
| Macro to save Excel file with date and time in the file name? | Excel Programming | |||
| Creating a new excel file from an existing file using macro | Excel Programming | |||
| VBA Macro to copy an column from one Excel file into another file | Excel Programming | |||
Hybrid Mode
