+ Reply to Thread
Results 1 to 2 of 2

Open File Directly instead of fileopen dialogue box

  1. 10-31-2017, 06:44 AM #1
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Post Open File Directly instead of fileopen dialogue box

    hi,
    i am using this code open a file name based on cell value,
    Please Login or Register  to view this content.
    file name = Sheets("ENTRY").Range("J1").Value

    i don't want to popup filedialog.... i want to open directly file

    thank you
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *
    Reply With QuoteRegister To Reply
  2. 10-31-2017, 06:59 AM #2
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Open File Directly instead of fileopen dialogue box

    Hi,

    You can do this
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Code: Dialogue for FileOpen and Saveas on Specific File Path
    By Livvi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 12:45 PM
  2. [SOLVED] Using Open File Dialogue to Combine Worksheets
    By ChrisMattock in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-17-2015, 06:44 AM
  3. NOT to display the open file dialogue
    By ripple in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2014, 09:08 AM
  4. Any Excel file do not open from directly from file- How can I solve it ?
    By Kuntal Chakraborty in forum Excel General
    Replies: 1
    Last Post: 07-24-2013, 02:32 AM
  5. Change code to start without fileopen and directly with F11
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2012, 04:49 PM
  6. VBA Cancelling the Open File Dialogue
    By Mase123y in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-20-2009, 01:37 PM
  7. Sort order in File Open dialogue box
    By Roberto in forum Excel General
    Replies: 1
    Last Post: 12-11-2005, 08:50 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1