+ Reply to Thread
Results 1 to 9 of 9

Modify VBA due to change in format of source web page

  1. #1
    Forum Contributor
    Join Date
    02-11-2024
    Location
    Chicago
    MS-Off Ver
    2021
    Posts
    113

    Modify VBA due to change in format of source web page

    I copy and paste data from a webpage. The webpage has changed its format. The macros formula I use to sort the data from webpage no longer works. Can someone please adjust the macros code to adjust to the new data format? I would like the data in Column A sorted into the format in cells in Columns C thru J. Thanks in advance!

    Please Login or Register  to view this content.
    MacroFix.xlsx
    Last edited by 6StringJazzer; 06-29-2025 at 04:15 PM. Reason: better titles please

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,225

    Re: Tweak Macros Help

    Please add sample of expected output to your file.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    02-11-2024
    Location
    Chicago
    MS-Off Ver
    2021
    Posts
    113

    Re: Tweak Macros Help

    Quote Originally Posted by JohnTopley View Post
    Please add sample of expected output to your file.
    MacroFix.xlsx

    Thanks in advance!

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,447

    Re: Tweak Macros Help

    Hi Idaba,

    You should post the .xlsm file so we can see the VBA as the .xlsx doesn't have any VBA in it.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,225

    Re: Tweak Macros Help

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 06-29-2025 at 03:03 PM.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,214

    Re: Modify VBA due to change in format of source web page

    I have updated your title because it didn't describe your question.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  7. #7
    Forum Contributor
    Join Date
    02-11-2024
    Location
    Chicago
    MS-Off Ver
    2021
    Posts
    113

    Re: Tweak Macros Help

    Quote Originally Posted by MarvinP View Post
    Hi Idaba,

    You should post the .xlsm file so we can see the VBA as the .xlsx doesn't have any VBA in it.
    Sorry about that!

    MacroFIx.xlsm
    Last edited by IdabaMalouki; 06-29-2025 at 06:24 PM.

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    31,225

    Re: Modify VBA due to change in format of source web page

    See post #5

  9. #9
    Forum Contributor
    Join Date
    02-11-2024
    Location
    Chicago
    MS-Off Ver
    2021
    Posts
    113

    Re: Modify VBA due to change in format of source web page

    Thank you, John. Works like a charm!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. A Small Tweak
    By MrJingles in forum Excel General
    Replies: 3
    Last Post: 06-02-2017, 09:14 AM
  2. [SOLVED] I need a tweak with Macros, getting error because of zero value for my IF condition...
    By lati2008 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2014, 01:41 AM
  3. Holiday DB Tweak
    By jj72uk in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-31-2009, 11:17 AM
  4. Macro Tweak
    By teeb in forum Excel General
    Replies: 2
    Last Post: 11-13-2006, 03:16 AM
  5. Code Tweak
    By bodhisatvaofboogie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2006, 11:40 AM
  6. Can someone please tweak my Macro?
    By Wibs in forum Excel General
    Replies: 3
    Last Post: 12-15-2005, 01:15 PM
  7. One more final tweak...
    By M. Stanley in forum Excel General
    Replies: 3
    Last Post: 01-14-2005, 08:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1