sendkeys

  1. bs0d

    Clearing Focus or SendKeys ESC Equivalent

    Through execution of my macro, I've had to activate a chart, and chart series - which leaves the focus on the chart (selected). I'd like to reset the focus to nothing - the equivalent of hitting escape; but I can't use SendKeys "{ESC}" because it causes other problems. How have others worked...
  2. D

    need ErrHandling after no search result Notepad

    Hi All, I am a newbie on macro's and still learning :cool:. Hope you can help me out. I have a working sendkeys macro. Accept for one part that I can't figure out; ErrHandler1. Problem: No search result error from notepad if text is not present in notepad file Solution looking for: if no...
  3. F

    Using Notepad to strip HTML formatting, then paste to Excel

    This question is similar to many "Notepad posts," but I've not been able to adapt the solutions to my use. Specifically, I'm not trying to write to a text file. I'm trying to use Notepad to strip out HTML formatting before pasting the resulting HTML-free text into a one-column Excel range...
  4. T

    SendKeys to another Form

    I'd like to put a button on Form2 that sends a key combination to the Browser Object on Form2. Ideally, I'd prefer to have it not visually jump to the other form, but if the focus has to be switched that's not that big of a problem. ('BrowserWindow' is a Microsoft Web Browser Object) I tried...
  5. O

    Help with SendKeys - only first SendKey command works

    Howdy howdy, I'm trying to paste Excel values into an external program (not an Office program). I usually have a list of maybe 20+ rows to enter, and find myself basically doing the following routine clicks/keys: Choose the starting row in Excel copy in excel Alt-tab to focus on non-Office...
  6. B

    SubApplication.SendKeys command is opening the Start Menu

    The macro is as follows: Sub FindText() CommandBars("Edit").Controls("Find...").Execute Application.SendKeys "%(h)W%(t)%(h)W%(n){DEL}{ESC}" End Sub It only seems to open the Start Menu when I use an assigned hotkey to call the macro. I had originally set it as ctrl+shift+f ("ctrl+F") and...
  7. D

    SendKeys Sort of Works - Having problem with ALT (%)

    At my home office this works fine, but in the office it is actually placing "F1" in the cell that is active. I generally despise using sendkeys, but this was the only solution that I came up with... Thanks in advance for your help...
  8. P

    Controlling printing with VBA

    I have been reading a number of websites dedicated to the "Sendkeys" method of controlling the printer from within Excel 2010. However, I can only get as far as the "Print" screen in the "File" menu using the following: Application.SendKeys "%fp%ri", True or Application.SendKeys "%fpr", True...
  9. R

    Excel VB Commands for Control-Home & Control-End without Using SendKeys…

    Does anyone know how to add the command to press Control –Home and Control-End without using SendKeys? As many of you know, using SendKeys tends to play havoc with the NumLock key, turning it off and as a toggle. I need to be able to go to the highest cell in the upper left outside of the...
  10. J

    Key Event VK Keys

    I have the following script for a couple of VK keys for keyboard event but need the following keys also, can someone please help. Private Declare Sub keybd_event Lib "user32" ( _ ByVal bVk As Byte, _ ByVal bScan As Byte, _ ByVal dwFlags As Long, _ ByVal dwExtraInfo As Long) Private Const...
  11. J

    Sendkeys Taboo Question

    I know that sendkeys are very taboo, many are for it and many are against it. Anyway, I want to use them and therefore this question, does anyone have a sendkeys script that can select a specific tab in Internet Explorer, i.e. I have 10 tabs open and I want to select tab 2. Also a sendkeys...
  12. N

    SendKeys dialog box - close file

    Hello, i have a file that i automatically set to load another file. after the file is loaded i would like to automatically close the initial file. i have used the below code to close the file but the problem is that i have a addin that automatically prompts a message box to clasify the file...
  13. M

    AppActivate losing focus

    Hi, I'm trying to open a non-MS application and then use the SendKeys command. The window activates, but then it seems to lose focus by the next line (SendKeys). I can't even get it to work in Notepad with an example of simple code I found online: Sub Write_Notepad() AppActivate ("Untitled...
  14. J

    Excel 2003 VBA, The following do NOT work: SendKeys to Word and Notepad, Clear Word Clipboard, and Quit Notepad. Unwanted Prompts.

    The following desired functionality is not working or I've been unable to find an implementation in Excel 2003 VBA: 1. Select All and Copy using SendKeys to Word (does NOT work). However, the DEBUG implementation provided instructs the user to do the Select All and Copy manually. This is to...
  15. E

    Problem showing the Ribbon in Workbook_BeforeClose

    I want to hide the Excel ribbon in Workbook_Open then show the ribbon in Workbook_BeforeClose. The Workbook_Open works OK, but in Workbook_BeforeClose, the SendKeys starts Excel Help. In testing, the same "Show Ribbon" code works OK in any module subroutine except Workbook_BeforeClose. Is...
  16. J

    SendKeys "{DOWN}"

    Hi Everyone, I was provided the following script to use arrow down rather than activecell.offset as I have a filtered list and want to select the next cell down that is visible. SendKeys "{DOWN}" My problem now is that if I try to access the cell using the script the address is the old...
  17. H

    Pasting Problems with simple macro

    heloo people - I need to copy seeral thousand records from a windows programme into excel. Unfortunately, the program does not allow me to select all of the records at once, only one row at a time. However, I can select the top row, copy the contents with Ctrl+c, move down a row with the down...
  18. craig.penny

    sendkeys, separate instance, view source

    Hello all, I'm having problems trying to automate a process of downloading workbooks. What I do manually is that I open a webpage then click a button on the page which directs me to another page where I click another button (this happens a couple more times) and finally get the window that...
  19. pedie

    Sendkey to show me the dropdown:

    My current code as below: in m5 i have a validation drop down.... 'm trying to use sendkey to show me the drop down when i execute this code but for now no error msg...but it didnt even work as i thought it might work..:biggrin: 'm using this sendkey because when we hit alt and down arrow it...
  20. T

    Paste from clipboard to active browser

    Problem: I am creating a form with a webbrowser as an object inside. From a sheet in excell I want to copy information from several cells to the browser in my form. I have no specific destination in the browser form, as you can see in the code snippet I am tabing my way through the form using...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top