+ Reply to Thread
Results 1 to 2 of 2

error message "Microsoft Excel cannot access the file c:\temp\

  1. #1
    Registered User
    Join Date
    06-18-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    46

    error message "Microsoft Excel cannot access the file c:\temp\

    Hi, the code im using works in excell 2007 but when i switch to 2010 it gives me the error message "Microsoft Excel cannot access the file c:\temp\. the lines where the error is occuring is the following:
    ActiveWorkbook.SaveAs Filename:= _
    "C:\Temp\" & ThisWorkbook.Worksheets("emailnames").Range("team_name") & " CDM Action List.xls", FileFormat:=xlNormal, _
    Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
    CreateBackup:=False

    can you tell me why this is happening. Im guessing its a change in syntax between 2007 and 2010.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: error message "Microsoft Excel cannot access the file c:\temp\

    Are you attempting to run it on a different machine also? Is there a change in OS?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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