Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File

  1. #1
    Join Date
    26th June 2012
    Posts
    3

    Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File

    Hi All,

    I'm have created many excel reports and the same is being used by various users in my company. I need to track the usage of these reports. Therefore, I created a file called "log.inf" in a network drive. In the excel reports, the workbook open event opens the text file (log.inf) and updates the info needed to be tracked. This works perfectly fine on my system (Excel 2007/ Windows Vista) and some of the users systems. However, some users (Excel 2010/ Windows 7) get the run time Error 75 - Path/ File Access Error. However, i have ensured that the users definitely have access to the network drive and the specific "log.inf" file. Below is the Code I'm using:

    VB:
    Private Sub Workbook_Open() 
        Dim ff As Long 
         
         
        Application.ScreenUpdating = False 
        Application.DisplayAlerts = False 
         
        On Error Goto netcon 
        ff = FreeFile() 
        Open "\\fileshares.corp\groups\RAPID_REPORTS\logs\log.inf" For Append As #ff 
        Print #ff, ThisWorkbook.Sheets("AI_O").Range("A2").Value & ";" & Environ("USERDOMAIN") & ";" & Environ("USERNAME") & ";" & Now 
        Close #ff 
         
        Exit Sub 
         
    netcon: 
        MsgBox "You are currently not connected to the network. Please connect to the network and reopen the file." 
         
    End Sub 
    
    
    Also, I have tried keeping an excel file in logs folder and tried updating the excel file for those users who were getting error. This works fine, ruling out the possibility of Network Permission issue.

    Any help will be greatly appreciated.

    Thanks in advance,
    Saiju Paul C

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th January 2003
    Location
    UK
    Posts
    2,745

    Re: Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File

    Hi and welcome to the forum.

    I see that as part of the debugging process you have tried using an Excel file instead of the desired text file. Have you also tried with the (text) file being saved in a different location? For example, is there a Temp file that you could try?
    Cross-poster? Read this: Cross-posters
    Struggling to use tags (including Code tags)? : Forum tags

  3. #3
    Join Date
    26th June 2012
    Posts
    3

    Re: Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File

    Hi Richie,

    Thanks for the response
    Yes. I have tried couple of other network locations but no luck. However, the code works fine if the same file is placed locally on the user's system ( the file path changed of course).

    Regards,
    Saiju Paul C

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th June 2012
    Posts
    3

    Re: Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File

    Hi Richie,

    I'm so sorry. Slap me tight. It was my fault. I did all the checks with code, but failed to realize that these Users had only read access to the drive and no write access.

    Sorry again,
    Saiju Paul C

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 10
    Last Post: May 27th, 2013, 03:56
  2. Run time error 1004 on opening file
    By mps1976 in forum EXCEL HELP
    Replies: 5
    Last Post: May 19th, 2012, 21:19
  3. Excel 2010 issue after install windows 7
    By lyambor in forum EXCEL HELP
    Replies: 2
    Last Post: March 28th, 2012, 20:20
  4. Replies: 3
    Last Post: February 23rd, 2012, 19:43
  5. Replies: 2
    Last Post: August 12th, 2005, 06:02

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
  •  
porno