Results 1 to 3 of 3

Thread: Resolved[Open file]

  1. #1

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Arrow Resolved[Open file]

    Given the path and name of some file, how can I open it from a user form?
    Last edited by Fonty; Jun 19th, 2006 at 11:38 AM.

  2. #2
    Addicted Member
    Join Date
    Mar 2006
    Location
    Manchester, England, UK
    Posts
    247

    Re: Open file

    It depends what you mean by open it.

    If you want to open it in an exteral program e.g. word or excel then use the shell command.

    VB Code:
    1. Shell("c:\somefile.xls")

    if you want to open it and process it within your application then it really depends on what the file is.

  3. #3

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Re: Open file

    I can't find out why it keeps showing with Shell run time error 5, saying "Invalid procedure call or argument"...

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