Microsoft training courses | Wise Owl - home page

Phone (01457) 858877 or email

References in VBA macros blogs

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!
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Using Excel Add-Ins to Share VBA Code

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.

Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Linking to ADO databases with VBA

Posted by Andy Brown on 06 February 2012 | 1 comment
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Creating references programmatically in VBA

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.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Using CreateObject and GetObject to create references

Posted by Andy Brown on 09 December 2011 | 1 comment
Although it's usually easiest to create references to other applications using Tools -> References as described in an earlier blog, you can use the method shown in this blog instead.
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

Referencing Word and other applications in Excel VBA

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
Tags:   Excel / Excel Visual Basic   |   VBA macros / References

All content copyright Wise Owl Business Solutions Ltd 2014. All rights reserved.