Microsoft excel cannot access the file C:\... The file name or path

**HraHuuh** · 08-02-2012, 05:37 AM

Hey!
Ive made macro which open new workbook and then save it to your computer. It works well using my computer. Then I sent it to my friend that he could use it. When he runs the macro this error comes up " Microsoft excel cannot access the file C:\... The file name or path doesnt exist, the file is being used by another program.. " etc..
Could someone help me with this error?

Br. Antti

**JosephP** · 08-02-2012, 05:38 AM

need to see the code to fix it ;-)

**HraHuuh** · 08-02-2012, 05:43 AM

Here is the critical part of code

Sub Button25_Click()

Dim sPath As String
Dim wk As Workbook
sPath = "C:\CompetitorInformation.xls"
Application.DisplayAlerts = False


If FileOrDirExists(sPath) Then
    Workbooks.Open Filename:="c:\CompetitorInformation.xls"
    Workbooks("CompetitorInformation.xls").Close
    Kill "C:\CompetitorInformation.xls"
    Set wk = Workbooks.Add
    wk.SaveAs Filename:="C:\CompetitorInformation.xls"
Else
    Set wk = Workbooks.Add
    wk.SaveAs Filename:="C:\CompetitorInformation.xls"
End If

**JosephP** · 08-02-2012, 05:48 AM

what's the point of opening and closing and then deleting the workbook? it appears you could simply use

Sub Button25_Click()

Dim sPath As String
Dim wk As Workbook
sPath = "C:\CompetitorInformation.xls"
Application.DisplayAlerts = False

    Set wk = Workbooks.Add
    wk.SaveAs Filename:=sPath

though perhaps the user does not have permission to write to the root of C