Hi, can anyone help me on how to generate Microsoft Excel formatted files using VB. Thanks
Printable View
Hi, can anyone help me on how to generate Microsoft Excel formatted files using VB. Thanks
There's an absolute ton of sample code detailing this which has already been posted on the forums - please use the search tool in the upper right and you'll find all you need!
As a side note, if this is a server application you are writing which may be creating, or have the possibility of future-creating a lot of Excel workbooks, you may want to look at either creating csv or tab delimited files, or taking a look at this site: http://www.carlosag.net/Tools/ExcelX...r/Default.aspx
Here's some posts to get you started:
http://www.vbforums.com/showthread.php?t=406637
http://www.vbforums.com/showthread.php?t=519350
http://www.vbforums.com/showthread.p...d.php?t=523355
can you give me sample keywords for this. Thanks a lot for the reply
Whichever way you create and Excel instance, the term "Excel.Application" is used - try searching for that, but the above links should be enough to get you started really. :)
Post #2 and #3 from my FAQ
http://www.vbforums.com/showthread.php?t=406637
That was the 1st link I posted :eek: :ehh: - my turn for the invisibility today then I guess :cool: :D
Oh snap, so it was! :eek:
Ps, thanks for the link promotion :D