excel macro worksheet to exe
- Thread starter nanobuns
- Start date
SirJB7
Excel Rōnin
Hi, nanobuns!
No, you can't.
First of all:
- worksheet is a component of a workbook
- there are no macro worksheets (unless you're using the very old Excel 4.0 macros)
- macros are VBA code hold in modules (either standard or class modules) and in worksheets and userforms class modules
- workbooks are at the file level (.xlsx, .xlsm) as an executable (.exe)
The closer you can get is compressing the .xls? file with WinRar (or any other compression software with self extraction features) and generate a .exe file to be self extracted. But not executed, since you'll need the whole Excel and part of the Office installation environment.
BTW and just curious, what do you want to convert a workbook into an executable file?
Regards!
No, you can't.
First of all:
- worksheet is a component of a workbook
- there are no macro worksheets (unless you're using the very old Excel 4.0 macros)
- macros are VBA code hold in modules (either standard or class modules) and in worksheets and userforms class modules
- workbooks are at the file level (.xlsx, .xlsm) as an executable (.exe)
The closer you can get is compressing the .xls? file with WinRar (or any other compression software with self extraction features) and generate a .exe file to be self extracted. But not executed, since you'll need the whole Excel and part of the Office installation environment.
BTW and just curious, what do you want to convert a workbook into an executable file?
Regards!
NARAYANK991
Excel Ninja
Hi ,
First , I assume that when you say worksheet , you actually mean workbook.
Googling this gives some results ; check out these two carefully , since there are some positive and some negative remarks.
http://answers.microsoft.com/en-us/...cel-file/b9919c5b-5134-4fc3-a0f5-06173b0442b5
http://www.mrexcel.com/forum/excel-questions/225463-convert-xls-exe.html
Narayan
First , I assume that when you say worksheet , you actually mean workbook.
Googling this gives some results ; check out these two carefully , since there are some positive and some negative remarks.
http://answers.microsoft.com/en-us/...cel-file/b9919c5b-5134-4fc3-a0f5-06173b0442b5
http://www.mrexcel.com/forum/excel-questions/225463-convert-xls-exe.html
Narayan