+ Reply to Thread
Results 1 to 4 of 4

VBA to delete specific sheets and save multiple files as CSV

  1. #1
    Registered User
    Join Date
    01-18-2023
    Location
    bulgaria
    MS-Off Ver
    2016
    Posts
    31

    VBA to delete specific sheets and save multiple files as CSV

    i have 5000 xlsx files in one folder, each one xlsx file has two sheets , one is named: Filters , other is named: Results , i have this VBA code to delete the sheet with the name : Filters , and then to convert the xlsx file to csv , but just is not working ! (im attaching 1 of the xlsx files)
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 01-30-2023 at 02:38 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: VBA to delete specific sheets and save multiple files as CSV

    Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

    A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

    Since you are an infrequent user of this site, on this occasion, I have changed it for you.

    However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

    To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.



    Regards,

    Glenn.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  3. #3
    Registered User
    Join Date
    01-18-2023
    Location
    bulgaria
    MS-Off Ver
    2016
    Posts
    31

    Re: VBA to delete specific sheets and save multiple files as CSV

    ok , my mistake , wont happen again.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,064

    Re: VBA to delete specific sheets and save multiple files as CSV

    No problem. I can't help you, as I know nothing about VBA, but others will come along...

+ 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. Excel 2010 new Workbook not showing in VBA Project explorer
    By adamtzvi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2020, 08:50 AM
  2. Replies: 7
    Last Post: 12-15-2017, 12:14 AM
  3. Lookup Formula Issue, Search issue
    By kperitz in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-07-2014, 01:50 PM
  4. Issue with X axis values NOT graphing on Scatter graph and issue with Labels
    By lmausolf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 07:20 AM
  5. Issue - Image button issue - by JBeaucaire
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 05-06-2012, 07:35 AM
  6. [SOLVED] Issue - Attachment issue - by Simon Lloyd
    By Vaibhav in forum Suggestions for Improvement
    Replies: 16
    Last Post: 03-16-2012, 06:56 PM
  7. [SOLVED] Issue -Joke thread issue - Mordred
    By Vaibhav in forum Suggestions for Improvement
    Replies: 2
    Last Post: 02-17-2012, 01:31 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