I'm using "transferspreadsheet" in some VBA code in Excel that transfers some Excel data to an Access table. I had the code in VB6 and it worked fine, but I needed to put it into the actual Excel sheet that's being transferred and when the transfer takes place, everything appears to work fine, BUT when I open the Access file, it doesn't have the most up to date changes every time. SOMETIMES it does, other times it doesn't. Has anyone else run into this problem or have any tips for me?