In Word 2003, if you need to know if a document contains any VBA code/macros in it, you can use the following function. Function ContainsCode(ByVal Doc As Document) As Boolean ContainsCode = False Dim comp As Object For Each comp In Doc.VBProject.VBComponents If comp.CodeModule.CountOfLines > 0 Then ContainsCode = True Exit Function […]
I spend lots of time developing for different clients, and the problem is most clients have their own drive mappings pointing to specific network locations. In a lot of cases, I need to replicate these drive mappings as it’s usually where they store their Workgroup templates for Word, Excel and PowerPoint. So instead of setting […]
Do you have lots of custom toolbars in Word 2003 and can’t work out where they are coming from? I’ve had this problem so many times, especially when preparing lots of templates to move to 2010. Well, turns out it’s really simple – just run the following command in the immediate window in the VBA […]
One of my fave features in Word 2010 is the new custom undo records. It allows you to group your changes via code into blocks that can be undone in a single go – plus you can name the records. Take the following sub: Sub InsertSomeText() Selection.TypeText “This is a test” Selection.TypeParagraph Selection.TypeText “This is […]
Have you ever tried to get the edit time from the IManDocument or NRTDocument objects within Autonomy WorkSite? There’s the AccessTime property which returns the date plus time, but the EditDate property is just the date, and the time part is missing (set to 12:00am). So how do you get the date and time? Turns […]
Usually the cause of documents being slow to open in Word is when the attached template is missing – especially when the template is located on a network. Turns out with Word 2010 there can be another reason. We had a client where some documents were taking between 25 and 30 seconds to open, but […]
I’m spending a lot of time in issues lists at the moment, and so many issues are very poorly logged, with no details or steps on how to replicate the problem. Well that’s where the Problem Steps Recorder in Windows 7 comes in very handy. Get the users to type in PSR into the search […]
Occasionally we come across issues when moving databases from one SQL server to another. One of the most tricky situations is when you cannot get access to the applications configuration settings for the database you are required to move. This can be for various reasons, like forgotten passwords, poor application design or where the configuration […]
I experienced an interesting (or should that be frustrating) problem recently during an Office 2010 migration. We have some code in Word that saves the current document into Autonomy WorkSite. The code works by doing a Save As of the current document to a temporary file, and then saving the document again to free up […]
Autonomy recently released WorkSite 8.5 SP3 Update 1, which includes updated integration for Office 2007 and 2010. The integration, so far, is much better than the old version. The only problem is that it kills all your code that used the old iManOXP.dll (iManO2K.iManageExtensibility) but don’t worry, it’s easy to update your code to get […]
At MOSMAR we love coming up with amazing solutions for our clients, and that’s what we’ve been doing for more than 10 years.
Contact Us
Suite 224, 1 Katherine Street
Chatswood NSW 2067
+61 2 8097 9888