How to print an embedded spreadsheet?

[troyddaniels]

This might be an easy one, but I have an embedded excel spreadsheet that I dump data in from a database. I'm wondering how to print that worksheet out without having to export it to the actual excel application. Can anyone help me with this?

Thanks

 

[SkipVought]

Hi,

SheetObject.PrintOut

Skip,

_[red][/red]

 

[troyddaniels]

Thanks, but I tried that already and it gives me the "object doesn't support that method." error. The PrintOut command doesn't even come up in my object explorer. I can print out the window and the spreadsheet with the form.printform command but that's as far as I can get it. Am I missing a reference or something?

Thanks.

 

[SkipVought]

When you intorrogate the SheetObject in you code using the Watch Window, what kind of object does it say you have?

Skip,

_[red][/red]

 

[troyddaniels]

When I add a watch to the object it says "object out of context", and that it's type is "empty". That's if I add the .printout command to it. If I add a legit command it tells me that it is a variant/object/spreadsheet.

 

[SkipVought]

Well, maybe, instead of taking in coded terms, you might post...

1. the code that SETS the object as well as

2. the code that errors.

Skip,

_[red][/red]