Excel crashes when macro executed

DMKetcher
DMKetcher used Ask the Experts™
on
Hi Experts!

I am having trouble with my laptop crashing - getting the message "Microsoft Excel has stopped working....". It does it most often when I am working in the attached Excel VBA. Any ideas?
Finding-19-Macro-for-EE.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, DMKetcher.

Can you post a copy of the file, please? I assume that you will need to redact the data, but please check that the file still crashes.

Thanks,
Brian.
DMKetcherConsultant

Author

Commented:
This works by having both input and output spreadsheets open and switching to the output spreadsheet when it is asked for.
Ineligible-Sites-Transpose-Input.xlsm
Ineligible-Sites-Transpose-Outpu.xlsx
Thanks, DMKetcher.

The XLSM is corrupt, so please see the attached rebuild and let me know how it behaves. (BTW, I've renamed column A  - I'll explain later.)

Edit: I reloaded the file - this version includes the necessary ADO 2.5 Library reference. (Well, for Excel 2010 - it may need to be changed for other versions.)

Regards,
Brian.Ineligible-Sites-Transpose-Input.xlsm
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

DMKetcherConsultant

Author

Commented:
Perfect - Thank you!
DMKetcherConsultant

Author

Commented:
Thank you! I changed I.D. to ID. Am I not allowed to use SSN or is it just too risky for internet business?
Thanks, DMKetcher.

OK, explanation time - why did I change "ID" to "I.D."? The file was corrupt so the first step in recreating it was to save it as CSV (so that the corruption would be removed). However, there's a funny/bug/whatever in Excel that treats any file starting with "ID" as a SYLK file. So, to avoid any issues, I renamed the column.

Am I not allowed to use SSN or is it just too risky for internet business?
Sorry, I don't understand what you mean. If this is still about column A then it really doesn't matter whether you call it "ID", "I.D." or "SSN" - as long as you don't save it as a CSV.

Regards,
Brian.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial