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] 2
1
Programming / Re: Create/Update Excel Workbook
« on: June 20, 2023, 04:02:37 PM »
Devon,
Thanks for the suggestion. I'll look into it.
Off topic...there used to be a keystroke from a command prompt that would display all the current variable values on the screen.
For the life of me, I cannot remember what it was.
Can you help jog my memory.
Thanks!
Tom
Thanks for the suggestion. I'll look into it.
Off topic...there used to be a keystroke from a command prompt that would display all the current variable values on the screen.
For the life of me, I cannot remember what it was.
Can you help jog my memory.
Thanks!
Tom
2
Programming / Re: Create/Update Excel Workbook
« on: June 20, 2023, 02:30:06 PM »
Issue finally resolved on creating Excel spreadsheet.
One other question - my customer uses a number of thin clients in the plant for production entry. All these clients have installed is the Windx client to run the PXPlus software.
It appears you cannot create an Excel spreadsheet from any of these machines do to the fact that Excel is not installed on them.
Is there a way to create and update a spreadsheet without having Excel installed?
Thanks!
Tom
One other question - my customer uses a number of thin clients in the plant for production entry. All these clients have installed is the Windx client to run the PXPlus software.
It appears you cannot create an Excel spreadsheet from any of these machines do to the fact that Excel is not installed on them.
Is there a way to create and update a spreadsheet without having Excel installed?
Thanks!
Tom
3
Programming / Re: Create/Update Excel Workbook
« on: June 09, 2023, 01:22:44 PM »
Susan,
I was not using Windx with version 20.
I checked and have version 1600 installed.
I will open a support ticket per your suggestion.
Tom
I was not using Windx with version 20.
I checked and have version 1600 installed.
I will open a support ticket per your suggestion.
Tom
4
Programming / Re: Create/Update Excel Workbook
« on: June 09, 2023, 10:26:08 AM »
Update - downloaded and installed demo version of version 20 and the program now works as expected.
I am wondering if I have the latest version of 16 installed. When I look on the website it shows 16.2 in the downloads section.
How can I determine exactly what version I have installed?
Thanks!
I am wondering if I have the latest version of 16 installed. When I look on the website it shows 16.2 in the downloads section.
How can I determine exactly what version I have installed?
Thanks!
5
Programming / Re: Create/Update Excel Workbook
« on: June 09, 2023, 09:19:35 AM »
James,
hta(x_obj'sep$) = 8A
Windows Server 2019. Using Windx running on Windows 7, 10 and 11. Tried them all. Same result. Latest Excel version and also tried Excel 2016.
hta(x_obj'sep$) = 8A
Windows Server 2019. Using Windx running on Windows 7, 10 and 11. Tried them all. Same result. Latest Excel version and also tried Excel 2016.
6
Programming / Re: Create/Update Excel Workbook
« on: June 08, 2023, 05:37:52 PM »
Also,
I tried the program on customer's system today and got the same results (v16)
I tried the program on customer's system today and got the same results (v16)
7
Programming / Re: Create/Update Excel Workbook
« on: June 08, 2023, 05:36:04 PM »
Susan,
When I print x_obj'sep$ I get nothing back.
I added the visible statement and the sheet shows with the same wrong data immediately after the write.
Tom
When I print x_obj'sep$ I get nothing back.
I added the visible statement and the sheet shows with the same wrong data immediately after the write.
Tom
8
Programming / Re: Create/Update Excel Workbook
« on: June 08, 2023, 05:05:03 PM »
James,
The retval after each step is 1
Tom
The retval after each step is 1
Tom
9
Programming / Re: Create/Update Excel Workbook
« on: June 08, 2023, 03:47:31 PM »
Susan,
Have you had any other thoughts as to how to solve this issue?
Anyone else on here have any ideas?
Thanks!
Tom
Have you had any other thoughts as to how to solve this issue?
Anyone else on here have any ideas?
Thanks!
Tom
10
Programming / Re: Create/Update Excel Workbook
« on: June 07, 2023, 05:18:40 PM »
Susan,
The only thing that has been changed in the default settings is the font for the cells.
Everything is as it is from the initial install.
Using the latest version of Excel fully patched.
Thoughts?
Tom
The only thing that has been changed in the default settings is the font for the cells.
Everything is as it is from the initial install.
Using the latest version of Excel fully patched.
Thoughts?
Tom
11
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 07:27:12 PM »
OK, getting closer.
Created the following program:
01000 LET X_OBJ=NEW("*obj/excel")
01020 LET PATH$="c:\qc_updates\test.xlsx"
01040 LET RETVAL=X_OBJ'CREATEWORKBOOK(PATH$,1)
01060 LET RETVAL=X_OBJ'SETRANGE("A1:E1")
01080 LET NEW_RANGE$="one"+SEP+"two"+SEP+"three"+SEP+"*four"+SEP+"five"+SEP
01100 LET RETVAL=X_OBJ'WRITE(NEW_RANGE$)
01120 LET RETVAL=X_OBJ'SAVEWORKBOOK()
01140 LET RETVAL=X_OBJ'CLOSEWORKBOOK()
01160 DROP OBJECT X_OBJ
It completes successfully but the data in the cells A1 - E1 is the number 32003 in each cell.
Suggestions?
Tom
Created the following program:
01000 LET X_OBJ=NEW("*obj/excel")
01020 LET PATH$="c:\qc_updates\test.xlsx"
01040 LET RETVAL=X_OBJ'CREATEWORKBOOK(PATH$,1)
01060 LET RETVAL=X_OBJ'SETRANGE("A1:E1")
01080 LET NEW_RANGE$="one"+SEP+"two"+SEP+"three"+SEP+"*four"+SEP+"five"+SEP
01100 LET RETVAL=X_OBJ'WRITE(NEW_RANGE$)
01120 LET RETVAL=X_OBJ'SAVEWORKBOOK()
01140 LET RETVAL=X_OBJ'CLOSEWORKBOOK()
01160 DROP OBJECT X_OBJ
It completes successfully but the data in the cells A1 - E1 is the number 32003 in each cell.
Suggestions?
Tom
12
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 04:22:57 PM »
Susan,
Using version 16.
Tom
Using version 16.
Tom
13
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 04:12:02 PM »
Jeff,
Here is what I get:
-}def object excel_obj,"[WDX]Excel.application"
-}filename$="c:\qc_updates\test.xls"
-}workbook=excel_obj'workbooks'open(filename$)
Error #88: Invalid/unknown property name
Tom
Here is what I get:
-}def object excel_obj,"[WDX]Excel.application"
-}filename$="c:\qc_updates\test.xls"
-}workbook=excel_obj'workbooks'open(filename$)
Error #88: Invalid/unknown property name
Tom
14
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
15
Programming / Re: Using CTL in panel
« on: October 31, 2022, 10:54:57 AM »
Mike,
I don't remember anywhere in the app using DEFCTL or 'FL'.
I'll open a support ticket and see where we go on this.
Thanks for your help!
Tom
I don't remember anywhere in the app using DEFCTL or 'FL'.
I'll open a support ticket and see where we go on this.
Thanks for your help!
Tom
Pages: [1] 2