Call a specific workbook from a file location and move worksheet to different workbook

**dwhite30518** · 01-30-2014, 12:56 AM

I have moved worksheets from a workbook to a specified file path but I have not run a code that would go to a specified path, find the workbook defined and then copy a specific worksheet to a different workbook and then close the first workbook.

Ex.
I have a workbook named Raw Data and the worksheet is named Time Report. I want to go to the location where this file is saved, open the workbook, copy the Time Report worksheet and paste into my other workbook named Report. Then close the Raw Data Workbook.

How can I perform this action?

Thanks!!!!!

**HaHoBe** · 01-30-2014, 01:46 AM

Hi, dwhite30518,

did you try recording a macro woith the macro recorder for this action? It should at least give you a direction of code to use. Some sniplets that may come in handy for working on the code (this is not a working sample but just code lines that may help!):

Please Login or Register  to view this content.

Ciao,
Holger

Call a specific workbook from a file location and move worksheet to different workbook

LinkBack

Thread Tools

Rate This Thread

Display

Call a specific workbook from a file location and move worksheet to different workbook

Re: Call a specific workbook from a file location and move worksheet to different workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Input an Import file Datelastmodified info into specific location in destination workbook

Syntax to call a specific workbook and specific worksheet using VBA?

Export/move cells of excel file to specific location on an image? [HARD QUESTION]

Hyperlink to Specific Location on Worksheets in a Workbook

Copy Data from Workbook into specific Worksheet in other Workbook?

Bookmarks

Bookmarks

Posting Permissions