Stack Overflow
Stack Overflow

Questions tagged [createoleobject]

30 questions
10
votes
2 answers

Delphi SAPI Text-To-Speech

First of all: this is not a duplicate of Delphi and SAPI. I have a specific problem with the "SAPI in Delphi" subject. I have used the excellent Import Type-Library guide in Delphi 2009 to get a TSpVoice component in the component palette. This…
Andreas Rejbrand
  • 95,177
  • 8
  • 253
  • 351
3
votes
1 answer

Delphi CreateOleObject events

There is a code: var myobject: OleVariant; begin myobject := CreateOleObject('SomeNamespace.SomeClass'); end; This COM object has events (for example OnClick). How should I connect to these events without importing TLB?
Yuriy Vikulov
  • 2,487
  • 5
  • 20
  • 29
3
votes
1 answer

Automation server is launched twice with CreateOleObject but not all the time

I have a program written in Delphi 7 that is also an automation server. The automation server is registered the following way: TAutoObjectFactory.Create(ComServer, TMyServer, Class_App, ciMultiInstance, tmSingle); I have two COM add-ins, one…
Steve
  • 2,438
  • 3
  • 30
  • 50
2
votes
1 answer

Write / Read OLE Object from MS Access to File System with Java

I have a desktop application with Java 7, where user can fill form with data and choose a picture (only .jpg format) with file chooser and that insert it to MS Access database (.accdb). The app admin can export all data inserted last month in .csv…
Dragan Menoski
  • 1,022
  • 13
  • 30
1
vote
1 answer

How can I create a new sheet with multiple command buttons(OLEObject)?

I am working on a code that has two command buttons: 1) USER INPUT 2) Execute When clicked, the USER INPUT button makes a UserForm appear. Based on the UserForm input, the worksheet format adjusts and the user inputs data to the worksheet where…
Dives
  • 13
  • 3
1
vote
1 answer

Remove border from OLEObject on sheet in Excel with VBA

I'm using VBA to generate an Excel sheet which includes ActiveX form controls. However the documentation available for the object properties is rather sketchy. I notice that when I create, for example, an OptionButton control, the object includes a…
Chris Melville
  • 1,330
  • 11
  • 22
1
vote
1 answer

OLEObject available verbs for Adobe Acrobat Documents

I'm embedding a PDF in an Excel file and then using VBA to open it as follows: Dim objMan As OLEObject Set objMan = ThisWorkbook.Worksheets("Public").OLEObjects.Item("Doc") objMan.Activate The problem I have is that it opens it in the background…
neelsg
  • 4,250
  • 5
  • 30
  • 55
0
votes
0 answers

OLEObjects.Add to right hand side of cell

I want to create a button that opens an image. This code works (if there's some text/numbers already inside column A, before you run it), but it will put the button on the left hand side of the B column. How can I adjust the code so that the button…
Jase
  • 829
  • 1
  • 7
  • 25
0
votes
0 answers

options to create a pdf file of a microsoft project screen so it can be inserted to an excel workbook as an OLEObject

I wish to capture a screen shot of a Microsoft Project view (table data and Gantt portion of the view), save to a pdf so the PDF can be loaded as an OLE Object onto an excel worksheet. I have tried EditCopy and EditCopyPicture, but both of these…
dgr
  • 1
  • 1
0
votes
0 answers

Cannot insert object AddOLEObject Excel C#

I am trying to add pdf file in Excel using shapes object. But every time I am getting following exception: Cannot insert object. at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[]…
Sunny
  • 2,897
  • 5
  • 27
  • 58
0
votes
1 answer

How to add image file as Ole object in excel using java

I tried with Aspose cell. But I am able to add pdf file properly. When I add jpg file, it shows in the excel file but doesnot get opened. I tried with following way. sheet.getOleObjects().get(oleObjectIndex).setImageData(binary); …
Swapnil Hadge
  • 5
  • 7
0
votes
0 answers

Assign a picture stocked in Excel workbook to a new remote created Word document with VBA

Morning everyone, I'm looking for a method to allow an Excel user to create a Word document (this already works for me with Word Object Library), to add a picture object in this Word document, and finally to personalise this picture by…
theophile69
  • 41
  • 5
0
votes
1 answer

difficulty in creating an icon that can be sized

I am using the combination of: Application.DocumentExport SaveFileName, pjPDF, FromDate:=EarliestStart-30, ToDate:=LFin+30 and xlbook.activesheet.OLEObjects.Add(FileName:="C:\Macros\Target-" & t & ".pdf", Link:=False, _ …
dgr
  • 57
  • 5
0
votes
1 answer

Modify embedded Excel workbook in another Excel workbook VBA

I have an Excel workbook in which I have embedded another Excel workbook. I am able to open it with VBA, but I have no idea how to refer and edit some cells in embedded workbook. Any idea how to do that? Thanks a lot in advance. Sub…
Dalmar
  • 3
  • 2
0
votes
0 answers

How to properly use oleobjects and recordsets?

I've some issues with OLEObjects and recordsets... I create some controls on the fly in my code. I prepare them, I fill them, and then I use the data collected from them to run a query on an AS400 (adodb). When I get the data back I've this issue…
Yosh
  • 1
  • 2
1
2