printscreen

I am wondering I have one module with 95%+ of the code for my macro in different subs. what is the cleanest way to do this? Each sub in its own module? also is it better to put all the code that is for just that sheet in a module attached to a sheet? Or other ideas that may help? all my code is...

Sub IE_Load_PrintScreen() ' IE and OutLook Dim NorryLink As String ' Link to copy Print Screen NorryLink = "Home - County of Northumberland" & Sheets("Tax Cert Bill").Range("B17").Value Dim IE As Object Dim hwnd As Long, IECaption As String Set IE =...

Anyone who know the code ? now i found the code follow as below but it's can printscreen :( help me please... <code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;">Private Sub Workbook_Activate() Application.OnKey "{42}", "TEST" End...

Hi All, I have One outlook code which display new mail with body,subject and mail ids in it. I want some suggestions regarding 2 points:- 1. Is it possible to add snapshot or printscreen of the table in mail 2.is it possible to add hyperlink in mail. Please sugges sometihing onthis. Thanks

Dear all, I need some help... I would like by vba code to PrintScreen some userform and then to Paste it to another sheet, any Ideas? By the way, the main thought was to print and save as PDF a big userform (the code userform.PrintForm don't print the all userform...) thank you, Omer.

Hello All, I am trying to print a user form to PDF. Thus far I have found it works best to create a bitmap file of the userform. Please see programming below... Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, _ ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)...

Is it possible to send a screenshot of a userform via an email to a specific email address once a button has been pressed on said userform?