I need some assistance. Let me preface this with I do not know VBA at all so pointing me to the right command in macro builder would be greatly appreciated.
Here's what I have:
A macro that deletes a temp table (DeleteObject), imports a file from a network drive (ImportExportSpreadsheet), appends it to an existing table, and runs a couple of queries (OpenQuery, OpenQuery).
What I would like to do is rename the file that I've imported from the network drive. It always has the same name (CurrentDay.xlsx). I would like to rename it to a date format (todays date as YYYY-MM-DD.xlsx).
What macro actions would I take to accomplish this?
Here's what I have:
A macro that deletes a temp table (DeleteObject), imports a file from a network drive (ImportExportSpreadsheet), appends it to an existing table, and runs a couple of queries (OpenQuery, OpenQuery).
What I would like to do is rename the file that I've imported from the network drive. It always has the same name (CurrentDay.xlsx). I would like to rename it to a date format (todays date as YYYY-MM-DD.xlsx).
What macro actions would I take to accomplish this?
