troubleshooting Question

Required dll files for creating Excel files

Avatar of MariaHalt
MariaHaltFlag for United States of America asked on
Visual Basic ClassicMicrosoft Excel
6 Comments1 Solution444 ViewsLast Modified:
What dll files are required to run a VB6 program that creates an Excel file on a W2K machine?  Excel is NOT loaded on the machine.  

FYI, this is how I'm creating the Excel file:

Dim xclApplication As Excel.Application
Dim xclWorkbook As Excel.Workbook
Dim xclWorksheet As Excel.Worksheet

Set xclWorksheet = xclWorkbook.Sheets("Sheet1")

 xclWorksheet.Range("A2").CopyFromRecordset <recordset object>
   
 xclWorksheet.Range("A1").Value = "Field 1"
 xclWorksheet.Range("B1").Value = "Field 2"
 xclWorksheet.Range("C1").Value = "Field 3"
       
Set xclWorksheet = Nothing
xclWorkbook.SaveAs <filename>
xclApplication.Quit
Set xclWorkbook = Nothing
Set xclApplication = Nothing
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros