office-2007

VBA Outlook Mail .display, recording when/if sent manually

My code displays a message with basic subject, body, attachment. Next the user manually updates and customizes the message and should send it. I want to record when (if) the email is sent. Is this possible or any tips? My environment is Office 2007 with an excel based macro going to Outlook. [Excerpt] Dim OutApp As Outlook.Applicat...

Visual Studio 2010 RC with Office 2010 and Office 2007 installed

I have Visual Studio 2010 installed on my Windows XP development machine along with Office 2007 Professional and Office 2010 Professional. I am trying to develop several add-ins for Office 2007; however, I prefer to use Office 2010 on a day-to-day basis. How do I set Visual Studio 2010 to install the add-in and open Word 2007 when I pr...

Why doesn’t Office-applications get focus when run from another application on Win 2008?

I have some different COM-Interop examples that when run on Windows 2008 (Office 2007) always open minimized in the task bar. On Windows 2003 or XP they open like I want them to. Has there been any changes to how Windows deals with this? Or to Office? I know that I can close windows with CTRL-SHIFT-ALT, and by that get them to start m...

Is it possible to add custom "napkin math" operators in OneNote 2007?

If you're not familiar with OneNote's "napkin math" feature, it allows you to type mathematical equations and have OneNote evaluate them on the fly (with a limited set of operators/functions). I'm wondering if it's possible to create my own, either through an obscure UI in OneNote, or through some sort of custom plugin that I would devel...

Proper Install Order For Visual Studio 2010 with SQL Server 2008 and Office 2007?

I want to create a Windows 7 64-bit (Ultimate) virtual machine with: Visual Studio 2010 (Ultimate) Office 2007 Enterprise (with Visio 2007) SQL Server 2008 (with SSIS and SSRS) but I am not sure if there is a correct order to install those items such that there will not be a loss of "awareness" of one application from another on tha...

Office Add-in to execute on save

I'm developing an Office 2007 add-in. I would like to have a piece of code execute whenever the user Saves a document. I'm principally interested in Word, Excel and PowerPoint, but I'd prefer to also support other Office apps (such as Visio and Microsoft Project). Looking for either a code sample, or a link to an article that describe...

Problem with VBA app after office 2007 was installed

Ever since we installed Office 2007, our VBA apps code stopped working. When I debug, I get a compile error and .edit is highlighted. I replaced the .edit with .update and i don't get any debug errors, but when i run the code i get a type mismatch error code. Is the something im doing wrong? Here is the codez: Private Sub Command290...

SharePoint and Forms Based Authentication Issue - Office Apps no longer work

We have several sites that use Forms Based authentication (FBA) within SharePoint. Many of them have been running for months without issues. Within the last week or two we have noticed the following behavior for users trying to access a Read Only Microsoft office document (currently only verified with the 2007 versions of Excel and Word)...

Lookup site column not saving/storing metadata for Office 2007 documents?

I'm having this issue on several server environments. We have a list at the site collection root. There is a site column created as a multi-value lookup on that list's Title field. This site column is used in document libraries in subsites as a required field. When we upload anything but an Office 2007 document, the user is presented...

make field a dropdown in access 2007

I'm creating a HR database in access 2007 I have a main table of employee info and several tables that relate to that table ( education for example) that list the acceptable elements that can populate that cell in that row When i create a form it was created as just a plain text field which is constrained but I wanted to create a dropd...

Error when retrieving office 2007 files from sql server 2005 blob

Hey all, I have a simple document storage database that allows people to upload various types of documents and then do a full-text search on them. It works just fine for all documents except office 2007 documents. My retrevial code uses content type "application/octet-stream", the server has the MIMETypes registered as does my computer...

How can I find "People's Contacts" folders via Outlook's object model?

I have some code that locates all the contact folders that a user has access to by iterating through the Application.Session.Stores collection. This works for the user's contacts and also all the public contacts folders. It also finds all the contacts folders in additional mailbox accounts that the user has added via the Tools -> Accoun...

Best way to read an Excel file into an Access 2007 database

What's the "best" way to read (just read) an Excel file from within an Access 2007 application. I only want to loop trough the rows and put the data into an Access table. I don't want a import by hand (Get External Data dialog) but by VBA. The user gets a Form with a Browse button and then points to a Excel file with a defined content/f...

Word 2007 customisation - template based addins vs. custom dlls written in Visual Studio?

I'm planning an upgrade to Word (Office) 2007 and need to decide now which customisation route to take. The current set-up is Office 2000 with templates acting as addins, loading with Word (from the startup folder) to support a lot of functionality - interface with DMS, interface with CRM, user form behaviour and printing to name but a ...

MS Word opens documents hosted on WebDav share read-only on Windows Vista and 7 but only if no other webdav connections are open

We have a WebDav server with some Word documents on it. (We are using PHP's HTTP_WebDAV_Server but get the same issue on tests with Apache mod_dav - both use digest authentication, basic auth doesn't work on Vista or later) We have a web page that opens the word documents using javascript like: Doc = new ActiveXObject("Sharepoint.OpenD...

How can I create a SQL table using excel columns?

I need to help to generate column name from excel automatically. I think that: we can do below codes: CREATE TABLE [dbo].[Addresses_Temp] ( [FirstName] VARCHAR(20), [LastName] VARCHAR(20), [Address] VARCHAR(50), [City] VARCHAR(30), [State] VARCHAR(2), [ZIP] VARCHAR(10) ) v...

How to check if .NET programmability support is installed for Word 2007?

Does anyone know how to check if the Office Interops were installed? I know it is an advanced option when installing Office 2007. Is there a way to install the support after Office is already installed? ...

Is there a simple way to pull in the outlook message folder information in vs2010/.net 4.0 office 2007?

I'm building an outlook add-in to get around whatever the reasoning is you can't create a rule to sort mail based on a Distribution Group (error message about it being a personal distribution group). I've gotten really far and I think all the core functionality works, but I can't seem to figure out how to allow the user to drag/drop the...

Any idea about DependentPlatformMissingException Microsoft.Vbe.Interop.Forms Version 11.0.0.0

Hi I am running into a strange issue. I am developing a Outlook 2007 addin using Visual Studio 2010 with VSTO 3.0 and deployed using ClickOnce. I would like to check if there are any updates and if so prompt the user to restart outlook. However if I call ApplicationDeployment.CheckForDetailedUpdate or ApplicationDeployment.CheckForUp...

Word documents generation with c#

Possible Duplicates: How can a Word document be created in C#? Convert Word doc file to docx on a server without Word Hi everyone ! Using your experiences, i wanna found the better sdk/library to create Word doc/docx, with or without .doc template, but without interop ! Thanks ! kiRbytte ...