Very visual basic
 

Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

Very visual basic
 

Hi Robert
why don't you use the toolbar print button for this :-)

--
Regards
Frank Kabel
Frankfurt, Germany

Robert Couchman wrote:
Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

Very visual basic
 

What do you mean by the current window. Printout can print an object such as
the activesheet.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in message
...
Hello and good morning to all,

i have a bit of a VB question to ask, does anyone know if
there is any code that could be used on a button so it
prints the current window to a printer??

Thank you,

Robert Couchman
)

Very visual basic
 

Of course i would use the toolbar....

if i had a toolbar on the form! :-)

any more ideas?? there all welcome!

Thank you,

Robert Couchman
)

Very visual basic
 

By current window, i mean the Form/Window that is in use!

i have a form that displays all my stats for the program,
what i would like is for a button (print) to print the
form for the user.

i know you can print the form in VB but this does not
contain the data, as this is inserted when i run the
program.

thank you,

Robert Couchman
)

Very visual basic
 

Hi
try something like
worksheets("worksheetname").printout

--
Regards
Frank Kabel
Frankfurt, Germany

Robert Couchman wrote:
Of course i would use the toolbar....

if i had a toolbar on the form! :-)

any more ideas?? there all welcome!

Thank you,

Robert Couchman
)

Very visual basic
 

Thank you Fran,

but im afraid its not a worksheet im trying to print!

its a form!

a userform!

although i might try "userformname".printout

doubt it working!

i will be back!

thank you,

Robert Couchman
)

Very visual basic **FIANL POST**
 

Good news!!!

finaly found the answer...

"userformname".printform

thank you for all the help!

Robert Couchman
)

Very visual basic **FIANL POST**
 

There wouldn't be any quotes around the name

userform1.printform

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Good news!!!

finaly found the answer...

"userformname".printform

thank you for all the help!

Robert Couchman
)

Very visual basic **FIANL POST**
 

i know but i was refering to the name of the userform!

but thanks for that anyway.

Robert Couchman
)

Very visual basic **FIANL POST**
 

So was I, no quotes.

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
i know but i was refering to the name of the userform!

but thanks for that anyway.

Robert Couchman
)