djgiron

I recently had an excel macro sent to me to help with reports on our crappy access database we have here. Well I ran the macro and of course it doesnt work. I can post the macro and the error message, can anyone give me a hand fixing it?

This ad is not displayed to registered and logged-in members. Register your free account today and become a member on RX8Club.com!

Razpewton

Yes, the macro may be searching for the merge document in it's original location. You'll have to redefine the data source to where YOU stored it on YOUR hard drive.

For example, whoever sent it to you may have stored the data source in c://documents/provisioning/mergefile.

If you can email me a screenshot of your error message, I can confirm this and give you dtailed instructions for correcting it.

razpewton@aol.com

Or post it here if you like....I only need the error message.

Mistersql

Jeez! There's finally a question on this forum where I could have lent a hand and I miss it! I was on trainning the last two days and haven't checked in.

Anyway, like razpewton said, they key's in the error message.

djgiron

Thanks for the help, i figured out that it the other database was changed (which was not supposed to happen) so after I fixed what you had said, there were other errors with the pivottables because their dB is different than mine. Well, thanks anyway!

QBallz

VBA = the d3vil!