I would like to emulate hitting the Alt+Ctrl+"Print Screen" button on the keyboard with the following code. I know there are some restrictions around using the PrintScreen with the SendKeys, but I'm hoping I can still figure out how to make this work.
Following is the first part of a larger macro I've set up. If I can just get this to work, that would be perfect.
Sub PrintTheScreen()
Application.SendKeys "^%" & "PRTSC"
End Sub
I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).
View 5 Replies View RelatedI was looking at Colo's website for the Application.SendKeys method, http://puremis.net/excel/code/039.shtml ,so that I can speed up a page/print setup macro that I have.
I was partially successful in setting this up, but I did notice that there was no argument number in that method for setting up the "Fit to x Pages Wide" and "y Pages tall".... I really need that functionality....
I saw something here that is supposed to get the zoomfactor : http://groups.google.com/group/micro...8d0?scoring=d& but I can't seem to incorporate it into my code so that it works.
Is there an Argument I can set up to get those?
Here is my code so far:
Sub ElecECNPrint()
Application.SendKeys "{ENTER}", False
Application.Dialogs(xlDialogPageSetup).Show _
Arg1:="", _
Arg2:="", _
Arg3:=0.25, _
Arg4:=0.2, _
Arg5:=0.42, _
Arg6:=0.39, _
Arg11:=xlPortrait, _
Arg12:=xlPaperLetter, _
Arg13:=79, _
Arg17:=600
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
I want to change Arg13:=79 to Arg13:= Zoomfactor, but I just ain't cutting it as each page is a different size and I am running this from Personal.xls ....
macro minimizes excel takes a print screen of the application behind excel then pastes it in a word document then maximizes excel screen again
View 9 Replies View RelatedCode:
Private Sub CommandButton2_Click()
Me.PrintOut
End Sub
Is there a VBA that will print out the screen in landscape? The above code seems to only print in portrait.
I have a WYSIWYG problem: what I see on the screen is NOT what I get out of the print job.
I commonly have the problem when working with Excel objects (any kind of shape, text box, line, graph) in that the layout looks great on the tab that I created, but when I go into PrintPreview or actually print it out, the shapes don't quite align with what I had built in the tab. Where I thought I had lines joining, the print out shows them crossing at other points. If I then go back to the tab and look at the layout on the regular screen, it looks fine.
This problem can be easily understood if you try to create a triangle by drawing three lines (non-overlapping lines that cross only at the vertices). Note that the lines either prematurely cross, or don't intersect at all when you print it out.
THis problem is even magnified when using the camera function to take a "snapshot" of a graph or other objects. In fact, it has the tendency to even "mess up" the graph's formatting, regarding the arrangement of titles and axes (often making them overlap).
Is there a feature or VB code that will take a screen shot in excel for the sheet that I have active?
What I would like to do is run a macro that does a few things, then takes a screen shot and bundles it up in an email to send (Outlook on Exchange). Since the report is 30 MB it cannot be emailed and taking the time to compose a report w/screen shot takes too much time.
On a spreadsheet in excel from office xp, is it possible to display a row on the screen, but when you print the sheet it doesn't get printed? How do I do that?
I tried hiding the row, but the admin wants to be able to see it on screen and complained too tedious to unhide it on screen then hide it for printing.
I have never written macros for excel so not sure if there is a solution there, or if it can be done another way.
I also thought we could have the data from the row in another sheet that doesn't get printed, but she (the admin) preferred the hide/unhide solution.
I have a project report, which is user-configurable, allowing the user to customise the data that is displayed based on a number of parameters.
To ensure the report always prints neatly (the number of visible columns and rows varies, depending on the above parameters), so I have a macro that dynamically sets the print area of the worksheet.
At present, I call the macro from the workbook.beforeprint event, which works fine in terms of printing. Ideally however, I would like the macro to be called when CTRL+P is first pressed - i.e. the resulting 'print screen', containing a preview of the print out should reflect what will subsequently be printed, when the 'Print' button is then pressed.
I am not sure if this makes sense (Excel 2010 and 2013 are different from previous versions).
I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)
Problem Example.png
.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.
Problem Example_Print Preview.png
I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.
But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.
Instead When I press F9, I wanted the below to happen
1. Content from the Clipboard should be cleared
2. Take the screen print
3. Paste it in the word document.
Note: My tool/code already does 2 and 3. Looking for 1 alone, ,
this is the code i'm using but sometimes it runs sometimes it runs incorrectly; i've been told that sendkeys is not a good choice and i should use API but i'm just studying VB6 and i do not know what is API; so i need a code to copy and paste in a module this is the code with sendkeys that i need insterad with API
Sub b()
Shell "C:Program FilesEquisThe DownLoaderDlwin", vbMinimizedFocus
SendKeys "%{T}", Wait:=True
SendKeys "{o}", Wait:=True
SendKeys "{A}", Wait:=True
SendKeys "{DOWN}", Wait:=True
SendKeys "{TAB}", Wait:=True
SendKeys "C:Documents and SettingsfrancoDesktop", Wait:=True
SendKeys "{TAB}", Wait:=True
SendKeys "matrice1.txt", Wait:=True...............
Once the intended chain of actions is performed, normally EXCEL would go on to display the contextual menu, (which is its standard right-click action when no macros are involved).
Since I don’t want my macro operation to end with that menu covering part of my screen, I have the macro ‘type’ in ESCAPE, through one of these lines:
A theoretical question following an empiric result.
For the command “SendKeys”, for instance, take these two lines:
I'm trying to access one of my custom menus through a macro.
The keyboard commands are
alt, n, f
and
alt, n, g
I have these lines of
Range("A31").Select
SendKeys "%nf", True
SendKeys "%ng", True
All this seems to do is put the letters f and g in cell A31!
I am trying to use a macro to automate the use of alt key.
my code looks like this-->
Private Sub CommandButton1_Click()
For i = 0 To 10
Range("A" & i).Value = ActiveSheet.SendKeys("%" & i)
Next i
End Sub
This code is to enter the value of ALT+1...ALT+10 to column A
I am using SendKeys in a VBA script to activiate 2 Add-In functions when a worksheet is activated. The code I am using is:
Private Sub Worksheet_Activate()
Application.SendKeys "%GR"
Application.SendKeys "%GH"
End Sub
Whilst this code works fine as is I would like to provide the user with some progress information either with a message box or via the status bar. The first command refreshes data from an external source and the second hides unwanted rows and columns. I do not have access to modify these add-in functions.
I have tried:
Private Sub Worksheet_Activate()
Application.StatusBar = "Refreshing data in progress ..."
Application.SendKeys "%GR"
Application.StatusBar = "Hiding rows and columns in progress ..."
Application.SendKeys "%GH"
Application.StatusBar = False
End Sub
However, the system does not wait for the sendkeys commands to complete before changing the status bar message so it flashes them on and can hardly be seen
I would also like to turn screen refresh off to speed up the process time however the Application. ScreenUpdating function appears to be ignored.
Ive put together some code that sendkey values to another app. I'm having trouble now looping throught a worksheet and sending the keys of each cell.
For example ill used range a1:c4 I like to have a loop that moves to a1 and takes the value and sendkeys then b1 sendkey value.
SendKeys "^F"
would work but it doesn't any ideas / alternatives?
Sub ExcelOptionDialogSendkeys()
Application.SendKeys "{ESC 5}%TO"
End Sub
But if you happen to want to assign it to a Ribbon button click...
Sub rxExcelOptionsDialog(control As IRibbonControl)
Application.SendKeys "{ESC 5}%TO"
End Sub
the sendkeys method just doesn't seem to work under any circumstance.
I used to run a macro on Win XP - where in I open a Web browser and then Send keystroke to Open new ones - Which was working fine. But now when i use the same macro in Vista it gives me a "Error - 70 : Permission Denied" @ sendkeys.
Option Explicit
Public myIE As Object
Sub OpenIE()
Set myIE = CreateObject("InternetExplorer.Application")
myIE.Navigate "www.ozgrid.com"
myIE.Visible = True
Application.Wait (Now + TimeSerial(0, 0, 5))
SendKeys "^N" ' to Open New Window
End Sub
What i require now is I need to Open IE - 7 - Which i am able to do and then open several Tabs with different URL's
I have created some code that directs me to a web page, and i use send keys to navigate my way to the input field. In this input field I am trying to put a cell value in a range use send keys to download the file, and the repeat the process for the next cell.
Here is my code so far, it does everything right up until pasting the copied cell into the input section of the web page - the issue is it is pasting nothing
VB:
Shell "C:Program FilesMozilla Firefoxfirefox.exe " & "https://website.com", vbMaximizedFocus
Application.Wait Now + TimeValue("00:00:05")
SendKeys "{TAB}"
' Input username
[Code] .....
I have a simple macro that from Outlook Express sends emails, with the last code line to mimic ALT+S on the keyboard to send the message
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%s"
Yesterday I needed to install some new software that required at the end reinstalling of Microsoft Redistributable 2005. Not sure if for that reason but now the last line (the SendKeys) is not sending the email automatically anymore. What happens is:
-the email message windows pops up but is not being sent unless i do it manually (if i get rid of the two seconds pause ahead of that)
-have a VB error message that takes me before the SendKeys line (if I keep the two secs wait ahead of that)
It looks to me that either:
-the pc is not active anymore on the email message therefore the SendKeys doesnt work
-somehow the instruction finds the "door" shut by something else
-worse of all, the software has messed up with those send keys commands (tried to reinstall it but to no avail)
I need to use sendkeys to insert code into codepane in VBE.
I use sendkeys "MyFunction()", but the "()" doesn't show up just "MyFunction"
I use sendkeys "MyFunction" & chr(40) & chr(41), still only get "MyFunction"
I'm trying to use the SendKeys function to copy data from a range using a button.
I realise this is not the most elegant of ways to acheive the result, but there are a number of factors involved.
The range is laced with code.
However, I have not been able to find a solution. I created 2 macros that work using the alt+F8 and enter option as well as the run from the macros menu method. Whenever I try to use the keyboard short cut eg. Ctrl+e it will either not do anything or pause and then select every cell. The codes are below:
Sub Macro5()
'
' Macro5 Macro
'
[Code]....
I have tried multiple letter options and have also tried many macros in a new workbook and I cannot get it to run with the keyboard shortcut.
I have a workbook that I transfer back and forth from my desktop to my laptop, that uses Sendkeys to add code to the active pane in VBA. It doesn't work on my laptop, but works fine on my desktop.
Both computers have Vista. Is there a switch somewhere to make Sendkeys work?
We have a business system which has some very disjointed reporting. To fix this I have multiple extracts that are then combined into a single report. I then add Year & Period from a lookup of a date in a particular field. Unfortunately most values are returned as #N/A but if I manually go into the sheet and select an offending cell and click then magically the formula then corrects itself.
So I thought I would be clever and use Sendkeys {F2} as part of my code. Unfortunately this is a bit hit & miss as it works on some but not on others. Also the Sendkeys piece repeats itself leaving my frontsheet a 1000 rows from the start. This is easily fixed by selecting cell A1as the last step.
My question is there methods in VBA by not using sendkeys that will achieve the same result and is consistent. I am using Excel 2010.
Code:
Sub Add_Calendar()
Dim cell As Object, c As Range
'setup for calendar data population
' Range("H1") = "Created Date"
Range("N1") = "Year"
Range("O1") = "Period"
'copy the format
[Code] ........
How to stop macro while running SendKeys statement. I am not able to stop the process while running SendKeys statement. this is my Sendkeys VBA
For Each cell In Selection
SendKeys cell.Text, True
Next cell
I want to switch on Caps & Number lock on opening an Excel document. I'm using the following code;
View 10 Replies View Related