automation

Hi all, I use a report in excel that automatically updates every 15 minutes, but I have just come across an error with the coding since the introduction of the IE mode in Edge. The debugger shows the error associated to the InternetExplorerMedium wording (see below in context of code) Sub...

Hi All, I am working on my SAP automation process. I have written most of it but I am struggling with writing code for copying dates from two different rows to Posting date : "from" and "to". LastRow = sht.Range("D2").CurrentRegion.Rows.Count sht.Range("D2").Copy...

Hi Everyone! What I am trying to do is link start and end dates from one work book into another, but not the exact cell position where the date currently is. I can do the first part easily enough by putting "=" in the cell of my current work book, and then selecting the date cell from my...

Hi there, I'm looking for some help with drafting an email to Outlook from excel. The Image below shows a typical sheet information. Each column has different data which is needed in one of the email fields. I would like to be able to press a button and have a draft email appear to the...

Hello everyone, I am trying to download a document from a website using vba. So far I can click the print icon on website (using vba) but I am stuck when it shows Open/Save dialog box. Please help on how I can access or click the "Save" button and save file to a given location. Any help is...

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