Reading Excel updates with UFT

I'am using HP UFT for testing. I get data from an Excel file and also write data to the same Excel file. My issue is that when i write data to the Excel file, I can't use it until the test is closed and UFT stops running (UFT won't read it, it's still blank to it).

I need a way to update UFT "view" of the Excel while running, i can't just close and open again the Excel file while test is still running. Language used: VBScript Can you help me?

Thanks