I have a spreadsheet that needs to be updated from values in my SQL DB.? I would like to do the following steps:
a) Open up a spreadsheet from my computer's directory.? The name of the file corresponds to a specific date: (i.e. import_export [login to view URL])
b)? lookup several? values for that date in my SQL db and update my spreadsheet for those values.? For example:? find the exchange rate in my DB for the Dec 24th data and put that value in the cell A3 of the "Main" tab.? The locations of all data stay the same
c) If the value in the spreadsheet? is already populated, then override the data in the spreadsheet.? If the value is not available yet in the DB, don't update the spreadsheet.
d) Need this to be updated on a daily basis for a date ranges of all spreadsheets in a specific directory (i.e last 60 days = 60 spreadsheets)
e) close each spreadsheet that you opened.
I would prefer that this solution be self-enclosed and not reliant on outside files.