Send a sample file.. On Jun 20, 2:12 am, Asad Nedariya <asad4...@gmail.com> wrote: > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
