Opening Notepad from Excel
Thanks
"Dave Peterson" wrote:
You want a 0 byte file?
Option Explicit
Sub testme()
Open "C:\Test.kml" For Output As 1
Close #1
End Sub
Be careful with this. If that file exists, then it's emptied. If it doesn't
exist, it'll be created.
(Change the path to what you want.)
Ayo wrote:
I am trying to write a VBA code that does the following:
1. open Notepad from inside Excel
2. Save a blank file (i.e, Save as Test.kml)
3. Close the Notepad
--
Dave Peterson
.
|