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")...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.