I've got all the parts but lack the programming knowledge to apply what I want. I've built a SQL query that will generate a directory listing of all the files existing in the directory that will store the files that need to be processed along with the column that contains the information I need to edit for each file. (I have output the results to the file startpos.xls)
The macro will open the file specified, sort it by the specified column, and delete all blanks,and values between -25 to 0, and the values of 'del' or 'memo' then save the resulting file to a different directory then loop to begin again with the next item on the list until completed.
the macro portion looks like this
The items in bold are the items that would need to be set as variables and prefilled with the data from the SQL table and obviously a loop and the SQL connection information. Can anyone help me with the steps I'm missing to make this work?
Bookmarks