Open files in vb5-VBForums
Results 1 to 7 of 7

Thread: Open files in vb5

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2017
    Posts
    6

    Open files in vb5

    Hi
    I have multiple word and excel 2007 files on desktop in a folder and would like to view them in a list box and subsequently open any of the file through button after selected.
    Two problems are coming up:
    1----- Doc and xls files are not coming in List box together; only doc files are visible?
    2----- After selecting file in List box and pressing button an error message pop up Run time error 424 and beneath it "Object Required".
    below link

    https://1drv.ms/f/s!ApB75VvFFQtogTE9mIiVnpcql4Li

    is for the files to view coding.

    regards

    AM

  2. #2
    Frenzied Member
    Join Date
    Dec 2008
    Posts
    1,065

    Re: Open files in vb5

    This should not be posted in the Codebank, it should be posted here instead -
    http://www.vbforums.com/forumdisplay...-6-and-Earlier

    The fact that you are using VB5 should not be a problem for us VB6 users.

    Some members may be wary of clicking a link.
    Zip up your project, and attach it.
    Yell out if you do not know how to do that.

    Rob

  3. #3
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    Location
    An obscure body in the SK system. The inhabitants call it Earth
    Posts
    6,513

    Re: Open files in vb5

    Moved.

    Welcome to the forum Amir.
    You can depend upon the Americans to do the right thing. But only after they have exhausted every other possibility - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  4. #4
    PowerPoster
    Join Date
    Dec 2004
    Posts
    23,034

    Re: Open files in vb5

    Some members may be wary of clicking a link
    while uploading the whole project may be a good idea, it would probably help if you also added the relevant parts of the code (in code tags) to a post, especially if the project is quite big
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  5. #5
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    12,182

    Re: Open files in vb5

    Yes, you should post the related code section directly in your post.
    That is easier for us and will get more eyes on your issue.

  6. #6
    Frenzied Member
    Join Date
    Dec 2008
    Posts
    1,065

    Re: Open files in vb5

    I have made one up for you.
    It has browse for Folder (or you can type a folder name)
    It has ability to select doc or xls or both
    It lists them alphabetically in a listbox
    If you click an entry in the listbox it opens it in Word or Excel
    It has no dependencies, and no flippin FSO

    I don't mind attaching it, however I will get thumped by a few members, as they like to get the feeling that you have made some effort yourself.

    What am I supposed to do ?
    Rob

  7. #7
    Fanatic Member Spooman's Avatar
    Join Date
    Mar 2017
    Posts
    869

    Re: Open files in vb5

    Amir

    Let me joint Funky in welcoming you to the Forums ..

    Some members (me included) are a little wary of downloading files.
    So, if you could post it (or a portion of it) as suggested, it would be a start.

    If you are not sure how to do that, try this
    1. Begin a new post here in this thread
    2. Look in the menu bar of the "Quick Reply" window .. at the right-hand side, there is a "#" button.
    3. This is referred to as a "code wrapper"
    4. Cut and paste your code here.
    5. Then select it, and click that button.


    Holler if you have any questions about dong that

    Spoo

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.