Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling a macro as a .exe?
I am looking for a way to format a file output by means of a macro, but
I do not want to actually open Excel. Is this possible? Ideally, I would like to run a command from my program that outputs an xls fila nd runs the macro that formats the workbook, then continue to import it in it's new formatting, without having to break and wait for confirmation from the user. 1. Program outputs .xls file 2. Macro formats .xls file 3. Program imports .xls file 4. Further instruction... Is it possible to take your Excel macro code and somehow compile it as an executable file, that will run the macro without showing excel, or even run a macro from the command line (eg. c:\...\excel.exe -sheet.xls -format.bas)? Cheers, tehwa --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling a macro as a .exe?
Not as smart as I thought I once was, but, no, I don't believe there's a
way to compile a VBA macro. -- Regards; Rob ------------------------------------------------------------------------ "tehwa" wrote in message ... I am looking for a way to format a file output by means of a macro, but I do not want to actually open Excel. Is this possible? Ideally, I would like to run a command from my program that outputs an xls fila nd runs the macro that formats the workbook, then continue to import it in it's new formatting, without having to break and wait for confirmation from the user. 1. Program outputs .xls file 2. Macro formats .xls file 3. Program imports .xls file 4. Further instruction... Is it possible to take your Excel macro code and somehow compile it as an executable file, that will run the macro without showing excel, or even run a macro from the command line (eg. c:\...\excel.exe -sheet.xls -format.bas)? Cheers, tehwa --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compiling data from multiple Excel sheets - macro? | Excel Worksheet Functions | |||
Macro compiling screen | Excel Discussion (Misc queries) | |||
Compiling | Setting up and Configuration of Excel | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
compiling? | Excel Programming |