Questions tagged [ole]

OLE Automation, is an inter-process communication mechanism based on Component Object Model (COM).

In Microsoft Windows applications programming, OLE Automation (now just Automation), is an inter-process communication mechanism based on Component Object Model (COM) that is used by languages that run on Windows.

References:

1296 questions
6
votes
3 answers

How to make Word invisible during OLE automation from Delphi

From our application we use OLE automation to build a fairly complex Word-document. I would like to make Word invisible while the document is being made, since there is a lot of pasting and insertions that takes quite a long time. I use the…
Svein Bringsli
  • 5,640
  • 7
  • 41
  • 73
6
votes
1 answer

Why is this C# COM class usable from VBScript but not JScript?

Consider the automation-compatible COM library in C#, given below. It follows a common COM pattern of having a visible factory coclass FooFactory implementing ICreateFoos which creates an object of type IFoo. FooFactory is the only coclass in the…
bacar
  • 9,761
  • 11
  • 55
  • 75
6
votes
0 answers

List of all OLE error codes

Is there a list of all OLE error codes?
Andrew Grimm
  • 78,473
  • 57
  • 200
  • 338
6
votes
1 answer

Perl subroutine timeout

I have a subroutine that normally takes 1 second to run. Sometimes, it can run infinitely. I want to move on in the code if the subroutine is taking too long (> 10 seconds) and ignore that run of that subroutine. Here is what I have so far using…
ansario
  • 345
  • 4
  • 13
6
votes
1 answer

Excel 2010 automation constants not working in Delphi XE7

I am trying to convert a program from Delphi 2010 to Delphi XE7 (32 bit/windows VCL). Code that used to work in D2010 that automated Excel via late binding OLE now gives the exception "Unable to set the Window state property of the application…
CHEAPS
  • 179
  • 3
  • 13
6
votes
1 answer

How do I create an OLE Control?

Without going into why I need OLE.. I need to embed a managed C++ custom control into MS Word 2007 (2003 also would be nice). So the question is How do I make this managed (.net 3.5) control OLE compliant ? It seems that I need to do something akin…
Gishu
  • 134,492
  • 47
  • 225
  • 308
6
votes
2 answers

Excel VBA create an embedded WebBrowser and use it

Hi I'm trying to dynamically create a web browser inside a spreadsheet and then use it but the WebBrowser functions don’t seem to work Here is how I create the WebBrowser Set myWebBrowser =…
oMG
  • 323
  • 1
  • 2
  • 14
6
votes
2 answers

Build Warnings Related to COM Reference (Version 1.0 Type Library) and VS 2010

I just finished restructuring and upgrading a bunch of C# projects from Visual Studio 2008 to Visual Studio 2010. Additionally, all of the projects were changed to target the .NET 4.0 runtime. Everything builds successfully but, I now get a bunch…
Grasshopper
  • 4,717
  • 9
  • 36
  • 62
6
votes
1 answer

Handling Events for OLEObject CommandButtons created at Runtime

I have struggled with this problem for while now...I want to do something very simple. I want to create multiple commandbuttons at runtime, and then handle events for these commandbuttons with one procedure. So I have built a "withevents" class to…
Sunny Sampath
  • 133
  • 2
  • 7
6
votes
3 answers

T-SQL writing to a file txt or csv

I've spent all day scouring the net on answers. Apparently tsql doesn't have its own nifty write to file commands. Here is my dilemma I have a load file that I am creating where a single line can reach 10K+ in length. On SQL Server varchar(MAX)…
John M
  • 1,813
  • 3
  • 15
  • 12
6
votes
1 answer

execute multiple update command on Excel

I have an Excel file and I want update multiple rows in a sheet.So I write this code : OleDbConnection cn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + serverPath + ";Extended Properties = Excel 8.0;"); try …
Arian
  • 12,793
  • 66
  • 176
  • 300
5
votes
1 answer

delphi ole excel container, save file

what is the syntax for this c++ question in Delphi? After using an oleContainer, and trying to do SaveDocumentAs which didn't work. I thought this might be a good alternative. update: thank you for the translation, however the excel file goes…
none
  • 4,669
  • 14
  • 62
  • 102
5
votes
0 answers

.NET 4.8 - Wrtiting COM library with parameterized properties

I am working on migrating legacy VB6 COM library that registered with regsvr32 and used primarily in vbscript and ASP Classic. The new .NET 4.8 substitution library is registered with regasm. All was good until I came across some features that I can…
SomeDude
  • 51
  • 3
5
votes
2 answers

"Unable to recognize OLE stream" excepion while connecting to Excel

I was trying to connect my Java program with an Excel file. I have did upto this. But it throws this excepion Unable to recognize OLE stream Please, help me to complete this. import jxl.*; import java.io.*; public class excel { public…
V I J E S H
  • 7,464
  • 10
  • 29
  • 37
5
votes
1 answer

How can I fill and get the PDF output of a Excel spreadsheet programmatically?

I have a Excel workbook that allows me to input the values of some fields, click on a button, and then a PDF report it's generated based on my input. I then have to choose the directory where to save this PDF file. I have to create an REST-like API…
adamasan
  • 1,092
  • 1
  • 12
  • 33