macro to create executable file

[ArtemUBRR]

Hi everyone!

I have a macro witch start refresh save and close qwv file.

Sub ReloadThisDoc

    Set fso = CreateObject("Scripting.FileSystemObject")    

    If fso.FileExists("C:\Вызовы Naumen.txt") Then

        ActiveDocument.Reload

        ActiveDocument.Save

        ActiveDocument.GetApplication.Quit

    end if

    set fso=Nothing

End Sub

Now, i need to create exe through the macro

Please, help me!

[marcus_sommer]

If you have a running vbs-macro you could probably do everything what you like to do - an extra generation of an executable file might not be necessary. Even if you could create an appropriate txt-file, giving it an extension like bat/cmd/vbs. Nothing of it is specially related to Qlik and so you will get better and faster results in regard to examples and explanations within any vb/vbs/vba-forum.

- Marcus

[Hoffman14]

To render a macro to an EXE file simply click "Compile to EXE" under the "File" menu item. IMPORTANT NOTE: if your macro contains mouse movements and clicks, this macro is screen resolution-sensitive. Running a compiled EXE-file on another computer with a different screen resolution will result in improper playback. My Ascension