Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jers
  • Order by date
  1. jers

    Copy an Excel worksheet to another workbook

    Hi, I'm trying to copy an Excel worksheet to another workbook using a vbscript. What is the correct syntax for VBA's After:= in vbscript (so it doesn't expect the end of a statement here)? Thanks, jers xlapp.Worksheets("Buy List").Copy After:=Workbooks("Print List.XLS").Worksheets(1)

Part and Inventory Search

Back
Top