Questions tagged [ole-object]
9 questions
1
vote
0 answers
Embeding PDF in Excel using VBA with OLEObjects only gives first page
I'm using VBA to print multiple part numbers, but when I embed the pdf object into Excel I only get the first page of the pdf. I will need all pages of the pdf. If possible, I would like to make a new excel sheet for each page of the pdf. The only…
Nick Wester
- 13
- 4
1
vote
0 answers
Saving State of OLEObject ComboBox
I have some ComboBoxes in my Excel worksheet. When the user selects choices in these boxes, saves the document and opens it again, the selected items are gone. There are no choices available and nothing is selected.
I populate the boxes' choices via…
ascripter
- 5,665
- 12
- 45
- 68
0
votes
0 answers
Extract OLE image data from unbound object frame MS Access 365
We have a MS Access 365 form with a bound object frame, which is bound to a Varbinary(Max) column in the back end Azure SQL database.
The form was set up initially as a very quick fix so that users could paste screen shots from the snipping tool…
BiigJiim
- 165
- 1
- 1
- 10
0
votes
1 answer
Determine type of object embedded in bound object frame MS Access
We have a MS Access 365 form with a bound object frame, which is bound to a Varbinary(Max) column in the back end Azure SQL database.
The form was set up initially as a very quick fix so that users could paste screen shots from the snipping tool…
BiigJiim
- 165
- 1
- 1
- 10
0
votes
1 answer
Why not working properly when adding Oleobject (may a PDF file) to an Excel sheet by xlwings?
Environment
OS: win 7
Excel 2016 64bit
Python 3.7.8
xlwings 0.30.5
Issue
When I use the following code to add the PDF file into a Excel, the IconFileName and IconLabel parameters have no effect at all and the embedded PDF becomes a very small dot…
Egan
- 3
- 2
0
votes
0 answers
Bulk change OLE Picture in all reports in Crystal Reports - Visual Studio
I have a project that have several rpt files; all with a Logo (ICROleObject) in the header.
I want to change the logo in all the pages and I think that maybe there is a way to do it that doesn't require me doing it manually on each (100+) file.
I…
0
votes
0 answers
Using Paste command in Delphi OleContainer (MS Word)
I have an application working with MS Word (2007) OleContainer in Delphi 10.2.
I copy/paste an image on it with following command:
Copy:
vBmp:=iAssinatura.Picture.Bitmap;
Clipboard.Assign(vBmp);
Clip:=1;
Paste:
…
Renato Braz
- 11
- 3
0
votes
0 answers
Python pywin32 Adding Excel Object, IconLabel not displaying
I am using pywin32 module to add an excel file as an object in another excel file, I need to get the label added to it as Europe in the object. Even after adding the parameter IconLabel in code, I don't see any caption in the object attached to…
Keerthan G
- 1
- 2
0
votes
1 answer
VBA: code simplification for textbox in Worksheets
Main goal: The Value of each Textbox depends on different cells value in database
Previously i used these codes to implement same function to all the textboxes in an Userform :
Private Sub UserForm_Initialize()
Dim cntr As Integer
Dim cntr2 As…
taqiuddin yusri
- 11
- 3