+ Reply to Thread
Results 1 to 2 of 2

Copying different CSV File and paste into the workbook in different sheet with names

  1. #1
    Registered User
    Join Date
    01-13-2011
    Location
    bangalore,india
    MS-Off Ver
    Microsoft 365 MSO (Version 2208 Build 16.0.15601.20858) 64-bit
    Posts
    24

    Copying different CSV File and paste into the workbook in different sheet with names

    Hi Gurus,

    I am posting thread after long time. Here is my need, i have 3 extracted CSV Files, in that files i want a range by giving dates and also with criteria having Filtered groups. finally paste that 3 CSV files into single XL workbook with different sheets with names which having macro. I believe my question is more understandable. I couldn’t attach sheets here. Based on my question u can able to judge my query and resolve this..

    note: whenever i run the macro, it should automatically search the CSV files in the locations, deleting the existing sheets in the macro.xls and adding new sheets with the name file name

    Advance thanks.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Copying different CSV File and paste into the workbook in different sheet with na

    Hi jaffirahamed1

    JB has some good example here https://sites.google.com/a/madrocket...ssistant/files to get you started
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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