| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you import sheets into an Excel XLA Add-In?
I'm trying to import worksheets from a spreadsheet file into an the running
XLA Add-In (the XLA holding the code for importing the spreadsheets). I tried using: Sheets(Array("Sheet1","Sheet2")).Copy After:=ThisWorkbook.Sheets(1) But got a "Run-time error '1004': Copy Method of Worksheet Class failed" error I tried using: Sheets.Add Type:=Source_File_Name, befo=ThisWorkbook.Sheets(1) But it will only add the sheets to the Active Workbook, not the XLA Workbook (if there is no open workbook I get a "Method 'Sheets' of object '_Global' failed" error). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from a particular cell in different excel sheets | Excel Discussion (Misc queries) | |||
| Import Txt file over several excel sheets | Excel Discussion (Misc queries) | |||
| Import table into Excel with lines sliced into separate sheets by UID | Excel Programming | |||
| import and search datas from different Excel Sheets | Excel Programming | |||
| Import to excel Access database directly to a variable (not using sheets) | Excel Programming | |||
Threaded Mode
