Desktop Application By Excel VBA

[meakashgfx]

Hello Everyone,

I designed a VBA User Form that does something automatic excel opens and copy-paste macros then close them. Instead of keep this VBA in a workbook can I compile this VBA Forms as a Desktop application anyhow?

Thanks
Akash

 

[Jaafar Tribak]

There is this freeware excel-file to exe converter which i have never tried so I don't know if or how it works :
XL to EXE Converter - XLtoEXE

 

[meakashgfx]

i thought there must be a way that visual basic studio have. thanks btw... but what if I make a VBA using visual basic studio then make it executable? I know it's sound funny.


thanks again!
Akash

 

[Jaafar Tribak]

If you have Visual Basic 6 installed, you can easily design a form and compile it as an exe .. The Form will open the excel workbook in the background, do the copying and pasting then close the workbook