an saurus

ribbon

What's a good online reference for manipulating Office documents via ActiveX?

I am looking for a reference that covers using ActiveX to open and manipulate Excel (and possibly Word) documents. I'd prefer an online reference but book suggestions are helpful too. ...

reference

activex

Access date bug- dd/mm automatically got changed to mm/dd

I coded something using Date statement in ms-access vba. It was working fine till the start of this month. But now I am seeing a very peculiar bug in access vba that the Date has automatically changed the format from dd/mm/yyyy to mm/dd/yyyy. Has anyone else encountered the same problem ...

If DoCmd.SendObject fails?

I am using DoCmd.SendObject to send emails from MS access 2003. It opens the outlook with all relevant fields filled. But the user may not choose to send the email at that time. In that case, a prompt 'Send Action was cancelled' appears. Is there a way to catch this non-sending of email by user ...

MS Office hyperlinks change code page ?!?

When you paste the following URL into IE: http://technet.microsoft.com/en-us/sysinternals/bb897434.aspx, the link on the right of the page cleanly says "Download Zoomit (77 KB)". If you paste the link into an Office document (Word, Excel, PowerPoint -- tested using Office 2003), and activate the link from the document, that same text ha...

How do I get the stream of header/footer in a WordprocessingDocument

Hi, I need to know how I get the stream of the headers and footers of a WordprocessingDocument. I get the MainDocument by the MainDocumentPart of a WordprocessingDocument. Do you know how I get the header? I tried to use the method GetPartsOfType but it returned null. Greets Sebastian ...

Embedding my .NET control in MS Project 2003

I need to extend MS Project's functionality for my company, so I would like to embed some .NET GUI controls into Project. The plan is that my controls save the user input into my custom DB tables, but I do have to bind them to tasks, current user, resources etc. Could you give me some advise how to start? I am interested in: Sample app...

Updating Access 2003 to 2007, potential issues?

Hi all, I've written an Access 2003 application to handle internal things at my company over the past couple years and we are talking about upgrading all of our computers to Office 2007 which means Access will be updated. Is this going to cause a problem for me? ...

ms-access-2007

How to refresh an access form

I am building an MS Access application in which all the forms are modal. However, after data change in a form, I want to refresh the parent form of this form with newer data. Is there any way to do it. To elaborate further : Consider there are two forms, Form A and Form B. Both are modal form. From Form A, I initiate Form B, and now For...

PowerPoint - How can I figure out if a presentation has a password progamatically?

I'm writing an application that processes PowerPoint presentations and I'm looking into ways of detecting whether or not a PowerPoint presentation has a password if it does then stop processing it. Any thoughts? ...

powerpoint

How can I access the progress bar in an Office application's status bar.

I build VBA applications for both Word and Excel, is there any way to access the progress bar that sometimes appears in the Office status bar. ...

United States State shapes for Office

I want to create visuals along the lines of CNN's "red-state, blue-state" shadings of the states in the U.S. for my project. I'm planning to do something fancier than just shading the state's shape in a color. Are there open source libraries of state shapes/polygons (or - if not open source - others) that I can import into Word, Excel, e...

graph

data-visualization

How to eliminate the security warning at the startup of a ms-access project

While opening any MS Access database, a security warning appears saying that the file can be harmful to the computer. However, is there a way to remove this message. Or should it remain a necessary evil ...

Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess

I have a table, call it TBL. It has two columns,call them A and B. Now in the query I require one column as A and other column should be a comma seprated list of all B's which are against A in TBL. e.g. TBL is like this 1 Alpha 2 Beta 1 Gamma 1 Delta Result of query should be 1 Alpha,Gamma,Delta 2 Beta This type of ...

Where does Outlook store the VBA code files?

I had a VBA project in outlook with a few email macros - but after a PC crash they are all gone and all I see is a fresh 'Project1' when I hit Alt+F11 I'm not a VBA programmer, but had a collection of handy macros for email sorting etc. I would not like to have to code them again. Anyone know where the code files should be on the filesy...

outlook

Considerations when developing an integrated product for Microsoft Office suite

I have a product idea that requires integration into the Microsoft Office suite. Are there any licensing/limitation issues to be aware of for me to proceed? ...

development

integration

Vector graphics clipboard format for Qt.

I want my Qt application to be able to save simple vector graphics to clipboard in a compatible way. On windows I want to be able to paste the graphics into Microsoft Word or Powerpoint. On Linux I want to be compatible with the Open Office. Which format would you recommend? Can Qt generate EMF in an easy way? Is SVG an option? Update...

How do I programatically interface an Excel spreadsheet?

I have a request for some contract work from an organization that uses Excel as a database and wants to do some work on the Excel data via a real database. (Yeah, I know, never mind...) The client has an Excel sheet that they use internally to keep track of some government programmes. The data from this Excel sheet used to be manually i...

excel

interface