Blogs from Wise Owl on References in VBA macros
Showing blogs 1-7 (out of 7)
Posted by Andy Brown on 19 September 2014 | no comments
I've already pinched (with permission!) the ideas of Fergus Cairns to explain ways to run automatic searches on popular websites like Google; this blog gives an update on the same topic.
Posted by Andy Brown on 02 November 2012 | no comments
You can use VBA to talk to Internet Explorer, providing that you understand the structure of the web page you're talking to. This blog shows how to do this!
Posted by Andy Brown on 05 March 2012 | 2 comments
If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.
Posted by Andy Brown on 03 January 2012 | no comments
Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.
Posted by Andy Brown on 09 December 2011 | 1 comment
Although it's usually easiest to create references to other applications using the Tools/References menu as described in an earlier blog, you can use the method shown in this blog instead.
Posted by Andy Brown on 05 December 2011 | 6 comments
Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software
MS OFFICE BLOGS
VBA MACROS BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR