0
голосов
5ответов
1107 просмотров

How to export 20 000 contacts from MySQL database via PHP for import into an desktop address book?

I need to write a script to export contact data for printing on stickers for mailing. There could be up to 20 000 records in the database table. The main problem is that the number of records could be so high and the site is hosted on a shared server and exporting the whole 20k records would, pr...

10
голосов
4ответов
15641 просмотров

Programmatically configuring MS-Word's Trust Center settings using C#

I have developed a simple C# Winforms application that loads MS-Word 2007 documents via COM automation. This is all very simple and straight forward, however depending on the document I need to programamtically Enable or Disable Macros as well as ActiveX controls. There is probably a way to st...

3
голосов
2ответов
2197 просмотров

VSTO Programmatically adding a new worksheet based on an existing one

I currently have a C# Workbook-level Office 2007 Addin that has a Worksheet added at design-time where I have added methods and properties to the Worksheet derived class. I want to be able to programatically make a new worksheet that clones, inherits or otherwise possesses the methods and event ...

3
голосов
4ответов
6336 просмотров

How do I know when a file has been modified in a VBA Macro?

Is there a way to watch a file in VBA (which is essentially VB6), so that I know when the file has been modified? -- similar to this only I don't want to know when a file is unused, just when its modified. The answers I've found have recommended using "FileSystemWatcher" and the Win32 API "FindF...

0
голосов
2ответов
1816 просмотров

MS Excel XML format accessing with Ole connection

How can I access a XML Excel format file with an OLE Connection? Can it be done? I have accessed the normal Excel Format 2003 xlsx file but when I generate the Excel XML format I can't access with OLE. Thanks in advance for any help. I can open the file manually in Excel but I'm unable to con...

0
голосов
2ответов
223 просмотров

Why is my MS Access database always broken?

I wrote a program running as a service that need to frequently gain access to MS Access database. After a period of time, my program exits automatically, then I open my MS Access database with Office, it says it is broken! It seems very strange as my program do just some very common database acc...

0
голосов
2ответов
5522 просмотров

C# / Windows Forms - Display a PowerPoint slide-show without Office installed?

I know I can display a Powerpoint presentation within my own form (see here), but I'm wondering whether there is a way to get rid of Microsoft Office as a requirement? I guess basically what I'm asking for is a library which will display Powerpoint slide-shows without my users having to install ...

7
голосов
2ответов
3231 просмотров

What is the difference between Office Automation, VSTO, and Open XML SDK?

What is the difference between Office Automation, VSTO, and Open XML SDK? Do we need all of them or some of them are obsolete?

4
голосов
2ответов
2218 просмотров

How to detect Theme fonts in Powerpoint 2007 VBA?

