Opening of Data log Excel file during RS view project running.
- Thread starter AB2005
- Start date
OkiePC
Lifetime Supporting Member
AppStart should work, but you may need to add the parameters to open the right file when you use it. Also, ti has been many years ago, but there were other steps that may be necessary to bring the app to the foreground after it has started.
Is this Data Log Excel file one that is already being used by RSView32 to collect data? If so, then the file will already BE open, so Excel will refuse to OPEN it again, even if you command it to do so with AppStart. If you need to see the data while running, you will have to use the already-open data, or set up another Excel file where the data is copied, then the file closed so you can open it again with AppStart.
If the Excel file is already OPEN, then you should be able to copy, view, or print the data without opening the file again. If the Data log file is Opened then Closed by RSView32, then you need to have your button check to see that the file is Closed, before it tries to OPEN it again.
Last edited:
Did you check all the Visual Basic macro routines to see if one opened an Excel file? Anyway, using Visual Basic routines that set up a CSV-type file name and write to it, is a common way to set up a log file in RSView32. Appstart is not needed if you use this method. Then you can use a timed RSView Event to periodically open and add to the CSV log file. Excel then can be used to externally open the file and view or print it.
Hi Lancie1
I have tried as you mentiond but found same results (see attached two images). When i press global configured key, Excel opens but does't appear on screen and when i stop the project, I found the Excel as minimized.
If I create a short cut on desktop for Excel and click on its icon, Excel opens normally but with same short cut with link coppied in Rs View, Excel does't appear on screen and remains minimized.
I have tried as you mentiond but found same results (see attached two images). When i press global configured key, Excel opens but does't appear on screen and when i stop the project, I found the Excel as minimized.
If I create a short cut on desktop for Excel and click on its icon, Excel opens normally but with same short cut with link coppied in Rs View, Excel does't appear on screen and remains minimized.
You probably will have to do 2 steps: Minimize RSView, then Open and Maximize Excel. Otherwise RSView will remain the "focus" and override the Excel program.
When you say "global donfigured key", is that your term for a new special "Short-cut" that you just created, and that is set up to Open Excel, but with it Maximized in the Window? If it is only your regular ordinary shortcut icon for Excel, then it will not Maximize the Excel screen.
Last edited:
Then what to do? My requirement is to open the Excel during normal Rs view project running. I can not enable Alt+Tab or Windows key as operators then play with system.
Gil47
Member
I do not know if this will work for you but it could be worth a try
Create a new Graphics screen, then go to Objects, and select ActiveX Control, then drag a box on the Graphics screen, and select an option probably Microsoft Office Spreadsheet.
From here you maybe able to then select the file you wish to view in Excel without providing access back to Windows Desktop
Create a new Graphics screen, then go to Objects, and select ActiveX Control, then drag a box on the Graphics screen, and select an option probably Microsoft Office Spreadsheet.
From here you maybe able to then select the file you wish to view in Excel without providing access back to Windows Desktop
How come no one trusts the Other Guy anymore to do his job without playing? How come all adults act more like kids while doing the serious work of the workplace? How come this is even something that you have to worry about?
While you are protecting yourself from these players, be sure to bolt all the Emergency Exits so they cannot get out during a fire.
Similar Topics
I have an Allen Bradley temperature switch that I am trying to use in studio 5000. I am getting the message "Unable to interpret the IODD file"...
Very similar issue as the last post I had here with communicating our Linux Gateway to an AB CompactLogix controller. I have assigned a gateway...
Hi All,
I am trying to program some new Versamax micro PLCs through PAC using some programs saved in our archive however whenever i go to import...
Hello, I have a CNG compressor that is run by a PLC. I tried to get team viewer on it to be able to view it remotely, I accidently disabled the...
Hi All, I've been pulling my hair out trying to fix this for a few days and need some advice.
I have V19.01, v20.05, V21, V24, V30, V31, V32...