asked on 3/3/2016

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

Microsoft Excel VBA

Last Comment

Joe Howard

4/10/2016

ASKER CERTIFIED SOLUTION

Joe Howard

3/3/2016

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Richard Korts

3/3/2016

ASKER

To MacroShadow

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

Joe Howard

3/3/2016

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

3/3/2016

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

3/17/2016

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

4/8/2016

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

Not enough information to confirm an answer.

Joe Howard

4/10/2016

Comment #a41489774 #a41489774 is the answer.