Does anyone know how to detect the use of Theme fonts in Powerpoint 2007 slide objects using VBA? If one looks at Shape.TextFrame.TextRange.Font.Name the font name appears as simple name (ex: "Arial") whether or not the font was assigned as a fixed name or a Theme name (subject to change with t...

2
голосов
1ответов
3159 просмотров

Writing data to cells in Excel 2007 / PowerShell

Why can I not write values to Excel using the Worksheet class, or Sheet interface? I would expect to be able to do something like this: [Reflection.Assembly]::LoadWithPartialName("Microsoft.Office.Interop.Excel") $Excel = New-Object Microsoft.Office.Interop.Excel.ApplicationClass $Workbook = $Ex...

0
голосов
1ответов
228 просмотров

PivotTable Drillthrough not supported

We migrated our old ASP app to ASP.NET and can't seem to figure out the cause of this error. Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2; .NET ...

1
голосов
1ответов
1385 просмотров

Embedded objects in MS Office documents using Python?

How could I create embedded objects in an MS office document using Python? I don't need anything fancy, just what one used to do in the first version of OLE: doing a copy-paste from my application into e.g. MS Word should give me an object embedded in the Word document, which I can then doubl...

2
голосов
1ответов
1067 просмотров

How can I print Office documents from .NET in a uniform manner?

Using Microsoft interOp objects, I can programmatically print a Word or Excel document. Is there any simpler and uniform way to programmatically print all types of documents (.txt, .doc, .xls, .pdf etc.)?

1
голосов
2ответов
364 просмотров

Need JET 4.0 Drivers

I am using an ExcelProvider with Microsoft.Jet.OLEDB.4.0 and am getting the Cannot Find Installable ISAM from the production machine. Windows Server 2003. I've searched and search for this download. I've Office installed on the Dev machine, so I'm sure that's why it works fine on my end. But ...

33
голосов
10ответов
28254 просмотров

Installing Office Customization

Name: From: file:///D:/Samples/TestUpdatedVersion/bin/Debug/TestUpdatedVersion.vsto The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the customization, first use Add or Remove Programs to u...

2
голосов
2ответов
1361 просмотров

Developing Word add-ins for Macintosh

I have an add-in for Word 2007 developed using VS2008/.NET 3.5. What do I need to do in order for Mac users to use this add-in with their Word 2008? (or did MS make sure it would be impossible to do...)

1
голосов
1ответов
2587 просмотров

IFilter or SDK for many file types?

Does anybody know of an API/SDK or IFilter in .NET that can read the subject ('title' metadata) and text from the following files: .PDF .DOC .XLS .PPT .CSV .TXT .DOCX .XLS .PPTX + the OpenOffice and Open Document standards. Open source would be awesome... but commercial is OK too. I can't ...

0
голосов
1ответов
220 просмотров

Setting Word's printer through Office automation

I'm looking to do the same as in this question here, however I am developing in a .NET class library, referencing the Primary Interop Assemblies. The item returned from the dialog box collection when I do this wordApp.Dialogs[WdWordDialog.wdDialogFilePrintSetup] does not expose properties suc...

3
голосов
3ответов
2284 просмотров

ms-access localization and default boolean values

Our access client generates on the fly SQL inserts, update and delete instructions to be sent on a MS-SQL Server. Most users have the runtime version of Access 2007, and a few use the complete MS-Access version, 2003 or 2007. This morning one of our new users abroad, using a french/complete versi...

1
голосов
1ответов
3322 просмотров

What is the correct way to dynamically set environment variables before running Excel?

I have a bunch of Excel addins which are configured by an environment variable. Normally these are set in the registry on a system-wide basis. When I want change the value non-dynamically I go to: my-computer -> properties -> advanced -> environment variables -> System variables I ...

2
голосов
3ответов
5230 просмотров

How can I display an operating-system environment variable from within Excel?

I have an application written in Excel plus a bunch of C++ / Python addins. The location of the various config files used by the addins is determined at startup time by a number of environment variables. I'd like to debug a problem related to these environment variables by the most direct possi...

0
голосов
1ответов
284 просмотров

What do I need to create an "Office" project in Visual Studio 2008?

I have Office 2007 installed(with .NET support checked everywhere) and VS 2008(with all updates). My problem is that there is no Office category when creating a new project. What else do I need to create an "Office" project?

2
голосов
2ответов
1928 просмотров

XPS to Doc(x) Conversion via .Net?

Does anyone know of a (native) .net way to convert xps documents to docx or finally to a normal (non wordml) .doc? As in not using office automation and rather some native (3rd party) .net library that might help me there? Basically the xps> doc transformation will take place on a server with...

2
голосов
3ответов
5659 просмотров

Read/write Excel 2007 password-protected documents

What method does Office 2007 use for encryption (when choosing Encrypt and setting a password from Office menu)? My C# app needs to create and read encrypted Excel 2007 files (.xlsx). It is important that these files remain accessible from Excel, so I must use Microsoft's encryption method, can'...

0
голосов
2ответов
4501 просмотров

Word VBA Section break character in

How can you detect if the selection you have contains or is the section break character? At the moment I select a page , collapse to the end , I want to know if the end of the page contains a section break or not. I was going to use a method where I compare the section number at the end of the ...

2
голосов
3ответов
1039 просмотров

VSTO: can't open another Excel file, while first file is blocked by modal window from Add-in

We can't open another Excel file, while first file is blocked by modal window from our Add-in. Closing the dialog window unfreezes all pending file opens. Excel version is 2007. Is there a programmatic work around, that would allow Microsoft Excel 2007 to open the second file in a separate windo...

5
голосов
10ответов
7467 просмотров

How can I create an Excel compatible Spreadsheets on the server side in C#?

I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have Office ...

4
голосов
1ответов
3077 просмотров

Is there a way to programmatically add a digital signature to a VBA Macro in a word document?

Is there a way to programmatically add a digital signature to a VBA Macro in a word document using C# or VB.Net? There are some similar questions asked already; however, none that I could find answer my question: How to programmatically remove the digital signature from VBA macros in Excel? Dig...

1
голосов
1ответов
222 просмотров

Microsoft Project Application.ProjectAfterClose Event

I'm writing add-ins for Microsoft Project. Some of my toolbar buttons are only valid when a Project file is open, and I want to enable/disable them dynamically. Typically I'd watch for files to be opened or closed, then check the count of the open files. However, MS Project's API only has an A...

2
голосов
6ответов
589 просмотров

Should we rely on Microsoft Office components

What are the advantages and disadvantages of relying on Microsoft Office components, and using Microsoft Office documents in our software?