VBS Script

[JPCMcAllen]

I am new to Excel and am trying to assemble a script to copy the 1st and only worksheet in "1.xls" and paste it as a new worksheet among others in "2.xls" with the tab labeled with the date subtract 1 day that this runs. The intention is for it to run every day. Can someone assist? Thank you very much.

 

[Von Pookie]

Try:

ThisWorkbook.Sheets(1).Copy before:=Workbooks("2.xls").Sheets(1)
Workbooks("2.xls").Sheets(1).Name = Format(Date - 1, "mm-dd-yyyy")

 

[JPCMcAllen]

Response to VonPookie

Thank you. When I use your suggestion the script does not run. Can you tell me how I am supposed to apply your solution? I am using windows notebook and saving as a .vbs file to run from outside of Excel.

 

[Von Pookie]

Oh. I don't know anything about VBS. I thought you had simply used the wrong term in your subject when you meant "VB script".

At any rate, what I posted is VBA. VBS is a completely different animal, I believe. I'll move this to another part of the forum where it might go better.

 

[Norie]

What you need to do is automate Excel using the script.