Stack Overflow
Stack Overflow

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
5
votes
4 answers

automate excel file processing in perl and avoid dialog/UI interactions

How can a I guarantee that no pop-up dialogs will appear when I automate Microsoft Excel through OLE? I'm using a Perl module (Win32::OLE). I can avoid most dialog pop-ups using the following code: use Win32::OLE; use Win32::OLE::Variant; use…
schwerwolf
  • 250
  • 1
  • 7
  • 20
5
votes
3 answers

Powerpoint VBA - Editting Column Name of Table in Embedded Excel OLE Object

If you run the following code you get quite an interesting result(with only PowerPoint running, close all instances of Excel before running): 'Optional - Include the "Microsoft Excel 16.0 Object Library" Option Explicit Public Sub test() …
David Rogers
  • 2,601
  • 4
  • 39
  • 84
5
votes
2 answers

Importing Excel data into C# without first row becoming column names?

I am trying to import data from excel into a datatable using c#. Here is the code I use to do so... string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + "; Jet OLEDB:Engine Type=5;" + …
PICyourBrain
  • 9,976
  • 26
  • 91
  • 136
5
votes
2 answers

Delphi 7 Excel Ole object text font color

How can I set font color in cell (half text other color) in delphi 7 and with MS Excel 2007+ ? Example:
InnerWorld
  • 585
  • 7
  • 26
5
votes
1 answer

Is it possible to have Delphi auto-generate event-support code for an imported OLE/COM type library?

I'm trying to generate _TLB import units for Outlook 2003, 2007 and 2010 (and also other OLE servers) analogous to the ones bundled with Delphi for Outlook 2000 and 2002. However, I couldn't get the type library importer to also generate the code…
Oliver Giesen
  • 9,129
  • 6
  • 46
  • 82
5
votes
1 answer

`DoVerb(ovInplaceActivate)` crashes with various error messages when a document's data is extracted from TOleContainer

One customer experiences some strange behaviour with our software when working with Office documents via OLE. The code crashes when an instance of some derived TOleContainer class tries to activate the OLE object via DoVerb(ovInPlaceActivate)…
René Hoffmann
  • 2,766
  • 2
  • 20
  • 43
5
votes
2 answers

How to extract the contents of an OLE container?

I need to break open a MS Word file (.doc) and extract its constituent files ('[1]CompObj', 'WordDocument' etc). Something like 7-zip can be used to do this manually but I need to do this programatically. I've gathered that a Word document is an OLE…
Ben L
  • 6,618
  • 8
  • 39
  • 34
5
votes
1 answer

CreateOleObject in a 64-bit Delphi program?

In a Delphi XE7 64-bit VCL program, the unit Vcl.OleAutocannot be found: [dcc64 Fatal Error] Unit1.pas(33): F1026 File not found: 'Vcl.OleAuto.dcu' While it works without problems in a 32-bit program: uses Vcl.OleAuto; ... FSWbemLocator :=…
user1580348
  • 5,721
  • 4
  • 43
  • 105
5
votes
1 answer

Where can I get a Running Object Table Viewer like IROTVIEW?

Once upon a time Windows SDK (or it was Visual Studio) had a tool named IROTVIEW which enumerated the Running Object Table (ROT). Where can I get this tool now?
Mike
  • 1,274
  • 10
  • 24
5
votes
2 answers

msxml3.dll in context sp_OAMethod 'send'

Working code from Win2003 + SQL Server 2005 is not working under Win2012 + SQL Server 2012 sp1. The only ~real solution I found is: I copied C:\Windows\System32\msxml3.dll from a Server 2008 to the same dir on a server 2012. Problem on 2012…
revoua
  • 2,044
  • 1
  • 21
  • 28
5
votes
2 answers

PowerPoint 2013 loses focus after Export OLE VBA command

I create an OLE instance of PowerPoint and send commands to it: procedure ExportSlide(const SlideIndex : Integer); var ppt : Variant; begin ppt := GetActiveOleObject('Powerpoint.Application'); …
rjobidon
  • 3,055
  • 3
  • 30
  • 36
5
votes
1 answer

Why does every class in VBA have an Application property?

I would like a bit of clarification about why each class (or nearly each class) in VBA (when you scroll through Object Browser) has an Application property. MSDN says When used without an object qualifier, this property returns an Application…
user2140173
5
votes
1 answer

Need ActiveX control to embed Excel into a dialog

I'm building an "import from Excel" function. It has to be in a DLL, called from a non-MFC app. Has to provide an image of the spreadsheet that users can drag a select box around (to select cells), then click an IMPORT button, and have the right…
Steve
  • 1,065
  • 15
  • 34
5
votes
3 answers

Save a pdf file that's been opened in Internet Explorer with OLE and Perl

I am looking for a way to use Perl to open a PDF file in Internet Explorer and then save it. (I want the user to be able to interact with the script and decide whether downloading occurs, which is why I want to pdf to be displayed in IE, so I…
itzy
  • 11,275
  • 15
  • 63
  • 96
5
votes
1 answer

How can I open a Word document read-only from Perl?

Is there any method within Perl which would allow me to get the object in a read only mode, so as to avoid the dialog that pops up if the file is locked by another user? $document = Win32::OLE->GetObject("$docFile") or die "can't open…
EvilTeach
  • 28,120
  • 21
  • 85
  • 141
1 2 3
…
86 87