Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2016, 03:51 PM
macropod's Avatar
macropod macropod is offline Print Multipage Userform in Landscape Windows 7 64bit Print Multipage Userform in Landscape Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


As I said in post #4, the code would work for Word if it didn't paste anything to an Excel workbook, but that's precisely what your code does. In fact, most of it is concerned with the worksheet formatting. As I also suggested you might need to do in post #2, the code basically does a screen capture of the userform and pastes it. For a single multi-page userform, that would take much less time to do manually than it would take for anyone to write the code. Is there a reason for not doing that?

FWIW, your code would only process the page of a userform it's attached to.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-13-2016, 03:59 PM
mktate mktate is offline Print Multipage Userform in Landscape Windows 10 Print Multipage Userform in Landscape Office 2010 64bit
Novice
Print Multipage Userform in Landscape
 
Join Date: Dec 2015
Posts: 26
mktate is on a distinguished road
Default

I appreciate that your reply reinforces what I already know - that this code will work for excel but not Word. I have no idea how to change it for a Word user form. I also realize the code is for a single page user form; however, as the initial question indicated, I have a multipage (5) user form, and had initial code to print all pages - but in portrait. I have NO IDEA how to modify the code to make it work with a Word document rather than an Excel document. I also indicated in my prior posts that this is being done for users of the user form and will be done more than once; therefore, it needs to be a command button in the form - it is not a one-time screen shot affair - and since I would need five screen shots anyway, I still cannot get there without modifying the code I have (or getting someone willing to help with this rather than just keep pointing out what I don't have).
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Landscape Orientation - Rotate page so top of landscape is printed on left side swifty2010 Word 17 06-11-2022 05:50 PM
Print Multipage Userform in Landscape Convert large multipage table to jpeg idiotwind Word Tables 3 12-01-2015 03:53 AM
Print Multipage Userform in Landscape Large number of landscape pages within a portrait doc--do I have to textbox by hand every landscape? mlkmnsgrl Word 7 01-05-2015 05:19 PM
Print 2 pages to a sheet in Landscape page orientation Alexie Excel 1 09-18-2010 01:29 AM
Multicolumn Multipage makaveli89 Word 0 11-10-2008 11:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft