How to save a excel file from IE to a specfic location

Question

Hi,

I have managed to find answers here how to open IE and the website I want to acess, however I would like JMP to open the latest version of the file and save it to path. Any Ideas?

path = "...."

RunProgram(

executable( "C:\Program Files\Internet Explorer\iexplore.exe" ),

options( {adress to a excel file} )

);

when exicuted it looks like the following:

BR

Anders

anders_bankefor · Answer

hi everyone and thank you for your quick responses.

the link or webadress that i insert is not a direct link to a file rather a reference to a folder in a library. The link requiers me to choose a version of the file and if i want to view/edit the file. (the library is missing an API that would give me a direct reference to the file). I will get back to you with a log file.

What I really need is IE automatisation, for e.g i've seen that it is possible to have VBA macros that fills out forms. (mine just needs to find a checkbox and a button)

I will investigate if I can use a socket() as an alternative method.

thank you all for answering my questions.

Craige_Hales · Answer

Try

open("http://example.com/path.xls", "Excel");

We probably need to see a little more detail if that doesn't work; check the log for messages too. I'm not sure if the url you have is the url for a page of links to files or the actual file's url.

txnelson · Answer

Try using Load Text File() function.  I have not tried it in your situation, but conceptually it should read it as a text string.

I tried an example and I couldn;t get it to work.