automation

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

Hello: I'm a newbie re: this type of VBA but have done a lot of research (and testing) on the matter before posting here on this site. The code I've come across is too complex for me at the moment. What I would like to do is take slides from an existing presentation and paste those into a new...

I'm using the below script to remove only blank line breaks using Chr(10). It works great, except that it doesn't remove the line break when it occurs at the beginning of the cell. I only need it to remove the first line break carriage from the top of the cell. Sub RemoveBlankLines()...

Good evening experts! I have a spreadsheet with a few hundred rows that I'm trying to capture reviews on. Column A cells has "Reviewed" (using a label currently) all the way down. I'm open to suggestions if there is a better/easier method instead of using labels for click events. I'm looking...

Need to be able to automate an abbreviation into a full name Ex: data in column reads” Rn”. Needs to spell out Registered Nurse in a separate column If another abbreviation is “abc”.. Spell out “ anything but cats” There would be about ten abbreviations I would need to program to automate...

Hi Everyone, this is my very first post. I am try to automate my school work a little quicker. I want to pull the first and second string from a folder name, usually the first and last names of people, and then put this into an excel worksheet with column A being the first name and column B...

Pretty simple :) I wish to press, say, F1 (Windows OS) and have something like "XZ" print in the active cell as plain text, but in such a way that I can then enter "123" on the keypad to result in XZ123 before I hope out of the cell. That's it! The only caveat is that I wish the automation to...

Hello. Thank you in advance for any help or ideas you have! I have looked at several forums, but have not quite found a solution that works for me. I am looking to create a master template that can be tailored through VBA to fit the requirements of a particular vendor. Depending on which vendor...

Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...

Hello everybody. I want to do something rather large, but I am very inexperienced in VBA and would really appreciate some assistance. Please note that I want to do a bunch of things, but if you can just help me with one of them, it would be immensely appreciated!! - Wishlist: @Fluff ? :) So I...

Hello! I am looking for a way to mass produce Multiple PPTs from Multiple Variable Designated Excel files. I have been able to create 1 PPT from 1 designated Excel file using VBA below The code used before is very static and I'm looking for a way to make it more automated. This Static...

Hello all, I am quite new to VBA scripting. Here is what I am struggling with. Example : Data : I have two sheets A and B. A contains the data from customers. B contains data from me. Question : Once the customer selects production/market in sheet A, I want to iterate through the rows in...

Hello everyone, this is going to take a bit of background to explain the issue in detail. I've been working on this project for so long I'm going cross-eyed. It wouldn't surprise me if there's obvious problems that I can't see because my nose is too close to it - y'know? Anyway. The purpose...

I know next to nothing about Power Automate so forgive me if it's very simple. I have to download certain files from a power BI dashboard (like using the export to part) and save them to a certain folder. Is there a way to use the browser version of Power Automate to download files and save them...

So I am looking at COVID stats all day and I have to prepare them for my manager. This is a multistage process and it's fairly repetive. As a result i want to automate it so i can spend my days doing more productive **** or cat videos. Either i am not bothered. It's a multi stage process and...

Good day everyone! I hope everyone is doing well. So here's what I'm trying to do...I need a VBS that will loop through a workbook of multiple worksheets and look at columns C and D for differences as long as the text does not match "Default settings" or "Configurations settings". If there are...

Hello! I'm trying to write an Excel VBA script to copy the first row of "Sheet1" with current formatting and filter on and paste the values into the first row of every worksheet in the workbook if the worksheet is blank.

Good afternoon! I have a workbook with a worksheet (Sheet 1). I'm trying to copy the text in all rows starting at A2 to the end of column A without the character "(" in it and create a worksheet for each corresponding text value from each row in Sheet 1. So if A2 has the word "Test" in it, the...

I'm attempting to find a solution to automate the delimiter and I've scoured the forums and internet to no resolve and was hoping I may be able to find an answer here. Right now I am having excel generate a barcode in the example format of "11D*122*1", each identifying number is split by the...

Hello all, As the title mentions, I am trying to remove all numbers at the end of a cell. Not every cell ends in a number and most of the time each cell contains numbers. These number are useless for our purposes and need to be deleted, datasets typically are received around 10k - 100k cells...