Oct 15, 2004 #1 jabmod MIS Sep 12, 2004 68 0 0 US How do I create an excel file to my c drive. Thanks
Nov 1, 2004 #2 VBrit Programmer May 26, 2004 145 0 0 GB you can use the excel automation server, ideally late bound so that you can maintain compatibility with other versions of excel on the client box: dim oxlApp as Object dim oxlWB as object set oxl = createobject("Excel.Application") set oxlWB = oxl.workbooks.add with oxlWB 'do all your stuff to populate the workbook / sheets end with oxl.saveas "your target filename" 'release memory set oxlWB = nothing oxlApp.quit set oxlApp = nothing Hope this is of use. VBrit Upvote 0 Downvote
you can use the excel automation server, ideally late bound so that you can maintain compatibility with other versions of excel on the client box: dim oxlApp as Object dim oxlWB as object set oxl = createobject("Excel.Application") set oxlWB = oxl.workbooks.add with oxlWB 'do all your stuff to populate the workbook / sheets end with oxl.saveas "your target filename" 'release memory set oxlWB = nothing oxlApp.quit set oxlApp = nothing Hope this is of use. VBrit
Nov 9, 2004 #3 bombdropVB Programmer Dec 3, 2002 59 0 0 GB Try the following Excell creation In VB this will creat a workbook and sheets without Excel on the machine Hope this helps Upvote 0 Downvote
Try the following Excell creation In VB this will creat a workbook and sheets without Excel on the machine Hope this helps