Search:

Type: Posts; User: scotsrule08; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    10
    Views
    278

    Re: Web Scraping Login Help!!!

    I copied and pasted directly from the DOM. I double checked and it is all spelled correctly. I also stepped through the code (using F8) and also added a wait time of 8 seconds to ensure the page was...
  2. Replies
    10
    Views
    278

    Re: Web Scraping Login Help!!!

    Thank you for the response. I am getting Runtime error 424 object required pointing to line "doc.querySelector("#Archiveanch").Click "

    Thank you!
  3. Replies
    10
    Views
    278

    Re: Web Scraping Login Help!!!

    Sorry, for some reason when I used the code tags it took the code as a link. Any help is appreciated! Thank you!
  4. Replies
    10
    Views
    278

    Re: Web Scraping Login Help!!!

    class="InactiveTabLink" id="Archiveanch" *******='javascr
    ipt:left("", "Archive", "LeftReq", "RefreshView?trigger=Opti
    onsPageProcess");return false;' href="#">Archive
  5. Replies
    10
    Views
    278

    Re: Web Scraping Login Help!!!

    Thank you for the help! I am now stuck trying to click on part of the header. The HTML code is below.

    <a class="InactiveTabLink" id="Archiveanch" *******='javascr
    ipt:left("", "Archive",...
  6. Replies
    10
    Views
    278

    Web Scraping Login

    I am going nuts trying to figure this out!

    I am needing to navigate to a site and login through VBA to scrap some data. (which I have done several times before)

    I cannot for the life of me...
  7. Replies
    19
    Views
    3,604

    Re: Extract Thumbnail preview from file

    Would it be possible to show the file preview rather than the thumbnail?
  8. Replies
    19
    Views
    3,604

    Re: Extract Thumbnail preview from file

    This is great! In my use case I would need to display the preview of the file, then rename the file, and continue to the next until looped through all of the files in a folder. Any ideas?

    Thank...
  9. Replies
    1
    Views
    341

    PDF Viewer and Renamer

    Good day

    I am trying to rename a folder of PDF's. The challenge is that to get the new name the file must be opened and the new name typed out.

    I have been trying to use a userform to display...
  10. Replies
    0
    Views
    68

    Move files based on name criteria

    I have a worksheet where column A contains the file names and Column C contains the number of characters in the filename. I need move all files that have a name with 32 characters (including .pdf) ...
  11. Re: Replace File Dialog Picker with Path

    You are my hero! It has been a long day and I was a potato 🥔 to not figure that out. Thanks so much!
  12. Replace File Dialog Picker with Path

    Good day friends,

    I have a macro which selects a folder and then makes a Dir list and counts the number of pages in the pdf.

    I am needing to replace the folder picker portion of the code with...
  13. Different Word Template based on cell value

    Good evening,

    I am needing some VBA to select the correct word merge template based on a cell value. I receive a spreadsheet with all of the data to perform a word merge. Not every row will be the...
  14. Count Emails from Each Day Exchange Outlook Count

    Good day Excel friends!

    I am needing assistance with creating a macro to count the number of emails in 2 exchange inboxes (not my default email account) with the date the email was received.
    ...
  15. Filter column and email to different contacts

    Good day friends!

    I have a large worksheet that I need to filter column B and email the filtered results to a specific contact based on the cell value.

    For example
    Column B:
    Banana
    Orange...
  16. Re: Fill variable formula in adjacent column

    I need VBA to do that automatically.
  17. Re: Fill variable formula in adjacent column

    I should have been more specific. Here is the formula I need to fill down in Column B based on how far down column A goes.

    =MID(A2,FIND("~",SUBSTITUTE(A2," ","~",LEN(A2)-LEN(SUBSTITUTE(A2,"...
  18. Search for email using cell value and attach referenced file

    Here’s a doozy!

    I have a spreadsheet with reference numbers and the path to a spreadsheet for each reference number.

    I would like to search through Outlook for an email with the subject line...
  19. Fill variable formula in adjacent column

    I have a dynamic set of data in column A. I need to paste a formula in column B all of the way down to the last row with data in column A. The formula does need to change the reference all the way...
  20. Print XLS files in folder based on name

    Good day Friends!

    I have a folder with dozens of spreadsheets that I need to print. I only want to print the files that contain the word "COMPLETE" in the filename.

    It would be much preferred...
  21. SendKeys paste to excel then reactivate Internet Explorer to continue

    I need to "reactivate"/focus my VBA back to IE. to continue getting data off of various pages without having to log back in to the same page.

    So right now it is selecting all data on the page,...
  22. VBA Add border to dynamic rows but static columns

    I am needing to add the right border and last row bottom border for a variable set of data. The columns will always have data in columns "A" through "I". Starting with row 27 and ending with a...
  23. Re: Hundreds of workbooks values that match 493

    Thank you for the quick response! I am getting the error "Run-time error '1004': Method 'Range' of object'_Global' failed" for the line:

    Range("B:B").Formula = "='" & MyPath & "[" & MyName &...
  24. Re: Hundreds of workbooks values that match 493

    I only need to return the file name for the value $493
  25. Re: Hundreds of workbooks values that match 493

    It will always be $493.00
Results 1 to 25 of 43
Page 1 of 2 1 2