Results 1 to 6 of 6

Thread: Excel and Visual basic linking

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    6

    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

  2. #2
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    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"
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    6

    Re: Excel and Visual basic linking

    small problem. i can't seem to use that command.



    maybe its something to do with VBexpress.

    the commands that are the closest is my.resources.____ something.. nothing else seems to work

  4. #4
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Excel and Visual basic linking

    my.resources??? is that .NET??
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

  5. #5

    Thread Starter
    New Member
    Join Date
    Jun 2006
    Posts
    6

    Re: Excel and Visual basic linking

    yes it is.

  6. #6
    PowerPoster Static's Avatar
    Join Date
    Oct 2000
    Location
    Rochester, NY
    Posts
    9,390

    Re: Excel and Visual basic linking

    ahh.. try posting this in the .NET forum (im no good with .net.. only VB6)
    JPnyc rocks!! (Just ask him!)
    If u have your answer please go to the thread tools and click "Mark Thread Resolved"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width