Vlookup from external source(excel) win32com py

[marcoviolo]

Dear all,

I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a folder exits or new folder. Can you help me ?
Thank you in advance.

Marco

[dev7060]

I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a folder exits or new folder.

What have you done so far?