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...
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 =...
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...
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...
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...
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...
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...
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...
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...
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 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.