Hi, I'm wanting to automate my daily report from the output I get from SAS Enterprise Guide. I'm able to export it to an excel file and save the files I need in a folder. Now I need to figure out a way to pull those data from the output file and populate my columns on a daily basis. Please refer to the screenshots below. What do I write in VBA or can I use power query and task scheduler to carry out this action?
My daily report file:
Source file that I need to run daily.
My daily report file:
Source file that I need to run daily.