Archive for the ‘Tutorials’ Category.

VB(A) and InternetExplorer and XMLHttp

Over the past few weeks, I’ve had reason to explore the use of VBA to access information on web pages and through web services using both InternetExplorer and XMLHttp. While my study of the two is far from exhaustive, I decided to document the research for general consumption expecting it to take a few [...]

Website update

This post introduces several new items on the www.tushar-mehta.com website.

Quickbooks SDK Part IV

Part I: Introduction and Controlling Procedure
Part II: Creating the Quickbooks Queries
Part III: Filling Class Modules
Part IV: Writing to Worksheets
In the last part, I take the collection of custom objects from Part III and write each object to a worksheet. For instance, I filled a collection with CSalesOrder objects and now [...]

Quickbooks SDK Part III

Part I: Introduction and Controlling Procedure
Part II: Creating the Quickbooks Queries
Part III: Filling Class Modules
Part IV: Writing to Worksheets
In Part I, I listed the controlling procedure that does the Quickbooks related stuff and calls all the other sub procedures. In Part II, I listed the sub procedures that created each [...]

Quickbooks SDK Part II

Part I: Introduction and Controlling Procedure
Part II: Creating the Quickbooks Queries
Part III: Filling Class Modules
Part IV: Writing to Worksheets
In Part I, I listed the entry point procedure that controls the flow. Once the connection to Quickbooks is made, I create XML requests for each query I want to run. [...]

Quickbooks SDK Part I

Part I: Introduction and Controlling Procedure
Part II: Creating the Quickbooks Queries
Part III: Filling Class Modules
Part IV: Writing to Worksheets
The Quickbooks SDK is the only way I know of to get data out of Quickbook's proprietary database format and into Excel (SDK=Software Developer's Kit, if you didn't know). It's an XML [...]

A new utility — Audio Alerts

This post introduces the TM Audio Alerts utility.

Mouse shortcuts

So Dick is the keyboard guru here, but there's a lot of people that use the mouse a lot. I know I do. And I was reading Jensen Harris' blog today about how a Paste Special operation takes 6 clicks right now, but only 3 in Office 12.
However, there are a number of [...]