Excel crashes when macro executed

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
DMKetcherAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
redmondbConnect With a Mentor Commented:
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
0
 
redmondbCommented:
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.
0
 
DMKetcherAuthor 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
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
DMKetcherAuthor Commented:
Perfect - Thank you!
0
 
DMKetcherAuthor 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?
0
 
redmondbCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.