Convert Excel Macro to Executables

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Nagarajan S

Thread Starter
Joined
Jun 18, 2007
Messages
8
Hi,

I want to convert Excel macro to Executables, so that i can call that from another application to run.

let me know, if u have idea on it..

Nagarajan S
 
Joined
Jun 17, 2002
Messages
2,551
you need to put your code in the "This Workbook" section of the project.

Private Sub Workbook_Open()




End Sub

You can easily access this by right clicking on the Excel icon in the top right corner of the Excel window...choose "View code".

Any code there will execute when the book is opened, set your Excel Security (Tools/macro/Security) to "LOW" so it will not be held up by the pop up to enable macros
 
Joined
Sep 4, 2003
Messages
4,912
As Ziggy has already indicated, you can add the code to the Workbook_Open event and it will fire automatically whenever the workbook is opened. Once you do this you simply need to add code to your other applications to open the workbook. You also have the option of creating a stand alone VBS script which you can call from other applications

If you want a true .EXE file to be created you will need to purchase the full version of VB to create and compile your project.

Regards,
Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top