Include Excel Worksheet in VB exe?

Include Excel Worksheet in VB exe?

Anonymous
Not applicable
303 Views
6 Replies
Message 1 of 7

Include Excel Worksheet in VB exe?

Anonymous
Not applicable
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
0 Likes
304 Views
6 Replies
Replies (6)
Message 2 of 7

Anonymous
Not applicable
Sean, I haven't used it myself, but have you looked into adding a file and checking it as a "Related Document"? I have NO clue how to access that document, and I don't have any ideas wether or not the file will be copied or included in the EXE. Guess there's only one way to find out...(trial and error, once again :-)) I have an Addin working that also accesses an external XLS file. But I copy the XLS file from the server to the root of the users computer as soon as het starts the Addin. The users will always access his local copy of the XLS file. But if you get this to work, I'll be glad to know how you did it! B.t.w I still have to write some IV Tutorials...just can't get my hands on some free time... :-( And what about my suggestion about the "Top Items To Be Fixed" topic on your web-site? ***** Add As Related Document Adds items such as Microsoft Excel worksheets or Microsoft Word documents to the Related Documents folder in the Project Explorer.
0 Likes
Message 3 of 7

Anonymous
Not applicable
Thanks, I'll look into that. I'm still open to suggestions. > And what about my suggestion about the "Top Items To Be Fixed" topic on your > web-site? Someone did that for me. I haven't had time to post or look at it however. -- Sean Dotson, PE www.sdotson.com Autodesk Inventor Certified Expert Sidel, Engineering & Manufacturing Manager "Teun Ham (IV9)" wrote in message news:41405c99$1_3@newsprd01... > Sean, > > I haven't used it myself, but have you looked into adding a file and > checking it as a "Related Document"? > I have NO clue how to access that document, and I don't have any ideas > wether or not the file will be copied or included in the EXE. > Guess there's only one way to find out...(trial and error, once again :-)) > > I have an Addin working that also accesses an external XLS file. But I copy > the XLS file from the server to the root of the users computer as soon as > het starts the Addin. The users will always access his local copy of the XLS > file. > > But if you get this to work, I'll be glad to know how you did it! > > B.t.w I still have to write some IV Tutorials...just can't get my hands on > some free time... :-( > And what about my suggestion about the "Top Items To Be Fixed" topic on your > web-site? > > ***** > > Add As Related Document > Adds items such as Microsoft Excel worksheets or Microsoft Word documents to > the Related Documents folder in the Project Explorer. > >
0 Likes
Message 4 of 7

Anonymous
Not applicable
I am not sure I completely follow what this is, but it looks interersting http://www.resourcemining.com/index.html It says A Windows conversion utility that converts resource files to Excel® spreadsheets and back again. Great tool for Visual Basic® and Visual C++® developers and translators. Click here for info. I wonder if you can just add the excel file as a custom object to the resource file? -- Kent Keller Autodesk Discussion Forum Facilitator "Sean Dotson" wrote in message news:41407d4c_2@newsprd01... > Thanks, I'll look into that. I'm still open to suggestions.
0 Likes
Message 5 of 7

Anonymous
Not applicable
Not exactly Kent. I don't want to loose the formatting etc.. (as I also plan on allowing the user to print the excel file) A custom resource file is a possible idea. I'll look into it. -- Sean Dotson, PE www.sdotson.com Autodesk Inventor Certified Expert Sidel, Engineering & Manufacturing Manager "Kent Keller" wrote in message news:41407f65$1_2@newsprd01... > I am not sure I completely follow what this is, but it looks interersting > http://www.resourcemining.com/index.html > > It says > > A Windows conversion utility that converts resource files to Excel® > spreadsheets and back again. Great tool for Visual Basic® and Visual C++® > developers and translators. Click here for info. > > I wonder if you can just add the excel file as a custom object to the > resource file? > > -- > Kent Keller > Autodesk Discussion Forum Facilitator > > > "Sean Dotson" wrote in message > news:41407d4c_2@newsprd01... > > Thanks, I'll look into that. I'm still open to suggestions. > >
0 Likes
Message 6 of 7

Anonymous
Not applicable
Yeah, I didn't really follow what that tool was, but I didn't spend much time on the site either I wonder if VB.Net has better tools for something like this. If you are making a Exe, and not a addin might be time to get your feet wet? ;~) I suppose even if you are doing a addin, but it sounds a lot more complicated from what has been posted here. -- Kent Keller Autodesk Discussion Forum Facilitator "Sean Dotson" wrote in message news:414092bd$1_2@newsprd01... > Not exactly Kent. I don't want to loose the formatting etc.. (as I also > plan on allowing the user to print the excel file) A custom resource file > is a possible idea. I'll look into it. > > -- > Sean Dotson, PE > www.sdotson.com > Autodesk Inventor Certified Expert > Sidel, Engineering & Manufacturing Manager
0 Likes
Message 7 of 7

Anonymous
Not applicable
It's not an add-in and I don't want to use .NET I'm comfortable in my VB6 world. I'm scared to leave it.. In the mean time I've found you can use an OLE control to embed an XLS file and refer to it. So far it seems to be working. I'll report back later. -- Sean Dotson, PE www.sdotson.com Autodesk Inventor Certified Expert Sidel, Engineering & Manufacturing Manager "Kent Keller" wrote in message news:41409a0e$1_2@newsprd01... > Yeah, I didn't really follow what that tool was, but I didn't spend much > time on the site either > > I wonder if VB.Net has better tools for something like this. If you are > making a Exe, and not a addin might be time to get your feet wet? ;~) I > suppose even if you are doing a addin, but it sounds a lot more complicated > from what has been posted here. > > -- > Kent Keller > Autodesk Discussion Forum Facilitator > > > "Sean Dotson" wrote in message > news:414092bd$1_2@newsprd01... > > Not exactly Kent. I don't want to loose the formatting etc.. (as I also > > plan on allowing the user to print the excel file) A custom resource file > > is a possible idea. I'll look into it. > > > > -- > > Sean Dotson, PE > > www.sdotson.com > > Autodesk Inventor Certified Expert > > Sidel, Engineering & Manufacturing Manager > >
0 Likes