Daily posts of Excel tips…and other stuff
Archive for the ‘Tutorials’ Category.
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 [...]
This post introduces several new items on the www.tushar-mehta.com website.
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 [...]
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 [...]
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. [...]
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 [...]
This post introduces the TM Audio Alerts utility.
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 [...]
