automation

  1. reasem

    Download PDF from URL in Excel VBA

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

    1-4 strategy formula

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

    Paste Value from List into Separate Sheets

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

    Code for TEXT gets Bold When its get typed anywhere

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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")...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

Top