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

2011-10-21 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 flanagan.se...@gmail.com 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

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

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

2011-10-21 Thread Sam Mathai Chacko
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

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 flanagan.se...@gmail.com 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

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