Printable View
Can I write a vb program that create an excel workbook and run it on a pc that doesn't have excel?
I was just trying to see if it works, I wrote a vb form with a cmd button to add a Excel application, add a workbook, with 2 columns on sheet1, make an exe, install on a pc that doesn't have excel (Window XP Home Edition), ran the exe, and received a run-time error 429.
Thanks.
Hi, welcome to VBForums :wave:
No you can't I'm afraid, as Excel does the work. You can use CSV files tho, as they are just text files which you can work with using normal VB code for files (see the FAQ link in my signature for code examples).
Yes you can create .XLS Workbooks with your own Sheet tabs and columns without having Excel installed at all. All it requires is ADO:
http://www.vbforums.com/showthread.p...t=Excel+SELECT
Thanks for the help.