can we convert .xls to exe..please Ryan..respond coz i saw some1 do it and install with .bat command


Posted by 123 on June 29, 2000 11:50 PM

cc

Posted by 123 on July 01, 0100 1:02 AM

thanks ivan..the truth is i don't understand it all. could you be more details and specific. if i'm don't bother you.i'm just beginning to learn excel.regards

Posted by Ivan Moala on July 01, 0100 1:18 AM

Re: thanks ivan..the truth is i don't understand it all. could you be more details and specific. if i'm don't bother you.i'm just beginning to learn excel.regards

123

email me what you have in the way of any coding
OR what you would like to do exactly.
I find it better explaining it with a workbook example.


Ivan

Posted by 123 on July 01, 0100 2:14 AM

thanks ivan. you are very kind. i will mailed you soon. regards Excel Guru

email me what you have in the way of any coding



Posted by Ivan Moala on June 30, 0100 2:06 PM

What you may have seen is a exe file converter
such as PKZip been executed.
To do this from VBA have a look @ the shell command.
eg

Sub Do_exe()

Dim Proc As Variant

' The first argument "dosomething.bat" is the DOS
' batch file to be run. This example assumes that
' it is located in the same directory (folder) as
' the Excel workbook. Otherwise, you will need
' to be explicit with the path to your DOS file.
' or use CDir to change to the file dir.
' Also, the number 6 in the second argument
' instructs the program to run in an iconized
' window and maintain the current window as the
' active window.
'Note:
'The Shell function runs other programs asynchronously.
'This means that a program started with Shell might not finish
'executing before the statements following the Shell function are executed.

Proc = Shell("dosomething.bat", 6)

End Sub


HTH

Ivan