+ Reply to Thread
Results 1 to 11 of 11

Modifications to code

  1. #1
    Registered User
    Join Date
    07-03-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    8

    Modifications to code

    Can anyone help me with modifying my code to make the output appear in the same sheet? Thank you.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Modifications to code

    Try adding/changing these:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-03-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Modifications to code

    I'm looking at replacing the whole sheet with the new set of data

  4. #4
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Modifications to code

    Then I guess your best solution would be the original one, which outputs to a new worksheet, and then just simply delete your original source worksheet.

  5. #5
    Registered User
    Join Date
    07-03-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Modifications to code

    Is there really no way to sort of refresh the sheet with the new data?

  6. #6
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Modifications to code

    Might be possible if you posted a sample workbook, people will need to look at how the data is displayed and then come up with a solution to treat it.

  7. #7
    Registered User
    Join Date
    07-03-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Modifications to code

    sample.xlsx

    Attached is the sample workbook. Rename the sheet with Office_Metadata and make sure the name "Sheet1" is present if you're using the existing code. Thanks!

  8. #8
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Modifications to code

    Try this code:

    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    07-03-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Modifications to code

    Seems like the first set of data (first 10 rows, number may vary) is missing, the rest gets displayed

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,327

    Re: Modifications to code

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Modifications to code

    Quote Originally Posted by exlecel123 View Post
    Seems like the first set of data (first 10 rows, number may vary) is missing, the rest gets displayed
    Right, sorry did not look carefully into it. Try this amended code:

    Please Login or Register  to view this content.

+ 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. [SOLVED] File won't open in XLSTART after modifications in macro code are made
    By HitTheEXCELerator in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2013, 06:14 AM
  2. excel form modifications
    By Lins in forum Excel General
    Replies: 1
    Last Post: 11-22-2012, 12:02 PM
  3. [SOLVED] Pivot Table Code Modifications
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-14-2012, 10:43 AM
  4. Add-in modifications
    By Jacques Grobler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2011, 02:50 AM
  5. PivotTable modifications via VBA
    By fecurtis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2008, 04:04 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