View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kletcho@gmail.com is offline
external usenet poster
 
Posts: 11
Default Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it.

Sorry, I have been using VBA for too long. You do not need a sub open
statement and end statement with vb script. Here is what you put in
the file:

Dim objXL
Dim fso
Dim strFile


Set objXL = CreateObject("Excel.Application")
Set fso = CreateObject("Scripting.FileSystemObject")


strFile = InputBox("Address and file name")
If fileSystem.FileExists(strFile) Then
objXL.Workbooks.Open("c:\excel\MySpreadsheet.xls")
Else
objXL.Workbooks.Add()
End if