Excel and Visual basic linking
I have written a program in Visual basic and it is able to read from certain excel files that are on the computer as well as write to them. This is to aid writing a standard report which is written many many times and the only thing that changes are the number and % of the ingredience of the object created. What i have problems with is that the bulk of the text is not changed and i have them stored in cells in an Excel file such that they can be called later on and written into Word. this file needs to be attached to this VBproject but i can't get it to be attached.
I can specify the path and it'll work but if i do that, when i publish the file, would not be "attached" such that another computer would have that file. i need to have it so that the file is "included" into the project so i can send the program to a friend he doesn't have to paste the file into a specified location.
most likely its something dumb like going to the task bar and insert file but i'm not familiar with the VB or Vb itself.. learned it within 2 weeks.
thank you
Re: Excel and Visual basic linking
put the file in the same folder as the app..
in the packaging.. inlcude the file
as far as loading it use
App.Path & "\filename.xls"
Re: Excel and Visual basic linking
small problem. i can't seem to use that command.
:cry:
maybe its something to do with VBexpress.
the commands that are the closest is my.resources.____ something.. nothing else seems to work
Re: Excel and Visual basic linking
my.resources??? is that .NET??
Re: Excel and Visual basic linking
Re: Excel and Visual basic linking
ahh.. try posting this in the .NET forum ;) (im no good with .net.. only VB6)