more quick actions
minimize quick actions
Topic starter
Hello everybody,
Have you ever seen by scada basic one application load and run on an other computer.
There is information in the help, but my sample project doesn't work.
In fact, I would like to use excel on a webvue client computer. At this moment, Excel works only on my webvue server computer.
This is my function to run Excel in local computer:
Sub Appli_local()
dim res as integer;
res=application("LOAD", "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.exe", "Classeur1");
print("res = ",res);
End Sub
This is my function whose the result is "0" to run Excel in remote computer:
Sub Appli_distant()
dim res_distant as integer;
res_distant=application("LOAD", "\\ROMAIN-PC\C\Program Files (x86)\Microsoft Office\Office14\EXCEL.exe", "Classeur1");
print("res = ",res_distant);
End Sub
Do you have an idea?
Both computer have Excel in the same place.
Posted : 03/07/2013 9:18 pm
Hi Fabien,
In my opinion, it should never be like that. The only way it could work is having an executable operating no interface (dll or data files). Let me explain: It COULD work if the executable is Microsoft Calculator because it is a kind of standalone application. In Excel case there are lots of files impacted.
In addition, if it works, it would mean a huge license problem. You could install Only once Microsoft Office on a computer and everybody in the company would use it !!!!
Further, the directory "Program Files" has specific rights and finally, even if you try to launch through the network, depending on the OS, you have a security popup asking you to confirm the next step. Maybe when using SCADA Basic, those behaviours are not transparent and lead to nothing ok.
To conclude, when launching an another application, WebVue is Webvue, not a client station !
Edouard
Posted : 04/07/2013 5:27 pm
Hello,
Two things:
1) I guess there is a missing character: "\\ROMAIN-PC\C$\...."
2) Sometimes you need to specify the working directory (seems Excel don't recquired it)
I'm not sure that in a WebVue context, the application will run on the client. I think it will start on the server station.
Posted : 04/07/2013 5:45 pm
Hi,
First of all, in a general way, when you are dealing with a command line you must try in the Windows console. If it works here it should work in PcVue.
Then for your specific issue Edouard is right. Do you think Microsoft will let you run a licensed file from one computer to another ?? 😛
If your need is to view only an Excel file you can install the Microsoft Excel viewer. You wont able to modify it but at least you can open it!
http://www.microsoft.com/en-us/download/details.aspx?id=10
Posted : 05/07/2013 7:02 am
Topic starter
In Webvue, we trust !!!
Thank Edouard, I think that you right about Microsoft licence. So Excel doesn't work on a webvue client station. As Florent said, you can only run Excel on the Webvue server.
But I tested this issue :silly: :
I saved my Excel file on my skydrive ( https://skydrive.live.com), we need to launch Excel in a web application and access it by an URL. After you can create a scada program like that:
Sub Connect()
'webvue("CONNECTURL", UserName, HtmlPage , BitVariableName, Reconnect, NewBrowser);
webvue("CONNECTURL", "", "https://skydrive.live.com/?cid=e19805290ea24a67&action=CreateFolder#!/edit.aspx?cid=E19805290EA24A67&resid=E19805290EA24A67%21265&app=Excel" , @Bit01, 0, 1);
End Sub
After I launched my webvue and clic on the button to run this function. The result is a new instance of IE with my excel file ( after enter my skydrive login and password, only the first time if you want).
I tested this function on the webvue server and different webvue client and this Excel file updated in real time.
To succeed, you must have a web application able to read an Excel file. My sample is Skydrive.
Posted : 09/07/2013 9:34 pm