Results 1 to 7 of 7
  1. #1
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23

    File Explorer in VBA

    Hi
    How do you open File Explorer in VBA that will open in MyComputer
    and not in MyDocuments?
    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23
    I've asked here because I didn't get a satisfactory answer on p2p.wrox.com Forums

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Proper forum etiquette is to inform us that you have other threads on the same question.

    You might not feel the answer was satisfactory but sounds reasonable to me and it just might be the reality.

    Google: access vba open file dialog mycomputer
    Maybe this has a solution
    http://bytes.com/topic/visual-basic-...og-my-computer
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23
    I'm sorry, didn't know that I had to inform

  6. #6
    ybg1 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2010
    Posts
    23

    Smile

    Works beautifully - many thanks June7
    It was a really good piece of advice to look at this link.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Another courtesy would be to post resolution in other thread(s).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. API: Drag and Drop from Explorer to a text box
    By ybg1 in forum Programming
    Replies: 1
    Last Post: 01-02-2012, 02:23 PM
  2. Internet Explorer automation with VBA
    By sa230e in forum Programming
    Replies: 0
    Last Post: 09-29-2011, 05:04 PM
  3. Unhide a form in the Access "Explorer"
    By caddcop in forum Forms
    Replies: 1
    Last Post: 02-15-2011, 01:15 PM
  4. Replies: 1
    Last Post: 09-27-2010, 10:10 AM
  5. Access 97: Unable to find project explorer?
    By captgnvr in forum Programming
    Replies: 0
    Last Post: 07-19-2010, 09:20 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
  •  
Other Forums: Microsoft Office Forums