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
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
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
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