VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

ADO to Excel without Excel References

VBAKid  (1 Submission)   Databases/Data Access/DAO/ADO   Visual Basic 3.0   Advanced   Wed 3rd February 2021

This Dll is just an expansion upon the previous submission to create .xls without having Excel on the machine. It allows an ADO recordset to be turned into a spreadsheet, with some formatting controls (borders and allingment). It also allows floating point values to be added, the conversion routine was nicked from VBC, and is left pretty much untouched from the submission found here.

Assumes
The recordset should be static type, and no more than 255 columns should be used. The overflow probelm has now been corrected

Rate ADO to Excel without Excel References (7(7 Vote))
ADO to Excel without Excel References.bas

ADO to Excel without Excel References Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters