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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Garrett546

  1. Garrett546

    copy sheet from workbook into another workbook

    Here is something i found in this forum that will change the order the sheets appear. I would imagine it would be somewhat simple to modify the code to do what im trying to do, i just dont know how to without getting all types of errors. set oxl=createobject("Excel.Application")...
  2. Garrett546

    copy sheet from workbook into another workbook

    I am a begginer to VB anything and I know this has got to be a simple problem but i cant figure it out. How can i copy a sheet from an excel file to another workbook? The sheet contains a pivot table, a small formula table, and 2 charts. So I dont think i can copy a name range and have it work...

Part and Inventory Search

Back
Top