$$Excel-Macros$$ Save As - error - object required

Hi All, I am trying to create a macro that will first allow the user to define the path where files will be save to. Second, the macro creates several files and saves them into this user defined path. Below is my code and on the second line I get an error stating "object required" CODE: ' let t

Re: $$Excel-Macros$$ Save As - error - object required

Hi Jonathan, Could it be a problem that you skipped the quots... should be Filename:=strSelectedPath & "\Run1.xlsx" instead of Filename:=strSelectedPath & "\" & Run1.xlsx Kind greetings Paul Willekens -- -- So