Results 1 to 16 of 16

VBA Run Time Error when saving workbook between Users....?

Threaded View

  1. #1
    Registered User
    Join Date
    12-26-2012
    Location
    St. louis
    MS-Off Ver
    Excel 2010
    Posts
    11

    Angry VBA Run Time Error when saving workbook between Users....?

    Hi,

    I created a workbook that up to this point has worked well thanks to this forum. The VBA look at a specific cell value and either emails the active worksheet as a PDF file or saves the entire workbook as a xlms file to a specific folder.

    As I mentioned it has worked great without any problems when i am testing it but when i sent it to one of the users to try it they received the "Run Time Error.

    They have access to the folder location.

    Any ideas on why it works when I use it versus when another user?

    Macro:
    Sub Save()
        
        Dim ws As Worksheet
        
        On Error Resume Next
        Set ws = Sheets("Disable Save")
        On Error GoTo 0
        
        If ws Is Nothing Then
            Set ws = ActiveSheet
            With Sheets.Add
                .Name = "Disable Save"
                .Visible = xlSheetVeryHidden
            End With
            ws.Select
            ActiveWorkbook.SaveAs "X:\Administration\Human Resources\Recruiting\Change Requests\" & Range("D23").Value & " - " & Range("B9").Value & ".xlsm", xlOpenXMLWorkbookMacroEnabled
        End If
        
    End Sub
    Last edited by JosephP; 12-28-2012 at 02:04 PM. Reason: add code tags

Thread Information

Users Browsing this Thread

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

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