+ Reply to Thread
Results 1 to 4 of 4

Saving Sheet Name from An Array not Working Anymore

  1. #1
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Saving Sheet Name from An Array not Working Anymore

    Hi guys,

    I need some help with this macro.
    Saving sheet names from an array of names doesn't work anymore and i don't know why.
    After some patch Excel is running odd and is not doing what it should do. This line of code doesn't work anymore ==> ThisWorkbook.Sheets(i).Name = Names_Array(m)

    Please Login or Register  to view this content.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Saving Sheet Name from An Array not Working Anymore

    What error message do you get?
    Also how many sheets are you copying & from how many workbooks?

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Saving Sheet Name from An Array not Working Anymore

    got no error, but the files are copied with their own name reportXXXX. i am copying 9 books.
    Seems that the error was just because there were some hidden sheets in the workbook.
    Don;t know why!

    Thank you!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Saving Sheet Name from An Array not Working Anymore

    Glad you resolved it & thanks for the feedback

+ 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. Saving Sheet Name from An Array not Working Anymore
    By IonutC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2019, 04:45 AM
  2. Saving Outlook Attachment to Folder not Working Anymore (SaveAsFile)
    By luckylindy345 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2018, 03:59 PM
  3. F1 Help key not working anymore
    By Phil8 in forum Excel General
    Replies: 0
    Last Post: 09-16-2017, 10:13 AM
  4. [SOLVED] CSV to XLSX Not Working Anymore
    By kas.samrari in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-24-2016, 07:41 PM
  5. VBA Macro not working anymore
    By winsomeness in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2015, 08:20 PM
  6. VLOOKUP not working anymore
    By Phil in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-27-2006, 02:45 PM
  7. unselecting not working anymore?
    By Joe Magiera in forum Excel General
    Replies: 1
    Last Post: 08-31-2005, 11:05 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