Hello,

I am currently trying to automate a process between access and excel to increase efficiencies. I have an excel file uploaded to a SharePoint at exactly 8:35 each morning. I would like to write a macro that would open or pull the worksheet into a local excel sheet. I found a code online but since I do not know much about VBA I cannot decipher it. Is this the right code and how do I modify it to serve my needs? Thank you. (assume the document is located in Sharepoint>>documents>>backlog.xlsx

Please Login or Register  to view this content.