Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

Printing A form

Hi, i am using VB for applications in Excel. I have a program with which i would like to print the form. I have had no hassle doing so by using the printform command but what i would like to do is have the "Report" that it prints in the center of the screen. Is this possible with VBA as i found it very simple using VB6.

Here is what i would normally use

printer.CurrentX = (printer.Width - Editscreen.Width) / 2
printer.CurrentY = (printer.Width - Editscreen.Width) / 2
Editscreen.PrintForm

When i take out the "printer....." lines it works fine but surprise surprise when i try to use them i get an error.

This is probably a very simple question and the answer is probably No you can't do it, but if i get an answer that says i can i will give out 125 points. If the answer is just no then it'll be a 50.

Thanks

Scott
0
scotster
Asked:
scotster
  • 2
1 Solution
 
Javin007Commented:
"what i would like to do is have the "Report" that it prints in the center of the screen."

Not quite following you, here.  You talking about doing a print preview, or what?

-Javin
0
 
scotsterAuthor Commented:
Sorry i meant the center of the paper. When i print it out via the printer it puts it to the top left. If possible i would like it to print to either the top center or center of the paper.

Thanks
0
 
scotsterAuthor Commented:
Ok i'm going to ask for a refund on this as noone has been willing to help out.

Scotster
0
 
NetminderCommented:
Closed, 50 points refunded.
Netminder
Site Admin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now