Record Microsoft Excel Macro

I'm trying to record a macro to simplify some data import steps.

I started Record Macro then did all the other stuff. The attached Word doc has the steps, I'm trying to cover steps 3 through 7 with a macro,

I do the steps, it returns the data to the spreadsheet, then gives the attached Macro Error.jpg

If I then go to the macro and say Run (to do it over), it gives the attached Compile Error.

What's wrong?

How do I fix it?
Richard KortsBusiness Owner / Chief DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

As the error message says, the are too many line continuations.
There is no reason for the comma and line continuation between lines, move them to the end of the previous line.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Richard KortsBusiness Owner / Chief DeveloperAuthor Commented:
To MacroShadow

This is all generated by MS Query extracting the data from Quick Books; I cannot control that.
No problem, just alter the code. Reducing the comma and line continuations. If you upload the code I'll show you exactly what to do.
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

Richard - once you've created the query and followed MacroShadow's advice on getting it going you can save it so you won't hit the same problem every time, the first few steps of the notes will be replaced by the recorded query
Richard KortsBusiness Owner / Chief DeveloperAuthor Commented:

I have not abandoned  this post, I have not had time to work on this lately because of other pressing isues.

I will show you the code.

TracyVBA DeveloperCommented:
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
Comment #a41489774 #a41489774 is the answer.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.