This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
Programming / Create/Update Excel Workbook
« on: June 06, 2023, 02:12:47 PM »
I am attempting to create and update an Excel workbook from within PxPlus. I have read through the documentation and cannot not get it to work. I keep getting error 20's so obviously I do not understand how to format the code correctly.
All I want to do is create a new workbook or overwrite an existing one if it exists. Then I need to add data to the first worksheet within the workbook.
Could someone assist with some simple code to accomplish this.
Much thanks!
Tom Anderson
All I want to do is create a new workbook or overwrite an existing one if it exists. Then I need to add data to the first worksheet within the workbook.
Could someone assist with some simple code to accomplish this.
Much thanks!
Tom Anderson
2
Programming / Using CTL in panel
« on: October 25, 2022, 04:03:40 PM »
I have a Nomads panel with a multiline control. I am wanting the user to hit a specific function key (F1 - F12) to perform a specific task.
When I hit the F key nothing happens except that the cursor moves to next panel control. If I break out of the program and from prompt enter ? CTL - every F key returns a value of -1001.
On the panel under then CTLS option, I have defined say F10 with a CTL value of 10 and the Process as 'Perform' ";do_task". But task is not done.
How can I get the F keys to return what I need?
Any help greatly appreciated!!
Tom
When I hit the F key nothing happens except that the cursor moves to next panel control. If I break out of the program and from prompt enter ? CTL - every F key returns a value of -1001.
On the panel under then CTLS option, I have defined say F10 with a CTL value of 10 and the Process as 'Perform' ";do_task". But task is not done.
How can I get the F keys to return what I need?
Any help greatly appreciated!!
Tom
3
Programming / Escape
« on: June 10, 2022, 07:41:14 PM »
When working on my desktop, I can press CTRL + Break to escape from the program and reach a command prompt.
But on my laptop, there is no break key and I can't the program to break.
Does anyone know of another KB sequence that will break the program?
Thanks!
Tom Anderson
But on my laptop, there is no break key and I can't the program to break.
Does anyone know of another KB sequence that will break the program?
Thanks!
Tom Anderson
4
Programming / Create Excel Spreadsheet from PvxPlus
« on: June 01, 2022, 10:44:58 PM »
I have a grid with 10 columns and would like to be able to send the data to an Excel spreadsheet from within my PvxPlus program.
I have reviewed the PvxPlus manual but can't seem to get the syntax right.
Could someone give me some simple syntax to create a new sheet (or open an existing sheet), write the data to the sheet and save it.
Any help would be greatly appreciated!
Tom Anderson
I have reviewed the PvxPlus manual but can't seem to get the syntax right.
Could someone give me some simple syntax to create a new sheet (or open an existing sheet), write the data to the sheet and save it.
Any help would be greatly appreciated!
Tom Anderson
5
Off Topic / Notifications
« on: April 10, 2019, 07:17:50 PM »
I registered on this forum a number of months ago but never receive any notifications on the discussions that I set up to be notified on.
Can anyone give me some guidance as to what I have done wrong?
Thanks!
Tom Anderson
Can anyone give me some guidance as to what I have done wrong?
Thanks!
Tom Anderson
Pages: [1]