Posts by aj_hyd_vol1

    Sorry, File extension format not allowing to attach the files.


    Hi Dangelor


    Thank you very much for your code and for your time spent on this. When I paste the code in VBA I'm getting error code 1004. I'm not figure out what's the wrong on my side. I'm attaching source files and explaining what I need from those files. Please do the needful, it will be a very helpful to complete the process.


    I have *.csv and *.DAT files in c:\1 directory. What I need is I have to open date-wise *.CSV file then again I have to open same date file of *.DAT extension file. In that *.DAT file I have Unit,1,2,3 columns. In the 3rd column numeric data should bring to *.CSV file 'B" column. For this I'm using manual operation using "vlookup". But that is time taking process to do the 100s of files. (For this I'm importing *.DAT file to excel using DATA > from text > comma delimiter > process.)


    When I'm trying to attach the file it's not allowing to do. I'm pasting the data for your quick reference. In the *.CSV file data format is like this.



    Column AColumn B
    Unit
    SRIKAKULAM
    VISAKHAPATNM
    RAJAHMUNDRY
    TPGUDEM
    VIJAYAWADA
    MANGALAGIRI
    KAKINADA
    GUNTUR
    ONGOLE
    TIRUPATI
    NELLORE
    BANGALORE
    CUDDAPAH
    ANANTHAPUR
    BANGALORE
    CHENNAI
    MUMBAI
    DELHI
    HYDERABAD
    BENGAL


    In *.DAT file data format is like this :

    Unit,1,2,3

    SRIKAKULAM,10500,2250,1050

    VISAKHAPATNM,22500,1050,900

    RAJAHMUNDRY,10500,2250,1050

    TPGUDEM,10500,2250,1050

    VIJAYAWADA,10500,2250,1050

    MANGALAGIRI,10500,2250,1050

    KAKINADA,10500,2250,1050

    GUNTUR,10500,2250,1050

    ONGOLE,10500,2250,1050

    TIRUPATI,10500,2250,1050

    NELLORE,10500,2250,1050

    BANGALORE,10500,2250,1050

    CUDDAPAH,10500,2250,1050

    ANANTHAPUR,10500,2250,1050

    BANGALORE,10500,2250,1050

    CHENNAI,10500,2250,1050

    MUMBAI,10500,2250,1050

    DELHI,10500,2,1050

    HYDERABAD,10500,0,1050

    BENGAL,10500,2250,1050


    I request you to please help me to do the above using Excel VBA.


    Thanks with regards,


    ABabu

    Hi Dangelor


    Thank you very much for your code and for your time spent on this. When I paste the code in VBA I'm getting error code 1004. I'm not figure out what's the wrong on my side. I'm attaching source files and explaining what I need from those files. Please do the needful, it will be a very helpful to complete the process.


    I have *.csv and *.DAT files in c:\1 directory. What I need is I have to open date-wise *.CSV file then again I have to open same date file of *.DAT extension file. In that *.DAT file I have Unit,1,2,3 columns. In the 3rd column numeric data should bring to *.CSV file 'B" column. For this I'm using manual operation using "vlookup". But that is time taking process to do the 100s of files.


    I request you to please help me to do the above using Excel VBA.


    Thanks with regards,


    ABabu

    Yes. I have saved macro in a new work book. From that macro work book I need to open TAB01JUN2020.CSV then RTD01062020.csv. Then some data from RTD01062020.csv file need to be copied into the TAB01JUN2020.csv file. Like this I have so many files as I explained in the mail.


    I have to work with these types of files. DDMMYYYY will be dynamic in each file name. When I choose to open TAB03JUN2020.csv then automatically it should open RTD03JUN2020.csv file.


    I have a hundreds of files in the folder

    TAB01JUN2020.CSV

    TAB02JUN2020.CSV

    TAB03JUN2020.CSV

    TAB04JUN2020.CSV

    TAB05JUN2020.CSV .....so on

    and the second set of files in the same folder

    RTD01062020.csv

    RTD02062020.csv

    RTD03062020.csv

    RTD04062020.csv



    Thanks with regards,

    Hello all, Greetings...


    I have finished macro coding to merge data from one file to another file. My problem lies here.


    I have a hundreds of files in the folder

    TAB01JUN2020.CSV

    TAB02JUN2020.CSV

    TAB03JUN2020.CSV

    TAB04JUN2020.CSV

    TAB05JUN2020.CSV .....so on

    and the second set of files in the same folder

    RTD01062020.csv

    RTD02062020.csv

    RTD03062020.csv

    RTD04062020.csv


    I want to open a file TAB01JUN2020.csv (this is master file), after that I have to open another file checking the same date as is the master file i.e., RTD01062020.csv and merge the data using Macro which is I already done.


    My question is how to open same set of date files and do the macro work. If TAB01JUN2020.CSV opens then automatically it will check the same date and need to open the RTD01062020.csv file and do the macro job.


    I request you to all please help in this regard.


    Thanks with regards,


    Babu

    Hi


    Can u help any body in merging the multiple *.xls files into one single *.xls file but each *.xls file com in separate worksheet.


    Say i have 30 xls files in datewise i.e., 01.10.10, 02.10.10, 03.10.10 so on....


    I want to merge all the above 30 xls files in single file master workbook - in that master workbook file the above 30 xls should come in separate work sheets.


    Thank you