| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to import from one closed workbook
I figured out the error 400 has to do with protected sheets... now my problem is that everything is supposed to be importing to sheet two and it goes to sheet one. The code is written on sheet two...is there something I am doing wrong...or is there extra coding that needs to be in there to make it work correctly. I must have it go to sheet two because sheet one gets imported into a contact manager that reads the first sheet only. -- jermsalerms ------------------------------------------------------------------------ jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167 View this thread: http://www.excelforum.com/showthread...hreadid=498548 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| closed workbook macro | Excel Discussion (Misc queries) | |||
| Import data from a closed workbook | Excel Discussion (Misc queries) | |||
| import all sheets from a closed workbook | Excel Programming | |||
| Import Sheet from Closed Workbook | Excel Programming | |||
| Using Querytable.add to import data from a closed workbook | Excel Programming | |||
![jermsalerms[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
