error 5

Hi I'm trying to open another workbook based on the day of the week extracted from the date in the file name of the current workbook. This is my code: Function OpenWerkboek() Dim Bestand As String Dim DatumDag As Long Dim DatumMaand As Long Dim DatumJaar As Long Dim...

Hello All, I created the below VBA for making a pivot run in macros, It show - Run-time error '5', Invaild Procedure call or argument for the below bold text, can anyone help me figure out my error and how to correct the same, Thanks a Ton! Sub Pivotmacro() ' ' Pivotmacro Macro ' ' FR =...

Fellow Excellers, I have a code to make PDF's from Excel worksheets. It's working correctly at my place, but at a client's its not working properly. The code for getting the sheet to PDF is as following, with the errorline in bold/underlined: ws.ExportAsFixedFormat Type:=xlTypePDF...

Error occurs at the "Name sfile as sbfile" line. Is there an object issue? Is there an issue with the use of date and time in the sbfile format? Public Sub Print_Batch_RS() Dim sfile As String Dim sbfile As String Dim Myfile As String Dim MyoldFile As String Dim g Dim...

Caveat - I am brand new to posting on this board and quite new to macros. That being said, I have created a macro with part recording and part hand-editing that makes a new pivot table from a pivot table made by another macro. I ran the macro quite a few times successfully, then I started...