Results 1 to 9 of 9

File Open Dialog

Threaded View

tommy_gtr File Open Dialog 10-25-2007, 04:14 AM
broro183 HI Tomas, Try this: ... 10-25-2007, 05:47 AM
dominicb Good morning I was... 10-25-2007, 06:27 AM
tommy_gtr File Open Dialog 10-25-2007, 07:29 AM
broro183 good morning/night here ;)... 10-25-2007, 07:34 AM
tommy_gtr file Open Dialog 10-25-2007, 08:23 AM
  1. #1
    Registered User
    Join Date
    08-09-2005
    Posts
    42

    File Open Dialog

    Hello, I would like to do a macro which will open another excel file through Open Dialog, so I use
    filetoopen = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
    .
    It's ok, but I want to open this "Open Dialog" in a location where my ActiveWorkbook is saved. How can I do this?

    I tried something like this ...
    filetoopen = Application.GetOpenFilename(ThisWorkbook.Path & "Excel Files (*.xls), *.xls")
    but this gives current workbook path into filetype box.

    Can anyone help, please???

    Thanks

    Tomas
    Last edited by VBA Noob; 10-25-2007 at 04:18 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1