Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB CODE REQUIRED..........HELP PLEASE
do have two sets of files
1. abc.csv,xyz.csv,pqr.csv....till n (Master files); format as below: Date Price 02-11-07 168 01-11-07 165 2. Trans.xls; format as below: File Date Price abc.csv 02-11-07 169 xyz.csv 02-11-07 251 Now i want as follows: abc/xyz/pqr.csv is updated from trans.xls everytime i run the code. it must look whether data relevant to "Date" exist or not? If Exist write over it and save & close the .csv files; if not exist insert a line after first row and put the data there. Both file have different directory. i can put both files in same directory. Any help would be greatly appreciated... -- Nikesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another VB Code Required | Excel Discussion (Misc queries) | |||
VB Code Required | Excel Discussion (Misc queries) | |||
VB code Required-------! | Excel Programming | |||
Code help required | Excel Programming | |||
Code required please | Excel Programming |