Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have placed some code on the on OPEN event of an Excel worksheet.

    the code basically exits the worksheet if the folder is not a specific one.. however, i have made a typo, and now it exits every time.

    this is the only copy of the sheet i have.

    i cannot make another folder with the correct name, because of stupid network permissions.

    the file name i have made in the excel sheet is lowercase, whereas i guess it has to be uppercase, as per the directory listing.

    help !!!!!!

  2. #2
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Application.EnableEvents = False
    workbooks.Open "C:\Myforlder\MYfile.xls"
    Application.EnableEvents = True

    Ok.. answered my own question with the help of google. apologies.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I have moved this topic from the Access forum to the Excel forum since it's a question about Excel.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Or set macro security to medium or high before opening the file...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Or hold down the Shift key.
    Regards,
    Rory

    Microsoft MVP - Excel

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Which no longer works with Excel 2007.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Oops.. sorry for the wrong area. my lean towards the access forum...

    At least the question is answered in depth for anyone else in the same predicament!

Posting Permissions

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