New excel file with VB

  • Thread starter Thread starter bt707
  • Start date Start date
B

bt707

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,
 
CreateObject("Excel.Application").Workbooks.Add.SaveAs "C:\test.xls"

Ray at work
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

two same workbooks opened -- don't want this 1
userform program keeps crashing 4
Checking for open workbooks Repeat/Loop VBA code 1
How to close file from vbs? 8
Open excel file and reffer to specific worksheet 2
VBS for all xls in a folder 1
Excell 2021 0
I want to update an excel 2007 file automatically in batch mode. 1

Back
Top