asked on

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?
Marco-Error.jpg
Synch-Instructions.docx
Marco-compile-Error.jpg

ASKER CERTIFIED SOLUTION

Joe Howard

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Richard Korts

ASKER

To MacroShadow

This is all generated by MS Query extracting the data from Quick Books; I cannot control that.

Joe Howard

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.

regmigrant

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 Korts

ASKER

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

Tracy

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

Not enough information to confirm an answer.

Joe Howard

Comment #a41489774 #a41489774 is the answer.