Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-21 Thread Sam Mathai Chacko 
Although vastly off topic, Excel 2010 is Excel 14. MS skipped one number 13,
probably because of all the beliefs associated with that number :D

Regards,

Sam Mathai Chacko (GL)

On Fri, Oct 21, 2011 at 6:26 PM, dguillett1  wrote:

> May be best to post your code and even your file.
>
>
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Sean
> Sent: Thursday, October 20, 2011 3:38 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes
> (or different approach)
>
>
> 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
> --
> --**--**
> --
> 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
>



-- 
Sam Mathai Chacko

-- 
--
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

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-21 Thread dguillett1 

May be best to post your code and even your file.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Sean

Sent: Thursday, October 20, 2011 3:38 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or 
different approach)


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 


--
--
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

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread ashish koul 
Hi Sean

you can use it will "all xls" or "all xlsx"



On Fri, Oct 21, 2011 at 9:20 AM, Sean  wrote:

> Hi sir, and thank you for your assistance.
>
> I like your macro very much.  Sadly, it does not bring joy.  However,
> it has helped me to discover that the problem is not with my system or
> version of Excel.  The problem is with the target files, which cause
> cause Excel to crash on opening.  I suspect that the files have been
> saved in Excel 2010 (is that Excel 13?) with features inimical to
> Excel 2007.
>
> I regret the wild goose chase down a blind alley, yet I am profoundly
> grateful for the aid and the neat macro that you have provided.
>
> I will have to mark this problem "Solved"
>
> Warm regards,
> -Sean-
>
> On Oct 20, 10:19 pm, ashish koul  wrote:
> > hi Sean
> > try this macro. select the folder which  is having all the excel files.
> >
> >
> > On Fri, Oct 21, 2011 at 2:08 AM, Sean  wrote:
> > > Hi and thanks for your interest in my post.
> >
> > > 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 athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://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
> >
> > --
> > *Regards*
> > * *
> > *Ashish Koul*
> > *http://www.excelvbamacros.com/*
> >
> > P Before printing, think about the environment.
> >
> >  MERGE DATA MACRO.xlsm
> > 27KViewDownload
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread Sean 
Hi sir, and thank you for your assistance.

I like your macro very much.  Sadly, it does not bring joy.  However,
it has helped me to discover that the problem is not with my system or
version of Excel.  The problem is with the target files, which cause
cause Excel to crash on opening.  I suspect that the files have been
saved in Excel 2010 (is that Excel 13?) with features inimical to
Excel 2007.

I regret the wild goose chase down a blind alley, yet I am profoundly
grateful for the aid and the neat macro that you have provided.

I will have to mark this problem "Solved"

Warm regards,
-Sean-

On Oct 20, 10:19 pm, ashish koul  wrote:
> hi Sean
> try this macro. select the folder which  is having all the excel files.
>
>
> On Fri, Oct 21, 2011 at 2:08 AM, Sean  wrote:
> > Hi and thanks for your interest in my post.
>
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
> P Before printing, think about the environment.
>
>  MERGE DATA MACRO.xlsm
> 27KViewDownload

-- 
--
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

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread Sean 
As a follow-up, running the macro against files which have been
converted (using OpenOfficeCalc) to .xls files produces a spreadsheet
that is very useful, proving that my difficulty is not in the macro.

And oh, how I wish I could use it against all the .xlsx files!

Warm regards,
-Sean-

On Oct 20, 10:19 pm, ashish koul  wrote:
> hi Sean
> try this macro. select the folder which  is having all the excel files.
>
>
> On Fri, Oct 21, 2011 at 2:08 AM, Sean  wrote:
> > Hi and thanks for your interest in my post.
>
> > --
>
> > --- 
> > ---
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
> P Before printing, think about the environment.
>
>  MERGE DATA MACRO.xlsm
> 27KViewDownload

-- 
--
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

Re: $$Excel-Macros$$ Need help resolving runtime errors and crashes (or different approach)

2011-10-20 Thread ashish koul 
hi Sean

try this macro. select the folder which  is having all the excel files.



On Fri, Oct 21, 2011 at 2:08 AM, Sean  wrote:

> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
--
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


MERGE DATA MACRO.xlsm
Description: Binary data