| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Data from Excel 2007 XLSM workbook to Excel 2003 XLS workbook
Hi Duke, Thanks for the reply. The code I posted will pull a range of data from a 2003 workbook into a 2007 workbook and vice versa when I open either of them. In the 2003 workbook I am using the Jet engine and in the 2007 workbook I am using the ACE engine. This works fine if, but what I need is to push the data from one version to the other when I close each workbook to keep them in sync and I haven't sussed that yet. When I do, I'll post it here and hopefully it will be of use to you. Perhaps you would let me know if you crack it first. Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: Copy rows from one workbook into another without losinginterleaved data | New Users to Excel | |||
| How can excel 2000 users open a 2007 .xlsm workbook | Excel Worksheet Functions | |||
| Default a workbook to save as a xlsm (macro-enabled) in 2007 | Excel Discussion (Misc queries) | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
Threaded Mode
