Solved

create a custom paper size in vba

Posted on 2013-12-29
3
1,230 Views
Last Modified: 2014-02-25
I have an application that uses a 8.5 x 13.25 I would like to check to see if the custom paper size is already created if it's not create a custom  paper size and name it report1_custom_size.
thanks
0
Comment
Question by:Svgmassive
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 20

Expert Comment

by:clarkscott
ID: 39746033
You may have trouble with this.  Reports are based on printer capabilities.  You cannot force a "normal page size" printer to print on paper larger than it can handle.

Therefore, I suggest you create the report - force it to a specific printer.

You can check to see if the specific printer is available per the PC, and you can check to see if the specific report exists, but you'll find much issues with trying to do this "on the fly".

At least per my knowledge.....

Scott C
0
 

Accepted Solution

by:
Svgmassive earned 0 total points
ID: 39746361
hi clarkscott thanks for your response.I can create a custom  page setup in the print properties,give the setup a name the when the user selects the report the custom paper size name is selected not a problem.The problem for distribution purposes i am trying to avoid the user from selecting the printer properties to create the custom paper size i would like to create the custom set up via vba.

Thanks
0
 

Author Closing Comment

by:Svgmassive
ID: 39885076
great
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question