| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a selected Range to a Workbook
Glad you found the difference.
Dooley wrote: On Jun 23, 12:51 pm, Dave Peterson wrote: Open the file manually. Then go into the vbe and create a macro that displays the full name of that workbook: msgbox thisworkbook.fullname or debug.print thisworkbook.fullname And you'll see that there's a typo in your code (I betting!). (Original snipped) Thanks Dave. That was the answer. I had been using Excel97 and upgraded to 2007 as I mentioned. 2007 needs the exact name of the file and of course the file is no longer just xls but is now xlsx and that was causing the error. As usual I came to the right place for expert advice. Thanks. Dooley -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make copy of workbook based on selected criteria | Excel Worksheet Functions | |||
| How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
| copy selected cells to new workbook? | Excel Programming | |||
| Nameing a range while still selected from copy | Excel Programming | |||
| Copy selected data to new workbook | Excel Programming | |||
Hybrid Mode
