ole object

Hi, as the title explains, how do I gather the displayed range of an Excel OLE Object embedded in a PowerPoint slide via VBA? I've looked through the zipped files but I couldn't find anything in the .xlm files. I've noticed when you 'Edit' the OLE Object, the displayed range is captured by...

Hi Everyone, I have one code which will browse document from provide path: Code: Sub Button1_Click() Worksheets("Sheet1").OLEObjects.Add Filename:="XXX", Link:=False, DisplayAsIcon:=False, Left:=40, Top:=40, Width:=150, Height:=10 End Sub My expectation: 1. Filename should be based on the...

Hello, I have an excel spreadsheet with multiple named fields across multiple sheets. I am generating a Word Document that is populated by embedded tables linked back to the named fields. However, I cannot find a way to add the field name to the properties of the object, so it outputs the whole...

Hi guys. I hope there's an answer to this one. I have a worksheet which demands panes to be frozen across both axes (select cell H11 then freeze panes). I also have a whole panel of ActiveX controls in the top-left corner (created at runtime with VBA, every time the document is generated). I...

Hi... need help sooon! I am trying to copy the text file which is embedded in my excel, and trying to paste it in a folder using the below code. ActiveSheet.OLEObjects(1).Copy CreateObject("Shell.Application") _ .Namespace(ActiveWorkbook.Path & "\") _ .Self.InvokeVerb "Paste" It is working...

Hello All, I'm trying to ascertain why the below macro works 90% on the time and the other 10% doesn't enable you to insert OLE_Object. Thus hoping someone could point me in the right direction. Public Function GetFileNameWithExt(ByVal FullPath As String) As String Dim fileName As String Dim...

Hi All, Trying to insert a Word Object in Excel... I can get to the point where the document looks great in Excel, but when I go go print/save as pdf- the formatting is all off. Is there a way that anyone knows to adjust the settings so when you insert the Word object in Excel, the settings...