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
Bookmarks