| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet from file to file
Excel XP & Win XP
wbFile2 and wbFDB are variables and are set to 2 open workbooks. Both have a sheet called "Names". I want to delete the "Names" sheet in wbFDB and copy the "Names" sheet from wbFile2 to wbFDB. The sheet does get deleted in wbFDB. Good! But the last line, to copy the sheet, does not work. Sub CopyNamesSht() 'wbFile2 is the active workbook Application.DisplayAlerts = False wbFDB.Sheets("Names").Delete Application.DisplayAlerts = True Sheets("Names").Copy After:=wbFDB.Sheets("COJDatabase") End Sub What am I doing wrong in the last line? Thanks for your time. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
| Copy data from one file sheet into another | Excel Programming | |||
| Lookup on a sheet so that every time when file open it copes data from another file sheet | Excel Programming | |||
| Copy sheet to a new file | Excel Discussion (Misc queries) | |||
| Copy sheet to another specified file | Excel Programming | |||
Threaded Mode
