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. But can I compile this VBA Forms as a Desktop application anyhow?

Thanks
Akash

 

[V_Malkoti]

A VBA UserForm resides inside the workbook in which it was designed. But you can trigger the macro inside the workbook from an executable file. I created a VBS file with following code:

Set objExcel=CreateObject("Excel.Application")
objExcel.Visible=False
Set objWorkbook=objExcel.Workbooks.Open("[COLOR=#0000ff]C:\TestingResults\MacroFile.xlsm[/COLOR]")
objExcel.Run "[COLOR=#0000ff]TriggerTest[/COLOR]"
objExcel.DisplayAlerts = false
objWorkbook.close
objExcel.quit

And inside the workbook I created the sub

Sub TriggerTest()
    frmTest.Show
End Sub

With this setup you see the form, but not the Excel application.

 

[meakashgfx]

well, it's a wonderful idea. i will try and get back to you soon.


Thanks!