open file from excel


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: open file from excel

  1. #1
    Join Date
    Nov 2007
    Posts
    11

    Exclamation open file from excel

    have file name in a cell
    i use a beforedoubleclick event
    i would like to invoke the double click to the file name

    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 5 Then
    Cancel = True
    'place double click procedure here "C:\Documents and Settings\conpxb12\Desktop\FabMacQuote\S-1550.edrw") For Random As 1
    Else: Cancel = False
    End If
    do not want shell
    any help would be great

    NO SHELL..too many prob with file types.

    example:
    if you doubleclick a file on your desktop.. it opens with the appropriate *.exe
    i want to do this from the spreadsheet using target.cell info

    does this help?
    Last edited by batman61; 11-14-2007 at 10:36 AM. Reason: UpDate

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    When you say you want to "invoke the double click to the file name," do you mean that you want to open the file in its associated application? If so, you can use the ShellExecute API function: http://www.vb-helper.com/howto_shellexecute.html
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. mutual exclusive write to Excel file
    By extreme in forum VB Classic
    Replies: 0
    Last Post: 06-13-2007, 10:51 PM
  2. wav file fade in out help
    By jase_dukerider in forum C++
    Replies: 2
    Last Post: 04-14-2005, 08:48 PM
  3. Open a file in Altris EB from MS Excel in VB
    By Joel in forum VB Classic
    Replies: 0
    Last Post: 12-05-2002, 09:27 PM
  4. Replies: 0
    Last Post: 08-03-2001, 07:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center