Microsoft Office Developement

TwitterFacebook
Get flash to fully experience Pearltrees

Access Help and How-to - Microsoft Office UtterAccess

http://www.utteraccess.com/forum/index.php?app=portal UtterAccess Wiki Featured Content, 2012-08-28 UtterAccess would like to present a new announcement series for UA Wiki content. Having watched the Wiki grow over a period of time, we will be periodically announcing some articles and code that we've found to be particularly insightful and helpful to our community.

How to Use VBA Shell

In the blank code window on the right, type sub OpenExcel and press Enter. http://www.your-save-time-and-improve-quality-technologies-online-resource.com/how_to_use_vba_shell.html

unknown issue running a batch file thru Outlook VBA....

http://social.msdn.microsoft.com/Forums/en-US/outlookdev/thread/c9afda97-10f5-4740-9de1-637ec7bbf5af ThE macro BELOW opens the correct email with a zipped attachment, copies the zipped file to a directory and runs the GREENSHT.BAT. It does what it is supposed to do but the strange (unknown) issue is when the BAT file is run using this macro it does not function correctly (winzip opens with a blank file named GREENSHT.ZIP). When I run the batch file (by double clicking it) it works perfectly:
Like most of the Office programs, Microsoft Outlook 2000 and later versions includes Visual Basic Applications, where you can write your own code to automate Outlook. And, like most of the Office programs, there is no macro recorder. Fortunately, there are plenty of VBA samples here and elsewhere. http://www.outlookcode.com/article.aspx?id=49

Getting Started with Outlook VBA