handle

I am navigating an external application with UIAutomation, but this can only get me so far. Some objects don't appear or are not accessible until the mouse clicks on them or they are TABBED to, and I am using SendKeys to TAB to them. I now need to get the window handle of the element that has...

@Jaafar Tribak - I have seen that you have extensive experience in this topic so I am hoping that you can help me please. I have an external application that I can launch and control from Excel, but only up to a point. As soon as I click on the SEND TO button and the menu pops up I can't go...

Programmatically, how can I close a browser window that I have opened from within Microsoft Access? I am currently using the "Shell" command but am open to using another method. P.S. I tried setting a variable ("pHandle") as the return value of the Shell command, then using some code I found...

I want to automatize the following procedure: I want to attach an email after sending it to a document in SAP, but as soon as the "select Files:" windows appear my code is blocked from continuing bc this window belongs not to the SAP application itself (I don't know if these are the correct...

In our SAP system, we have a mass attack tool. There is one point at which my VBA cannot control the SAPgui anymore, it's when the "Select Files:" window appears (see screenshot). Yesterday I got a solution on how to find this window from a good man here in the Forum. The macro gave me all the...

Hi, I have an Excel macro that requires a reference (DLL) and if the DLL isn't found I get "Compile Error, can't find project or library" Is there a way I can handle this error by checking if the DLL exists then msgbox / exit sub Thanks for any help

Need your advice on the best way to handle vendors that are the same just called differently in the data I receive. One data source may call the vendor something different than another data source. I.e. abc co. Vs abc company. Or St Joseph’s vs Saint Joseph’s. What is the best way to handle...

Hi, Is there any other alternative or shorter solution for rewriting the below formula example.i have read in an older post that the SUBSTITUTE function cannot handle the "old_text" part as an array{1,2,3,4,5,6,7,8,9,0} Thanks In Advance. <tbody> A1B2C3D4E5F6G7H8J9K0...

I have a list of Fields that MUST be in a Table. The data from this table is uploaded into another program. The Criteria for one of the fields is that it equals another field in the same table. Yes, I know repetitious. I am trying to figure out the best way to handle this situation. Can I...

Hi all, I am updating around 90 workbooks for year end by adding an extra named range to an existing formula I will be doing this by looping through all of the workbooks to add the 18/19 spend in year to 15/16 16/17 17/18 Range("HRPreviousYearsSpend").Select ActiveCell.Replace...

Hi, I'm looking for some help on creating a formula. I'm guessing there is a way to do what I want using Lookup and SUM, but I am at a loss as to how to actually accomplish it. I have a product spreadsheet. Column A has the handle (unique identifier) of each product. The handle will appear in...

I have been searching on the internet for hours trying to find a solution for this. I have seen many similar posts but doing the suggested has not been able to fix my own problem yet. I want to be able to use drag-and-drop to have Excel automatically fill the lower cells in increments. For...

All I did was type the item above and I got an overflow error. The answer is 60001. Can it really be that excel can handle a number as big as 60001. In fact, it can't handle more than 2^15-1. I'm sure that this is some special programming crap, but it's the year 2018. It also can hand 1 +...

Trying to fix bug in sheet when time auto populates in the proper cell, the cell before it adds the date 01/01/1900 + the previous time, messing up the average handle time.

Hi everyone. I need to add a new blank line between the selected rows for the project plan. Almost every cell has formulas, and this new line must be the same. How can I handle without mess?

I have a value which occurs in a table. Lots of rows and columns. I just need the row number in which the value occurs. I don't think Match can handle a 2d array. Dave

I’m trying to come up with a formula to handle multiple situations. Current formula: =IF(Indiv!C5<8,Indiv!G5,Indiv!B5). current formula will return “227” with example below: <tbody> Cur Ave Gms Total Pins High Gm High Series Ent. Ave 201 4 804 217 804 227 </tbody> C5 =...

Hello, Can somebody help me that what is the best way to handle data with more than 4 million lines in excel other than keeping separate multiple worksheets ? Thanks, Punjabixlvba

Ok, so I am relatively new to vba and i need to show a userform if a cell is empty, but for some reason it is not running correctly. Could i get some help or advice on how to better handle please.:) Sub Auto_Open() Worksheets("Report Disposition").Activate If IsEmpty("D3:J3") Then...

I'm wanting to identify a string that starts with one char A to Z, then any number, than a period and space. I *think* LIKE [A-Z][1-9]. *" could be be a starting point but I'm not sure if I'm getting confused with Regular expressions, plus how to handle a number > 9. Thanks for any help