sendkey

  1. S

    Copy and paste excell cell data to another software with sendkeys or API

    Hello, I have to take data from an excel file that contains mostly int or float that correspond to electrical engineering simulations and paste them into a software that is called Cymcap to run these simulations. Each line of the excel file is a simulation and sometimes there are hundreds of...
  2. D

    VBA if specific pop up then close

    Hi everyone, i am working on a macro which populates an input table for BEX analyzer add in. I am using sendkeys method and there is a popup that comes up if the input is wrong. is there a way for me to make an if statement depending on the title of the alert. for example: If popup title =...
  3. M

    Help with Sendkey

    Hello, I'm trying to automatically enter my username and password that is prompted from a userform. I'm attempting to use the code below. It works fine without the userform present...but when the userform is the active screen, the macro stops working and is waiting for my input. Is there any...
  4. Z

    Open google with sendkey

    Hello, Below is the code I have been working on to open up google using send keys. Normally I use the waitime function I made below to guess when a page has loaded all the way. However sometimes the web page takes longer to open than other times. Is there any way that I can make the loop I have...
  5. E

    Keystrokes for website that does not allow paste

    Hello, Any help to speed up my work with a very outdated website is very appreciated! I currently am manually typing thousands of data inputs out to 6 decimals into an EXTREMELY outdated system that I have no control over. Each project requires 10 inputs into the form. You can not tab...
  6. 8

    How to activate a cell or enter into Edit mode on Mac Excel

    I have created a formula by concatenating a number of cells with text. Example: ActiveCell.FormulaR1C1 = _ "=CONCATENATE(""=VLOOKUP(X3,'["",R1C24,"".csv]"",R1C24,""'!$C$2:$BA$13957,"",R[-2]C,"",FALSE)"")" Output would be...
  7. T

    This Guy - Paste Special Macro WIP. Determining if cut or copy was called...

    Hi, I like to maximize efficiency and go really fast when I work with data. I'm pretty good at doing this too, but Excel 2010's keyboard shortcuts to retrieve the paste special values menu prompt is slowing me down. I access this dialog/prompt all the time and I am annoyed at how...
  8. N

    Comparing Data and Alerting On Differences

    Hello I am hopeful that someone can help me on this website. I have had great help in the past with other issues I have come across. What I have now is beyond me as I am a beginner level VBA. Currently I have to web based data sources that I need to access. Once accessed (this part I have...
  9. P

    VBA clicking on websearch Result

    I am trying to get property tax values for about 200 properties. The info is publicly available on this site: http://www.hawaiipropertytax.com/Searc/GenericSearch.aspx?mode=PARID I have a list of Parcel IDs (also known as TMK Value) that identify properties in a spreadsheet. Here are just two...
  10. pedie

    Need experts advice. Please help me on how to improve my sendkey code:

    Hi, For now it opens the site but it does not enter the word to search. There is no error message as such. I did not use sendkey{TAB} sendkey {%tab} because google set focus on search field when we open the site... Please advice on how to copy range("A1")value to google and hit enter. Thank...

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