New excel file with VB
 

Can anyone tell me what the code is I need to use in a VBS file were if
I click on it then it will automatically open Excel and make a new file
and save it as a Excel file, Ex: test.xls


Thanks,



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

New excel file with VB
 

CreateObject("Excel.Application").Workbooks.Add.Sa veAs "C:\test.xls"

Ray at work


"bt707" wrote in message
...
Can anyone tell me what the code is I need to use in a VBS file were if
I click on it then it will automatically open Excel and make a new file
and save it as a Excel file, Ex: test.xls


Thanks,



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/