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.

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

Hi Roy,

Sorry for the typo error in the file extension in my earlier mail.

The second batch files I have given that file format is not *.csv, it is *.dat file. I'm importing thorugh Data > from text option.

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

Re: Merge multiple *.xls files into one *.xls file in separate sheets

forum.ozgrid.com/index.php?attachment/33965/source file attached. kindly see that one. all files is same but different values. That's it.

Re: Merge multiple *.xls files into one *.xls file in separate sheets

Hi

The data contain in separate files. When running the code sheet1 file created. In that 32 worksheets is created. But no data - all are blank work sheets. What to do? kindly suggest?

Thank you.

Re: Merge multiple *.xls files into one *.xls file in separate sheets

And i'm doing the following. excel>tools>macro>vb editor>copied the code and run.... is it correct...?

Re: Merge multiple *.xls files into one *.xls file in separate sheets

Hi

Thanks. Basically i'm novice in vb code etc., The code is running. master file creating with 30 work sheets but there is no data..........all are blank sheets. Why?

Thanks again..

Re: Merge multiple *.xls files into one *.xls file in separate sheets

Hi

That solution is not perfect to me. Because i want all files in a single work book with separate sheets like sheet1, sheet2.....sheet 30 ... so...on..

thanks

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