+ Reply to Thread
Results 1 to 3 of 3

Close file without saving if runtime error 52 occurs

Hybrid View

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    0

    Close file without saving if runtime error 52 occurs

    Hi,
    Looking for help here. I want my file to close without saving if file or file path not found. The file is not on the same pc it is shared through networking. I tried many options but due to Lan networking run time error occurs which does not allow vba to run.
    What is the best option i have in this situation.

    Regards,
    Viraj

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167
    Hello virajthadeshwar,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-30-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    0

    Re: Close file without saving if runtime error 52 occurs

    My Query not solved. Any other way to get the answer?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Saving File
    By waleed.slc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2018, 01:37 PM
  2. [SOLVED] runtime error 1004 in copy and close workbook vba code
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2018, 03:23 PM
  3. MyPath error when saving on close
    By ajam in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2016, 05:34 PM
  4. Runtime error and workbook won't close
    By Chris.mlyn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2014, 04:45 PM
  5. [SOLVED] VBA Runtime Error 438 saving a Excel 95/2003 as FT 50 (2010)...
    By Wiiconnaissance in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-21-2012, 10:49 AM
  6. Macro to close a file without saving
    By Yew80 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-06-2010, 10:14 AM
  7. Runtime error occurs only on 1 out of 4 workgroup users
    By gulaoye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2008, 05:41 PM

Tags for this Thread

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