Hi and thanks for your interest in my post.
I'm using in MSExcel 2007 and using code I've found in various forums
and published by MVPs, to perform some column copying
. Some of the code were macros, and one is an add-in. All fail, but
with different faults.
I used a macro from Microsoft 'MergeHorizontally' which crashes Excel
when trying to open spreadsheets identified with an array:
Set mybook = Workbooks.Open(MyPath & MyFiles(FNum))
I used macros developed by Ron de Bruin, Microsoft MVP - Excel
including 'CopyRange' and 'CopyRangeValues'. These halt with run-time
error 445 - Object doesn't support this action on the line:
With Application.FileSearch
In my troubleshooting, I founda a wonderful add-in utility that Ron de
Bruin created, 'RDBMerge'. This produces a different automation error
(Error 440)
Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients.
Object doesn't support this action (Error 445)
I suspected my Exccel installation, yet I have installed Office 2007
on another computer and get the same results.
Any suggestions would be gratefully received.
(If it matters, I have perhaps 200 .xlsx workbooks with various names
having mostly twenty or so rows (but as many as 1500) in the first 13
columns that I wish to copy-append into one spreadsheet. I desire
some functioning code because my VBA skills are many years out of
date.)
Regards,
-Sean-
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
