| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to capture screen through VBA?
Hi,
I'm doing a program for generating report in excel. One of the steps is capture the active window screen and paste it in a worksheet. I have to push Alt-PrintScreen to capture screen before running the report generation program. The following code is used to copy the screen capture. Set NewWb = Workbooks.Add NewWb.Sheets(3).Activate Sheets("Sheet3").Select Range("A1").Select ActiveSheet.Paste I don't want to push Alt-PrintScreen every time. Are there any methods to copy the screen automatically? Best regards Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
| print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
| Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
| screen capture of page | Excel Worksheet Functions | |||
| How to copy data from excel to power point screen by screen? | Excel Programming | |||
![Bill Choy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
