I'm using JACOB to do COM calls to PowerPoint and other Office applications from Java. On a particular Windows 7 box I'm getting the following message quite often, but not always: Source: Microsoft Office PowerPoint 2007 Description: PowerPoint could not open the file. From excel I get: ERROR - Invoke of: Open Source: Microsoft Offic...
Does anyone know of MS Office (Word, Excel or PowerPoint) templates for create a SCORM quiz? Paid or free, but must be customizable in VSTO or VBA. Thx! ...
how to open a password protected Microsoft word(.doc, .docx) file in java assuming that the password is known? ...
I am pushing XML data into an Excel Table via C#, but when I do this, my ActiveX checkboxes lower on the page do not adjust their position. The spreadsheet rows move down, but the checkboxes do not. Also, at times it seems like even though the cells on the spreadsheet shift down, the row heights do not, messing up the formatting. I t...
I have a large amount of Word documents that I need to parse. As they all were created from the same template, I think that the best approach would be to save them as HTML files and parse the HTML itself. While it's quite easy to save a single Word document as HTML, I haven't found a way to do a bulk procedure from inside Word. Thus, I'...
I am trying to automate a mailmerge to print mailing labels with C#. I've created a Word template containing the label layout, but when I try to use interop to set the DataSource I am having issues. There are 2 ways I can go about this, either through accessing a SQL table or importing from an Excel spreadsheet. I've had mixed luck in...
I would like to be able to create a custom UI in Word 2007/2010 to call quick parts/auto-texts from the custom ribbon. I can call macros and other coded things fine, but is there a way to integrate quickparts in a custom ribbon? ...
Hi, I have made a program where I read set of records from the database and then save it in a datagrid. From here I make the user download the file as a excel file. Now the user make changes to the file and then upload it again and from here I read the uploaded .xls file and make the necessary changes in the DB. The problem is wheneve...
Hi all, I'm programming a Microsoft Word plugin in VB.Net, and I have a code that calls a function to save the document as PDF (Office 2007). I use two functions: Public Sub SaveLandscape_CallBack(ByVal Control As Office.IRibbonControl) SaveEbook(True) End Sub And Public Sub SaveEbook(ByVal ForceLandscape As Boolean) Try ...
I know nothing about microsoft office development, but I would like to build a prototype of a plugin will allow a user to Save and Open documents from a remote repository. Perhaps later build in a version control system on the server - but the server side piece is about the easiest portion of it (in my case). Perhaps I should focus on g...
Is it possible to detect the version of a powerpoint(PowerPointXP etc) file? ...
I am writing an Outlook VBA macro to alphabetically sort recipients when composing an email. It works fine for sorting, however if I have 3 recipients (for example), run the sort macro, and then remove a recipient, running the macro a second time causes the removed recipient to re-appear. When I step through the macro on the second run,...
Hi, I hope someone have some insight into this. I have a check box on page 1 and when it's clicked, it will launch a macro & insert a value to a text box on page 10. Simple The problem is, the script in the macro is looking for the value of another text box on page 5 to do some calculation. Whenever i do text5value = Val(oFFld("Text5...
I have a VS 2010 Excel 2007 Workbook application. I have a ListObject that is bound to an object data source via a binding source. I want to be able to determine what property of my object any given ListColumn obect in my ListObject's ListColumns collection is bound to. In the example below I use the column name to find the column that i...
How can I programatically retrieve the number of pages a workbook or worksheet will print to from the Excel 2007 Interop (Microsoft.Office.Interop.Excel)? ...
Hi all I am working on word automation. i am having a problem. I want to insert caption at the first row of the table . my table contain 3 rows as header,chart,note, upto this is all well . when i type some text in the header it works fine. but when i am adding a caption at the first row this add caption above the table or below the tab...
Hi, I would like to know whether its possible to open Open word 2003 (doc) file using open xml file format API? like office 2007. I have one windows service through which I am trying to open and edit doc files but getting lot of problems.I have posted question regarding that problem here but got no answer. After lot of googling, I c...
Hi there, i am creating a word (14) instance with interop out of a c# .net4 winforms application to work with a document. If some word document gets opened beyond my application the same word instance will be used an disturbs my application. Simple question: Is there any way to set my word instance exclusive for my application? Thank...
When learning the C# language. With all the applications being developed these days. Would I be better off focusing on windows forms development or WPF development. I want to develope software that uses ADO.net for SQL Server database access. Also stand alone applications to integrate with Microsoft Office to create charts and graphs etc...
I want to create some custom shapes for MS Office which we can use in house. For example I want to create a shape named “carton box” which have three – four default places where user can add some text. It is same as other shapes or I would say just like shapes (line, flowchart, arrow etc) in MS office 2007. Is there any way to create a...