Change Default Movie Player in PowerPoint 2007
Hello, I want to change the default movie player in PowerPoint 2007. Could anybody please suggest me the way around for it. Thanks in advance. ...
office-2007
Excel "Refresh All" with OpenXML
Hello, I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts are using this table. I am trying to find a way with OpenXML SDK v2 to do the same as the "Refresh All" button in Excel. So that I could automatically update my file as soon as a new xml file is ...
Best practices for deploying an Access (2007) application
Hello, What are best practices for deploying an Access application? I use a BE/FE architecture, both parts Access 2007. I don't want the users to change the VBA code or the design of forms or tables. May be adding adhoc queries. Should a make a ACCDE file? Thanks in advance for your suggestions. ...
How do I 'wait' for a certain dialogue in a Word document macro?
I’ve got a macro that does a search/replace in a selection but at the end of the task it shows the 'Do you want to search the remainder of the document' dialogue and I never want it to search the remainder so I’d like to have it click ‘n’ and then continue with the rest of the doc. In is there a way to do this? ...
Is openXml2.0 chart generation compatible with office 2007?
I have not done any OpenXml, but the download page for OpenXml is clear that 1.0 is compatible with office 2007. The download page for OpenXml 2.0 does not specify any outlook versions at all. If we only have office 2007 or need to be office 2007 viewable/compatible and I'm looking at generating charts in outlook from c# code, can I pro...
Make the file author property readonly - MS-Word 2007
Hi All, I just want to know is there a way of locking a MS-Word files author, while keeping the document editable. in MS-Word 2007 currently you crate a document save the document right click on the document and go to properties go to summary tab it shows the 'author' of the file and it can be editable. what I want to do is, lock ...
using excel function on group of numbers with steady jumps
Hello, i have a column A with about 10,000 random numbers. I want to perform a function ( =MAX() for instance) on group of 100 numbers every time, i.e. i want to do =MAX(A1:A101) then =MAX(A102:A202) =MAX(A203:A303) etc... notice there's no overlapping in the groups. normal Dragging doesn't work, it will perform jumps of 1 for...
Generate list of words based on microsoft word dictionary - Stops working at some point - why?
I wrote a small app that Generates words and then verifies them against Microsoft Word 2007 dictionary. This works great for me when I test it against the english dictionary with 3 letters length(and I guess with more letters) but for some reason it stops working when I try to run it against the hebrew dictionary. Does any one know why...
Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel
I found a way to hide Excel sheets which is as follows: set the visibility of the sheet to VeryHidden in the VBAProject properties and then password protect VBAProject properties. This is great, but in Excel 2007, if you save it as XLSX, the VBAProject password protection is stripped and you can view the VBA code. Is there any way to pr...
Strange automation? error in Word2007
Hello all! I'm pulling my hair out because I've run into the following problem with one of my clients: My program uses extensive VBA automation in Word. Macros are saved in a specific Word template that is attached to each document. Some of the macros save the current document to a temporary folder under [User]/AppData/Roaming/... for ...