I have a macro that runs in excel. I would like to be able to run this as an executable.
Right now the macro reads off values in the excel file and creates a text file capable of importing into another program for formatting reasons. Here is what I would like to do.
I would like to create an executable that when ran, does the following
1. Opens or simply reads the created excel file through the Microsoft common dialog
2. Performs the code written to read the values in the excel file and create the text file.
Basically I need a way of associating the macro code in a stand alone executable environment. I can get the common dialog interface to run and select the excel file, but I don't know how to get the code to work outside of the macro.
example code from part of the macro.
Range("C2").Select
topmask = ActiveCell.Value
Obviously the macro knows what excel file, sheet, ect I am referencing since it is opened with the excel file. I need help associating the file chosen through the dialog with this code. Help!!!!
Bookmarks