Blogs from Wise Owl on References in VBA macros

Showing blogs 1-9 (out of 9)

VBA code to create a chart and textbox, and copy them to Word

Posted by Andy Brown on 03 October 2014

Charts in VBA are a bit weird: this blogs highlights some of their foibles, by showing how charts are really just special shapes, which contain shapes of their own!

Tags:   VBA macros | References    |    VBA macros | Working with charts

Programmatically searching websites using VBA

Posted by Andy Brown on 19 September 2014

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.

Tags:   VBA macros | References    |    Writing VBA | Other

Advice on how to scrape tables of data or HTML from webpages using VBA

Posted by Andy Brown on 13 January 2014

You can use VBA to extract data from web pages, either as whole tables or by parsing the underlying HTML elements. This blog shows you how to code both methods (the technique is often called "web-scraping").

Tags:   VBA macros | References    |    Writing VBA | Other

Write a macro in VBA to fill in an IE form (Internet Explorer)

Posted by Andy Brown on 02 November 2012

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:   VBA macros | References    |    Writing VBA | VBA tutorial

Using Excel Add-Ins to Share VBA Code

Posted by Andy Brown on 05 March 2012

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:   VBA macros | References    |    Writing VBA | VBA tutorial

Linking to ADO databases with VBA

Posted by Andy Brown on 06 February 2012

Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Creating references programmatically in VBA

Posted by Andy Brown on 03 January 2012

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:   VBA macros | References    |    Writing VBA | VBA tutorial

Using CreateObject and GetObject to create references

Posted by Andy Brown on 09 December 2011

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.

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Referencing Word and other applications in Excel VBA

Posted by Andy Brown on 05 December 2011

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:   VBA macros | References    |    Writing VBA | VBA tutorial
This page has 0 threads Add post