Message 1 of 7
Include Excel Worksheet in VB exe?

Not applicable
09-09-2004
04:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
A bit non-IV related but nonetheless:
I am about 1/2 way thought a VBA app in an excel workbook and I'm finding
that my decision to use VBA (because I was feeling lazy) was the wrong one.
So now I'm fessing up and willing to do it right.
My question, I can easily access an external workbook from VB but is there a
way to
INCLUDE the workbook as part of the EXE? This is not a question of
distributing the Excel objects as the end user will all have Excel. But I
want the xls file itself to be included (so I don't have to do an install or
provide a path to the xls file.)
Kind of like a resource file but the entire excel workbook. And BTW the
excel file currently exists and would be a bear to recreate in the VB
project. Just looking for a simple way to "include it".
Am I making sense? Any way to do this?
--
Sean Dotson, PE
www.sdotson.com
Autodesk Inventor Certified Expert
Sidel, Engineering & Manufacturing Manager