Stack Overflow
Stack Overflow

Questions tagged [createoleobject]

33 questions
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
0
votes
0 answers

Adding Ole Objects in Excel throw error when running from VBA

I have a very simple code which runs without errors when run from inside VBA , using F5 command. Nevertheless if I try to run the code stept by step using F8 even though it inserts the object it throws the message "Can't enter break mode at this…
Andrei
  • 155
  • 1
  • 1
  • 7
0
votes
0 answers

When embedding an OLEObject (Word/XLS/PDF doc) into Excel via powershell, unable to save that

When I embedding an OLEObject (Word/XLS/PDF doc) into Excel via powershell, I'm unable to save the excel file (I'd like to save manually, not via PShell - but does not work automatically either). If I insert object like *.txt, png,jpeg - there is no…
kegloadam
  • 11
  • 2
0
votes
0 answers

Power Point OLEObject

I am creating a OLEobject from other application (NX Cad) in a power point. After Creation of the powerpoint I am unable to edit the values of the Sheet I created. It is Vanishing and showing only Sheet1 with No values. How to update or fix this. …
Joe
  • 1
  • 1
0
votes
1 answer

Add/View OLEObjects using MS Access VBA

Based on Add/view attachments using MS Access VBA is there a way to act the same way but this time for OLEObjects? How can we replace the AddAttachment method?
Metal
  • 1
  • 4
0
votes
2 answers

Copying & Pasting information from Microsoft Word OLEObject to Excel file via VBA

My issue is after I have imported a table from Microsoft Word into Excel by creating an OLEObject, it won't let me copy and paste the table into excel. It continually keeps pasting whatever was last copied on my clipboard into the first cell.…
Davey
  • 123
  • 1
  • 3
  • 18
0
votes
1 answer

When embedding an OLEObject (Word/XLS/PDF doc) in Excel, how can I set the icon's position relative to the attachment button?

I'm trying to create a button that will allow me to attach Word/Excel/PDF files. I've read a bunch of other articles and tutorials, so I now have the button and a VBA macro that gives me a dialogue box to browse to my file of choice. The file can be…
JKay85
  • 27
  • 7
0
votes
1 answer

OLE Object in PowerBuilder

Can anybody tell me how to set the value of a checkbox in a word document using OLE object? I'm using form fields (dropdown and checkbox) in the Word document. I am using PB 7. Thanks!
XLD_a
  • 195
  • 1
  • 4
  • 16
0
votes
1 answer

VB.NET - PowerPoint VSTO - Insert PDF?

Is there any code in PowerPoint VSTO (VB.NET) to insert a PDF file to slide? In PowerPoint VBA below is the code, Set oShp = oSld.Shapes.AddOLEObject(Left:=100, Top:=100, Width:=200, Height:=300, Classname:="Shell.Explorer", Link:=msoFalse)
Codename K
  • 890
  • 4
  • 23
  • 52
0
votes
1 answer

PowerPoint - Shapes.AddOLEObject method adds the web browser control in black?

Please see the below link first, Shapes.AddOLEObject method not working in PowerPoint 2013 (32bit and 64bit)? Half the issue was solved there first. So, I am using the following code to add web browser control to PowerPoint slide, Set oShp =…
Codename K
  • 890
  • 4
  • 23
  • 52
0
votes
1 answer

Run-Time Error '1004': Unable to get the Add property of the OLEObjects class

I have a worksheet that upon opening it makes sure that every sheet has a button. So when a new sheet is present that doesn't have a button, it is set to add it. A few months ago I'm pretty sure this worked, but now (after not using this sheet for…
neogeek23
  • 813
  • 1
  • 12
  • 23
0
votes
1 answer

VC++ programmatically add excel OLEObject?

I'm having trouble adding an OLEObject to an excel worksheet in VC++ using Interop libraries. Compiler is VC++ 2010 express. Interop libraries are for Office 2007. Here's the declaration: #define XL…
knp54
  • 31
  • 2
-1
votes
1 answer

How to access a ListBox on a UserForm by name?

I have a UserForm with multiple ListBoxes. I need to access a ListBox by name (and not directly by an object reference). I'm trying to follow the recommendations from this post: Dim ws As Worksheet, Field As String, lbName As String, lb As…
Dmitry D. Onishchenko
  • 145
  • 2
  • 12
1
2
3