access to vm folders

hi I have Excel 2016 installed on my Mac and Parallels 15 running Windows 10, but I have a Windows program which collects data for me every 2 hours. I need to write a macro which will open the file this program creates from the Windows side and copy the data to a standard Excel spreadsheet. For...