I get a daily, automated e-mail that contains multiple excel attachments. The goal is for the files to be auto-downloaded into a file on my desktop, so I can pull multiple files into a power query as needed.
I’ve come up with a way to map all of the files into my google drive, but they’re being imported as a zip file. Ideally, I’d rather them be imported on a file level basis - not zipped.
What I’m trying to solve for at this point is how to download the files once a day into said file in my desktop.
My questions are as follows:
- How can I import the files individually, instead as a zip? Is this possible?
- How can I move these files (either individually, or zipped) onto a set folder on my desktop?
- Is there a more efficient way to do this that doesn’t involve parking the file in google drive first? How would that be done?
Best answer by DanversView original