By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,060 Members | 1,893 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,060 IT Pros & Developers. It's quick & easy.

Question: Application-defined or object-defined error when trying to print a macro

P: n/a
Hi there,

I want to print a macro out to enable me to debug it and convert it to
more sensible operations giving users more control.

I get the error message:

Application-defined or object-defined error

With no other information when i try to do so.

Anyone got any ideas?

I'll probably just have to write them down for now.

And i promise no more questions today... i hope.

Rob.

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
How about converting it to VBA code?
Much easier to debug and adapt!
"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi there,

I want to print a macro out to enable me to debug it and convert it to
more sensible operations giving users more control.

I get the error message:

Application-defined or object-defined error

With no other information when i try to do so.

Anyone got any ideas?

I'll probably just have to write them down for now.

And i promise no more questions today... i hope.

Rob.

Nov 13 '05 #2

P: n/a
Er that's what i want to do... but i want to print it out as it is
massive so i can work from the printout.

I can find the error message elsewhere but it gives me no clues as to
why it should appear for a print action.

Thanks Mac but anyone else got a better plan?

Nov 13 '05 #3

P: n/a
Just to make sure my suggestion is clear:
Select your macro in the Database Window.
Click File - SaveAs.
give your new module a name
in the lower drop-box, select Module
click OK.
This will automatically create your code for you.
You should also be able to print from the code window. (not the macro
window)

If that's what you were already doing, please accept my apologies for the
misunderstanding.

HTH

"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
Er that's what i want to do... but i want to print it out as it is
massive so i can work from the printout.

I can find the error message elsewhere but it gives me no clues as to
why it should appear for a print action.

Thanks Mac but anyone else got a better plan?

Nov 13 '05 #4

P: n/a
Dude,

I had no idea I could do this. It's so obvious...

Thanks for your help on this.

Rob.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.