Manipulating Excel Spreadsheets from VB6 (not VBA).

[cehagema]

Howdy- I'm reading SQL Server tables with VB6 and writing the results to Excel Spreadsheets. The syntax in VB6 differs slightly from VBA when manipulating Excel objects. In general; has anyone seen a comprehensive reference on this subject (I can't find anything on Microsoft's sight). In particular; how to accomplish:

"Columns("A:B&quot.ColumnWidth = 10"

(a VBA command) using VB6

Any help would be appreciated. Thanks-- Chris

 

[paulbent]

You just need to start from a point in the object hierarchy to which you have a reference. Say you only have a reference to the Application object, the statement might look like:

Set objApp = CreateObject("Excel.Application&quot
objApp.ActiveSheet.Columns("A:B&quot.ColumnWidth = 10

Or you might have a reference to a particular sheet already.

objSheet.Columns("A:B&quot.ColumnWidth = 10

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[cehagema]

Thanks Paul... That works. And it opened my slow mind.