PxPlus User Forum

Twitter Twitter Twitter

Show Posts

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.


Messages - Tom Anderson

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

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

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

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!


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.


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)

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

8
Programming / Re: Create/Update Excel Workbook
« on: June 08, 2023, 05:05:03 PM »
James,

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

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

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

12
Programming / Re: Create/Update Excel Workbook
« on: June 06, 2023, 04:22:57 PM »
Susan,

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

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

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

Pages: [1] 2