|
PB and EXCEL using OLEOBJECT, Save() fails on VISTA
|
| |
I am exporting a datawindow to excel using an OLEOBJECT. Everything works great and was shipped to the customer. Development was on XP, the customer is on VISTA. The code works great on XP, but the Save() function fails on VISTA only. The code in question is: OleObject.application.workbook s(1).save()... more »
|
|
|
PowerBuilder and Excel
|
| |
Hello all...we are using PB9.03 under a Sybase ASA 9.0.2 DB. Does anyone know where I could find some cool sites that would explain how I could facilitate communication and data exchange operations between a PowerBuilder App and Excel using OLE? Any info would be greatly appreciated...:)
|
|
|
Using IBH OPC Server
|
| |
Hi, I've to analyze the possiblity to use the IBH OPC Server [link] to communicate with Simatic S7 SPS Data Modules. Anyone has experience with that one and may drop some comments here? TIA Chris Werner f+s software gmbh
|
|
|
From PB, how to call Microsoft Excel MACRO funtion with a parameter?
|
| |
This is the MACRO in excel file test.xls: ------------------------------ ----------- Sub Test_csv_file(file_name As String) Range("L8").Select ChDir "C:\TEMP" Workbooks.Open Filename:=file_name ActiveWindow.SmallScroll Down:=-27 Range("A1:B6").Select Selection.Copy Application.CutCopyMode = False... more »
|
|
|
Save in Excel only saves copy in My Documents
|
| |
Hi, I am using OLE to manipulate an existing xls spreadsheet file in Excel 12 from PB 11.2 and XP. I have no problem opening and manipulating the spreadhseet file whatsoever. My problem lies in trying to Save() the workbook. With just the Save() method, it only saves a copy of the file in the My Documents folder. If I... more »
|
|
|
.NET Assembly question
|
| |
Powerbuilder 10.2, VStudio 2008 SP1 Hi All According to what I've read, this should be working though I don't do OCX much at all. I've created (had created) a DLL in .NET which brings up a window; currently it's a garbage window we put together for testing. The project has the 'expose for COM registration' checked, and we used the... more »
|
|
|
ConnectToNewObject Returns -2 or -4
|
| |
Hi, I am attempting to use PowerBuilder 11.5 with ArcGIS Engine 9.3 to make a Computer Aided Dispatch program for a law enforcement agaency. So far, I have been able to embed and populate the MapControl.ocx and ToolbarControl.ocx in PowerBuilder application without problem. I'm trying to translate a VB script to PowerBuilder to make an address... more »
|
|
|
Leading Zeroes Lost Saving HTML Table as Excel
|
| |
Leading Zeros are lost when saving an HTML Table to an Excel worksheet. I use OLE Automation to create/open a worksheet populated with data (using Open or OpenText automation functions) from an HTML table. The leading zeroes are dropped. I've been told in Microsoft forums that there is limited support for... more »
|
|
|
Factory control
|
| |
I want to make a control-room program for a small factory, where one can view the objects and some data. I.e. a fan and on or off status, som engines and on /off status. Any suggestions for a library/ocx that can support the visuals. Pål
|
|
|
|
