Hi all, I joined this group recently in order to get some help on Macro. I do not know much about macros but I am trying to learn and hence any help would be appreciated. Here is my problem description,
1. There is a folder called 'pH System' which contains multiple .CSV files which are named as pH_00000, pH_00001..and so on. New files are created everyday automatically by a program called SpecView.. 2. I want to write a macro which can look up all the .CSV files in pH folder and import the information I need to single EXCEL file with a click of a button. The Excel sheet will have two columns namely, date and result. 3. The cell A5 of each .CSV file contains a date and I want to import it as is to the date column of excel. 4. I want do some arithmetic operations on the (C) column of each .CSV before importing the result in the excel file. 4a. If column C does not contain 0 then Subtract the first cell (C2) from last cell (cell number varies) and import the result against respective date in excel. 4b. If column C contains '0' then subtract the first cell from the cell previous to '0' and add the result to the last cell. Finally, import the final result against respective date in Excel. I want and 'UPDATE' button in excel and once I click that button, it performs the operations mentioned above and updates the file with newly created .CSV files. It should not overwrite the previously imported data. I hope I have described the problem well in detail. However, if you need sample .CSV file or need to clarify something then let me know. Thank you. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
