Hi all,
this is a weird question. I receive a bunch of excel files with items to be added to a database. some of the items are to be added as new, some to be deleted and others to be modified.
I identify the action (add/delete/modify) by looking at a column in the excel file e.g. column A.
at this point I am fine with the add/delete because I can filter the data or bring all the files to a temporary table in an Access database via vba script and then running queries to do the rest.
My issue is that the spreadsheets have a lot of columns and for the modifications what they do is use the same file for instance, make changes on the cells (any cell) that need modification and then highlight, bold or underline only the items that need modification (a tedious process since I have to then open each file and then import them into access). I am looking for a way to open the file via script, identify the highlighted cells or the bolded text and writing the value of these cells into a text file or directly into an access database. I would really appreciate if anyone could point me to the right direction and thank you all in advance.
Thank you in advance.