automation

  1. S

    Use VBA to generate SQL reports

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

    Please advise the codes I used

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

    Excel Automation possible?

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

    Automation Error Exception Occurred

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

    VBA Automation Error

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

    [VBA] Automation Error - no context, no error code, 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...
  7. C

    IE Automation in VBA

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

    Runtime Error -2147417848 (80010108) Automation Error

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

    Automating Google Chrome to log in

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

    Big upcoming overnight Automation project - How to ensure VBA completes its task when likelihood of crashing is high?

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

    Two severe and company-breaking Excel crashes (VBE7.dll and Cannot Find Project or Library)

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

    Automatic sheet layout based on topic selection.

    The idea is to have a topic selection page where i can select yes or no and then based on my answers the next sheet will show all of the topics that i answers yes to. Images can be seen here: https://ibb.co/YfKK6pG AND https://ibb.co/1GpyjmJ Looking it this it maybe could be something where...
  13. H

    Automatically transpose values that are connected to the same description into columns

    I have a product listing that contains a number of items that are of the same type. Each product has a photo associated with it that I would like listed in columns rather than in rows. I know I can transpose the values manually, but I'm looking for a way to automate the whole listing sorting by...
  14. C

    VBA Pivot Items

    Hello, I'm trying to automatically set the current year and next year in a pivot table using VBA. This is what I have currently Dim CurrentYear as Variant Dim NextYear as Variant CurrentYear = Year(Now()) NextYear = Year (Now())+1 With ActiveSheet.PivotTables("PivotTable1").PivotFields("YR")...
  15. S

    VBA - Excel Data Treatement across multiple sheets

    Good morning everyone! I know the text is long but please don't leave just yet. Please keep with me and be patient, I'm a newbie, on the community and on excel! I have this project that I could really use some inputs on how to achieve it (logic, algorithm and code-wise). I have two Excel files...
  16. J

    Automation of task routing that I can not solve.

    https://photos.app.goo.gl/JiRjueNTERUmu2ev6 I'm trying to auto populate the area in yellow in the screen shot (see link) with the tasks. Each week a person does a task, the next week they move on to a different task. They never repeat the same task in a 4 week period. Its always a 4 week...
  17. S

    Scraping Data from Web Hourly and Logging Results

    I have set my workbook to retrieve data from a website which gives prices of stocks. It refreshes hourly. I then have some cells that make calculations based on the stock prices using a simple formula. I am trying to make it so that every time the data refreshes, it recalculates based on the...
  18. M

    Transfer data to another sheet based on criteria and save as PDF

    Hi, I am trying to copy information to another tab based on a criteria, and save as PDF. I know how to copy different cells from one tab and paste in different cells in another tab, but this time I need to copy values only if there is no 'Yes' in the column D (starting at row 2). Once the...
  19. M

    Automation Error - HELP!!!!!

    I have this code which was working fine last week but today is giving me the following error Run-time error -2147217376 (80041020) Automation Error Anybody know why or how to overcome it, the code is just importing an XML file into excel Application.CutCopyMode = False...
  20. P

    Automation Runtime error with "InternetExplorerMedium"

    Alright folks, I'm trying to set up a file that pulls up a company Intranet via IE, fills in a few fields and then hits "go" to populate a list. It's triggering an "automation" runtime reror because of the Set doc = IE.document line (Line 7) and I suspect is has something to do with...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top