Wednesday, May 28th, 2008 171 views
In keeping with my Website XML parsing post, here is a short function that returns the body text from a webpage as a string, on which you can use other functions like Instr, Left$, Mid$, etc, to extract necessary data.
[vba]
Function URLText(sURL As String) As String
' check website.com using xml
' early ...
Posted in Excel, Internet Explorer, VBA, automation | 1 Comment »
Friday, May 23rd, 2008 175 views
Here's a sub and a function for Outlook that let's you save attachments from a selected or open email. It's similar to the File>Save Attachments menu option, which lets you save all of the attachments from a particular email, or the FindControl Method, which can be used to find and ...
Posted in Outlook, VBA, automation | No Comments »
Thursday, May 22nd, 2008 148 views
I recently discovered a new object library that seems pretty useful - the Microsoft Office Document Imaging Type Library. From the MSDN site:
The Microsoft® Office Document Imaging 2003 (MODI) object model makes it possible to develop custom applications for managing document images (such as scanned and faxed documents) and the ...
Posted in Outlook, VBA, automation | No Comments »
Tuesday, May 13th, 2008 192 views
Here is the finished code for the Outlook File Request System.File Server CodeThis is event code which acts as an automated file server, putting files into the specified folder, and sending files back to the requestor, all via email. Once the code is installed, another user requests a file from ...
Posted in Outlook, VBA, automation | No Comments »
Thursday, May 8th, 2008 54 views
I'm sure by now you are aware that Microsoft has been distancing itself from VBA.
As of July 1, 2007, they are no longer licensing VBA (to new clients). For example, if you wrote a program today and wanted to integrate VBA in it, you are out of luck.
And the new ...
Posted in Rant, VBA | 2 Comments »
