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 Win32::OLE::Const; my $excel_symbols = Win32::OLE::Const->Load('Microsoft Excel'); my $excel =...
I have wxPython app which is running on MS Windows and I'd like it to support drag&drop between its instances (so the user opens my app 3 times and drags data from one instance to another). The simple drag&drop in wxPython works that way: User initiates drag: The source window packs necessary data in wx.DataObject(), creates new wx.Dr...
I have an Excel file in OfficeML format, MyData.xls. Since I upgraded to Office 2007 from Office 2003 I get a warning message saying that the file content does not match the file extension. It seems that OfficeML now must have the extension 'xml'. In my application I use OleClientSite to display the file in an OleFrame object. If I chan...
I'm trying to access an OleVariant in a callback that is coming from an ActiveX library. Here's what the event handler is defined as in the TLB: procedure(ASender: TObject; var structQSnap: {??structVTIQSnap}OleVariant) of object; Here's the definition of structVTIQSnap in the TLB: structVTIQSnap = packed record bstrSymbol: WideSt...
I wrote an OLE automation server (using Delphi). I usually start the OLE server manually and use it as a normal application. From time to time I start a client, which automatically connect to the existing OLE Server. When I terminate the client, the server does not terminate (at least when it was started manually before the client) but...
Are there any inherent problems with calling an ole object from tsql? I have been posed with a problem that I would like to solve solely using a stored procedure, is there anything I need to worry about with using a ole object as opposed to writing it in a clr based language? ...
As a newbie to FoxPro (but an old-hand at Clipper), I'm a bit at a loss to figure out how to return an array from the following OLEPUBLIC class. edit: I've modified the code belw to take into consideration the remarks made by @Stuart below. DEFINE CLASS db AS CUSTOM OLEPUBLIC DIMENSION ada(1) && public scope for later return FUNCTI...
I am trying to communicate with Excel from a Java/SWT application. I have been able to open a worksheet, open a file and save it but that's about it. Can anyone point me to some documentation/examples for this? I especially need to know which commands are available. I did try to record macros to inspect. This was useful but did not give...
What is the difference between COM and OLE, if any ? ...
How can I attach and automate a specific instance of the VisualStudio.DTE from Ruby? It works fine when only one instance is running, but when multiple instances are running, WIN32OLE.connect("VisualStudio.DTE.9.0") only connects to the first one launched. A non-Ruby specific approach would also be appreciated. According to this KB art...
I suspect that I will shortly have a need to write an "integration" library that will need to call an OLE object on Windows from Java. I have done Java to C/C++ integration on windows before (using C/C++ and JNI) - so I'm not new to that part of the equation. However; I'd like to try out writing a C/C++ wrapper around an OLE object to ...
Visual studio type library I'm trying from Delphi to open up Visual Studio (for editing SSRS reports), and load up a particular projectitem from a solution file I have autogenerated. I have imported the visual studio type library, and can create the object, and drill through the solution until I have the right ProjectItem objDTE := Cr...
I am writing an background service application that has to automatically read data from Excel 2003 files. But no matter what I try, the method OlePropertyGet() always results in an EAccessViolation error while trying to read from address "00000800". The error always occurs at the last line of this code snippet, and seems independent of ...
When an IE user clicks the link of a file residing in SharePoint (and user selects "read-only" access), the file is copied to Temporary Internet Files, my application is opened and passed that filename as a parameter. I'm trying to implement a "check out" button in my app so that a user can switch from read-only mode to check-out and ed...
I have a (set of) Word document(s) for which I'm trying to get various properties (number of pages, author, etc) using Win32::OLE in Perl: print $MSWord->Documents->Open($name)-> BuiltInDocumentProperties->{"Number of pages"}->value . " \n"; This returns 4 pages. But the actual number of pages in the document is 9. The number of pages...
I can't wrap my head around the differences among these terms. Are COM and ActiveX synonyms? Is ActiveX object just a COM object that exposes IDispatch? Lots of older MSDN pages mention IDispatch without any COM context. Does it have a separate history, and was just introduced under the COM 'umbrella' later in its lifecycle? Wher...
Hi Guys, I have problem creating new instance of excel 2007 using VBA (from Access 2002). At first I misunderstood the problem and it is more complicated than I thought. Set myXL = CreateObject("Excel.Application") Creates new processes (I thought it didn't), but still strange thing is happening. I use OLE to store Excel files in SQ...
An OLE Object column contains images but the image type (jpg/gif/tiff) is unknown. These images need to be extracted from the DB and saved to disk. The application is primarily using VB.NET but C# examples are welcome too. thanks Rahul ...
For the past year, I noticed that whenever I added an OLE Bound frame to an Access form, as an interface to save documents such as Word or PDF, the drag and drop feature would become unavailable. I think this has to do with having the OLE Bound frame on a subform within a main form; however, I have been able to use the drag and drop fea...
I'm trying to export WideString texts from the database (ADO / MS Access) to the MS Word document (Delphi 7), but foreign characters are not correctly transferred (i.e. "è" instead of "č"): while not ADOQuery1.Eof do begin WordApplication1.Selection.TypeText(ADOQuery1Text.AsVariant); // TWideStringField WordApplication1.Selection.Ty...