Hi
I have a programme that creates a notepad document, log.txt. I want this document to be opened in Excel and don't want to see log.txt. I'm not sure why it has to go to Excel but Big Boss says that's where it has to go!
Thanks in advance
V
Printable View
Hi
I have a programme that creates a notepad document, log.txt. I want this document to be opened in Excel and don't want to see log.txt. I'm not sure why it has to go to Excel but Big Boss says that's where it has to go!
Thanks in advance
V
Have you tried Shelling Excel with the Log.txt File as a CommandLine Parameter? ie.
------------------Code:Private Sub Command1_Click()
Call Shell(Chr(34) & "C:\Program Files\Microsoft Office\Office\Excel.exe" & Chr(34) & " C:\Log.txt", vbNormalFocus)
End Sub
Aaron Young
Analyst Programmer
[email protected]
[email protected]