Record Microsoft Excel Macro

Richard Korts
Richard Korts used Ask the Experts™
on
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?
Marco-Error.jpg
Synch-Instructions.docx
Marco-compile-Error.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
Richard KortsBusiness Owner / Chief Developer

Author

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.
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

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 Developer

Author

Commented:
Macroshadow,

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.

Richard
TracyVBA Developer

Commented:
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.

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