PC Review


Reply
Thread Tools Rate Thread

How to add a Macro (.bas file) in Excel?

 
 
cizzo
Guest
Posts: n/a
 
      27th Nov 2007
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 With Quote
 
 
 
 
Jim Thomlinson
Guest
Posts: n/a
 
      27th Nov 2007
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.
>

 
Reply With Quote
 
M. Authement
Guest
Posts: n/a
 
      27th Nov 2007
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" <(E-Mail Removed)> wrote in message
news:31146f2d-c05c-41c1-953b-(E-Mail Removed)...
>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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
personal excel macro causing access not to open excel file Dustin Microsoft Access 0 17th Jul 2009 04:06 PM
internet connection via excel macro at timed intervels & save data to excel file. Sam Microsoft Excel Programming 3 26th Jul 2007 12:50 AM
internet connection via excel macro at timed intervels & save data to excel file. Sam Microsoft Excel Worksheet Functions 1 22nd Jul 2007 06:08 AM
VBA Excel Macro - One File Auto Create Multiple Excel Worksheets! jsamples25 Microsoft Excel Programming 0 22nd Jun 2005 11:16 PM
ASP: Open Excel File with Macro, Allow Macro to run, and then save =?Utf-8?B?ZGVsZ2Fkb3MxMjk=?= Microsoft Excel Programming 0 10th Mar 2005 09:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:56 PM.