automation

I have an issue with the loading of web page after the whole form is filled neatly. The next page is where i need to do data extraction. This is the website: https://enquiry.icegate.gov.in/enquiryatices/sbTrack Please find sample data here : SELECT LOCATION : HYDERABAD ICD (INSNF6) ENTER...

Hello Everyone, I have created a macro that gathers all the timings from a specific subfolder on a specific date from a shared mailbox and personal sent folder. When checking the timings from the personal sent folder there is no issues, but when checking from the subfolders from the shared...

Hello, I was wondering if someone could help me develop a code to insert 300 rows after a specific row. For example I would like to add 300 rows right after row 80 000 in my data set. :) Hope someone will get back to me soon !

Hi guys, Just wanted to ask for a help related to scraping of data from the URL. I have previously used the following script (function) to extract Article/website title from the URL. Now, however, I need to extract the date of issue; e.g. when the article was published. Could you please help...

Hello, I would like to transpose a range of data (A1 to KJ1) from every second row (row 1, row 3, row 5, until the last row) under one single column (e.g. column C) in the same sheet. I am having difficulty creating a macro with a loop that will help me do this. I tried following some...

looking to download a PDF from a URL. I can't seem to get past the login screen as the pdf that is downloaded only contains the code for the login page if I open it in NotePad. I examined the post request after logging in manually and pasted it after "FormData." I'm not sure if it matters what I...

Hi everyone, I need some help with a formula for an automated excel sheet I have. The formula is for a Recovery strategy called 1-4 recovery. It’s goes like this: 1x your bet amount first attempt If that loses; 2x your bet amount If that fails; 3x your bet amount If that fails 4x your bet...

I need some help - google hasn't led me to anything useful :( In my workbook, Sheet1 is a template used to analyze some data. Sheet2 is a list of values. My current macro asks a user how many times they need the template copied, and then copies Sheet1 as a new tab at the end of the workbook the...

Dear All Experts. Please forgive my english as its not my native language. I am in a situation where i want to get a certain word " Pending" as bold and italic whenever i type it on that particular sheet. All the text contains in one cell with many other words , but everytime i type pending i...

Hi I need help in writing a vba code which would connect to SQL and run a SQL statement to generate a report based on company name. The code should then save the output to the defined location in the excel data table The data table in excel has company names from b2:b50. Column C is a user...

Hi I got the below vba code from this site. The code will automatically open the site in IE(will be using different url) and will import files as well. When I ran this code,it did not work due to incorrect elementsTagName and maybe InputType as well. What should be the correct codes? I am not...

My company uses a lot of excel spreadsheets. We are a manual software testing group which uses approximately 164 excel during our testing cycles. Before every testing cycle begins, we manually update our excel documents to match that cycle’s year references. This process is very time consuming...

Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running...

All of a sudden one of my macro workbooks starts producing an Automation error when I execute this command: Sheets("Categories").select The rest of the error message is "Invalid forward reference, or reference to uncompiled type". I tried renaming the tab and I've verified there is nothing...

Hi all, Workflow below ALL Code resides in sheet "Super Automation" Information is gathered on "Ads" tab and brought into "adstemp" Advert Data is opened and relevant tours gathered Advert Data closed, tourlist is loaded into Automation Hub Several spreadsheets are now opened (Regional Press...

Afternoon, I am trying to automate some IE navigation. I am running into an issue when trying to populate a field. The object will allow for text entry - but i cannot seem to find a way to fire/trigger an event to populate the dropdown list that will then allow me to select from their...

Getting the following error: Runtime error -2147417848 (80010108) Automation Error The object invoked has dicsonnected from its clients. <code><code> Set ie = CreateObject("InternetExplorer.Application") Application.ScreenUpdating = False If Sheets("Adrenalin").Range("C3").Value = "" Or...

I am trying to open an IPV6 web page that may or may not have a security warning. After which I would like to pause then enter the username and password. The IPV6 location is based off of Excel.Worksheets("Main").Range("A5").Value . The code I have to open the web page is : Private Sub...

We have an upcoming project I will be head of at work, where the manual click / wait / click / wait task that takes about 16 hours will be ran overnight. This task uses portals which interfaces with a kind of CSV database of information (advert file), but the portal opens up an Automation Hub...

Hi, I have two bugs that are crippling the workflow of the company. We rely on probably 40-50 different workbooks that are very macro heavy and do a lot of talking to each other, like one is a database of adverts and the other reads it, displays adverts to select and then applies new lines to...