Results 1 to 3 of 3

Thread: Open an Excel file from VB6

  1. #1
    Join Date
    Aug 2006
    Posts
    332

    Open an Excel file from VB6

    Hello,

    I try to open an excel file to go write an application from VB6. The file name is contained in a variable and I can not open the file. For info, here is the code

    Myshell = Shell ( "C: \ Program Files \ Microsoft Office \ Office12 \ EXCEL.exe file", 1)

    File is defined earlier is the format c: \ folder \ un fichier.xls


    Thank you for your help.
    Do not email me asking for tech support. Any private support is billable at $50 an hour.

  2. #2
    Join Date
    May 2008
    Posts
    1,818

    Re: Open an Excel file from VB6

    Hello,

    Tests like this:

    Myshell = Shell ( "C: \ Program Files \ Microsoft Office \ Office12 \ Excel.exe" & File, 1)

  3. #3
    Join Date
    Aug 2006
    Posts
    332

    Re: Open an Excel file from VB6

    Hi and thank you for the info. I tried and it does not work. He sends me the file is found. If I file by replacing the true path then it works.

    In debug mode, the file is defined as "c: \ my folder \ my file.xls"

    You think that was the quotes that put the bazaar, and if so, how can we remove them?

    Thank you again
    Do not email me asking for tech support. Any private support is billable at $50 an hour.

Similar Threads

  1. How To Open .ods File in MS Excel?
    By Aagman in forum Windows Software
    Replies: 7
    Last Post: 10-02-2012, 08:06 AM
  2. Excel 2007 file fails to get permission to open in Excel 2011
    By Raju Chacha in forum Windows Software
    Replies: 6
    Last Post: 13-01-2012, 08:17 PM
  3. can open my excel 2003 file in xp
    By lyndon123 in forum Windows Software
    Replies: 2
    Last Post: 10-10-2011, 12:33 PM
  4. Replies: 4
    Last Post: 13-02-2011, 09:37 AM
  5. Pdf file open in Excel
    By Clemens in forum Windows Software
    Replies: 3
    Last Post: 06-02-2009, 06:40 AM

Posting Permissions

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