MS Office blogs
Showing blogs 61-80 (out of 126)
Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.
By referencing the unintuitively named Microsoft Scripting Runtime object library you can write VBA code to access files and folders on your hard disk. This blog explains how, and gives a couple of worked examples.
The easiest way to work with text files in VBA is using TextStream objects - this blog explains how they work.
To make it easier for users of your VBA systems to choose files, you can show FileDialogs on screen. This blog explains what these are, and how to customise them.
In order to work efficiently with files and folders you first need to create a FileSystemObject. This blog explains how to do this!
If you find yourself constantly deleting and inserting columns every time you create a new project it might be time to consider creating a custom table that you can share between projects. This blog shows you how to do exactly that!
If you find that you have to continuously rearrange the preset views every time you create a new file in Microsoft Project, why not try creating your own custom view? This blog explains how to do exactly that!
Reporting on progress is an essential part of running a successful project. It's a shame that the preset reports in Microsoft Project are so limited. This blog explains how to create your own custom reports so that you can see the data you need.
There are many things that you can customise in Microsoft Project to mould it to the way you work. This blog summarises the main useful things that can be customised along with links to detailed articles explaining how to modify each one.
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.
A quick guide to adding public holidays to the Calendar in Outlook 2010.
Santa Claus has decided not to use Microsoft Project to manage the present distribution process - read this blog to find out why!
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.
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
Some tasks in Excel always seem to take longer than they should - if only you knew a bunch of quick shortcuts to speed up the simple things. Read on to see how much time you could save!
What happens when your macros go wrong? That depends what error-handling you have in place. Learn how to use ON ERROR and other commands to trap errors in a structured way.
This series of blogs is intended to provide online training in how to debug in Visual Basic for Applications, including using breakpoints and the immediate window.
Want to do something when a user opens a workbook, or stop them clicking on a particular cell? You need to learn how to attach code to Excel workbook or worksheet events!
There are 4 types of loop in Visual Basic for Applications - this blog shows how and when to use each type of VBA loop structure.
This part of the Excel VBA training series of blogs shows how to use IF / ELSE / END IF within VBA, and also how to use the alternative SELECT / CASE syntax within macros.