Hi All,

 

I meet a problem, hope someone can help me.

 

I need make two buttons, when click the first button, it will open the excel file I point, then I will make some change in the excel file and save, the second button is import from the saved excel file just now. (We must do like this).

 

The script of the first button is "open URL" I fill "file://d:/Project/BOM.xlsx" in specify The second file, I use "file:BOM.xlsx" in Edit script, use Import Records.

Both can wok well on my notebook, but can not work when I put on the server computer and open it remote.

 

Please help if you know how to solve it.

 

Many thanks.

 

 

If import path can not be "file:BOM.xlsx", that is a relative path and you need an absolute path.

 

You need to transform the same path that you use in the Open URL step to a path that FM will understand for importing.  In this case:

 

filewin:/d:/ProjectBOM.xlsx

Hi Wim,

 

Thank you for your reply. I am sorry, can not work too. It cannot work when we put on server. What a headache.

Any other one can give me an advice? Many thanks in advance.

Doesn't work on the Server as it is not on Drive D: perhaps? What's the server drive letter?