Just in case I ever need it for historic reasons:
[Wayback/Archive] WinWorld: Microsoft Office 95
Because back in the days various Office products had localised VBA (at least German and French products had; I’m not sure about other languages)
Via:
Archive for the ‘Office Automation’ Category
WinWorld: Microsoft Office 95
Posted by jpluimers on 2025/10/29
Posted in Delphi, Development, History, LifeHacker, Office, Office 95, Office Automation, Office Development, Power User, Software Development, Windows, Windows 95 | Leave a Comment »
Infusion pump and PCA (patient-controlled analgesia) calculation
Posted by jpluimers on 2021/11/09
This is a great PCA calculator: [Archive.is] CADD calculator 0.5BETA END USER Google Docs – Google Sheets
Via:
- [WayBack] Verpleegkundige wiskunde met de PCA pomp. Of: hoe Bram’s PCA-calculator het licht zag. – Ars GeriatriCare
- [Archive.is] VerpleegMan on Twitter: “Voor de geïnteresseerden: dit is het knutselwerkje. Een spreadsheetje om zorgverleners rekenwerk uit handen te nemen en hopelijk tijd, morfine en nachtrust te besparen :) “
- [Archive.is] VerpleegMan on Twitter: “Kreeg vandaag een berichtje waaruit blijkt dat iets dat ik 10 jaar geleden tijdens een hbo-v stage in elkaar heb geknutseld nog steeds mensen helpt in hun werk. En dat ze het actief delen onder collega’s (in een organisatie waar ik nooit heb gewerkt) #beroepseer #verpleegkunde”
Related:
- WayBack: PCA: zelfcontrole over pijn na uw operatie
- Patient-controlled analgesia – Wikipedia
- Infusion pump – Wikipedia
- [Archive.is] Jeroen Pluimers on Twitter: “Het leest wel gek als je ooit als kind de betekenis bolus=drol geleerd hebt (:… “
–jeroen
Share this:
Posted in Development, Excel, Google, GoogleDocs, GoogleSheets, Office, Office Automation, Office VBA, Power User, Scripting, Software Development | Leave a Comment »
Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community
Posted by jpluimers on 2021/11/02
As it combines VBA and AppleScript, I might need the script from this in the future [WayBack] Word for Mac 2011: create macro or shortcut to ‘Insert Picture – Microsoft Community.
–jeroen
Share this:
Posted in Development, Office, Office 2011 for Mac, Office Automation, Office VBA, Scripting, Software Development | Leave a Comment »
Links to debugging COM stuff for Office Automation in Delphi
Posted by jpluimers on 2019/11/12
From a long time ago, but recently I needed them again.
Note the .NET side is much much harder Revisited from the .NET side: Why doesn’t WINWORD.EXE quit after Closing the document from Delphi? (via: Stack Overflow).
[WayBack] Why doesn’t WINWORD.EXE quit after Closing the document from Delphi? – Stack Overflow
Share this:
Posted in Delphi, Development, Office Automation, Software Development | 2 Comments »
Some notes on Word automation and showing Bookmarks
Posted by jpluimers on 2014/08/27
Though I’ve done this automation in Delphi, this applies to automation from any development platform. In this particular project, the documents used Bookmarks. Those have changed over time, so has the Word support for it.
From Word 2000 until Word you could disable the showing of Bookmarks by setting the ShowBookmarks property to False like this:
<br />ActiveDocument.ActiveWindow.View.ShowBookmarks := False;<br />
Well, when doing this, Office 2013 can throw an error like this:
EOleException: The ShowBookmarks method or property is not available because this command is not available for reading
ErrorCode: 0x800A11FD
Source: Microsoft Word
HelpFile: wdmain11.chm
The full error message does not give any useful search results. But a partial search finds a Word 2013 issue towards the top of the results:
sometimes Words opens the document in Reading layout. Reading layout does not allow all operations in Word 2013.
If a document is protected, and you try to change something you should not, you get an error message like this:
This method or property is not available because the document is a protected document.
Usually, Cindy Meister is very accurate. However this time here code
...ActiveWindow.View = wdPrintView
should have been like
...ActiveWindow.View.Type = wdPrintView
Of course you also have to save/restore this property while you are enabling the ShowBookmarks property.
Share this:
Posted in Delphi, Delphi XE2, Delphi XE3, Delphi XE4, Development, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office Automation, Power User, Software Development, Word | Leave a Comment »
Some notes on Word automation and protected documents
Posted by jpluimers on 2014/08/26
Though I’ve done this automation in Delphi, this applies to automation from any development platform. In this particular project, I had to update Word documents. That is fine, unless your documents are protected. You can find out if a document is protected by probing the ProtectionType property of a Document object.
If a document is protected, and you try to change something you should not, you get an error message like this:
This method or property is not available because the document is a protected document.
If you have control of the documents or templates involved, then you can take the recommended steps from Document Handling with protected Microsoft Office Word Template:
Microsoft Office Word offers the possibility to enable document protection only to certain sections of a document. So you can place Bookmarks used by Dynamics AX in a section that is kept unprotected and the Form Controls in a section where Document Protection is enabled.
If you don’t, then you have to check for protection, unprotect, do the modifications, then re-protect the document. Read the rest of this entry »
Share this:
Posted in Delphi, Delphi XE2, Delphi XE3, Delphi XE4, Development, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2013, Office Automation, Power User, Software Development, Word | Leave a Comment »
Word API Documents collection documentation: moved and changes with the introduction of Word 2013
Posted by jpluimers on 2014/08/05
I’ve done a bit of WinWord automation and came across different locations for the API:
New Style:
- Word 2013: Documents Object (Word) – http://msdn.microsoft.com/en-us/library/office/ff840891(v=office.15).aspx
- Word 2010: Documents Collection Object (Word) – http://msdn.microsoft.com/en-us/library/office/ff840891(v=office.14).aspx
Old Style:
- Word 2010: Documents Interface (Microsoft.Office.Interop.Word) – http://msdn.microsoft.com/en-us/library/ms263641(v=office.14)
- Word 2003: Documents Interface (Microsoft.Office.Interop.Word) – http://msdn.microsoft.com/en-us/library/ms263641(v=office.11)
Fun fact: there is no Old Style Word 2007 documentation any more. You might expect it at http://msdn.microsoft.com/en-us/library/ms263641(v=office.12) but it is not there.
Not so fun fact (and the reason I was looking for the Documents documentation), is because of this big bug ONLY in Office 2010 (it does not occur in Office 2000 .. 2007, and is fixed in 2013): The WordMeister » Bug Word 2010: Documents collection is not correctly maintained.
The only workaround is to run an Office Add-in, or VBA Macro. Both not feasible for external clients.
–jeroen
Share this:
Posted in Delphi, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Development, Office, Office 2007, Office 2010, Office 2013, Office Automation, Office VBA, Power User, Scripting, Software Development, VBScript | Leave a Comment »
The Wiert Corner - irregular stream of stuff 