LinkBack URL
About LinkBacks
How do I insert an existing worksheet (previously exported from the same workbook)? I need to be able to do it programmatically.
Thank you!!
How do I insert an existing worksheet (previously exported from the same workbook)? I need to be able to do it programmatically.
Thank you!!
Hi,
You may have to provide more info, are you trying to insert a worksheet into another workbook?
I need to insert an existing worksheet into the workbook. The worksheet was previously exported (ActiveWorkbook.SaveAs) from the workbook. I need to reinsert it into the same workbook it was exported from.
Worksheets.Add Type:="C:\somePath\the file I saved earlier.xls"
Entia non sunt multiplicanda sine necessitate
RE: Insert existing worksheet into workbook
Thanks for the help. I tried it but I get an error: Run-time error '1004': Method 'Add' of object 'Sheets' failed. Any idea?
Did you change the path and filename as appropriate?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks