Save As Instruction?

[Ray Rz]

I have a VB script that sets up a number of tables and asks for input from the user to identify 3 input files and a date field in the script. The file updates a number of tables via the refresh and then runs through to create the file. I would now like to add a save command that takes the date file the user added into cell N16 and add some text to it and save it in the same folder it existed in as a file.

I tried the following but this did not work and I figured I would ask just to check if someone had some easy solution to this issue...
The ws is identified as the worksheet prior to coming to this save but I am unsure what the code should be.

Thank you for your help.
Ray

ActiveWorkbook.Activate


SaveAs ws.Range("N16") & "- Energy - Invoice - Detail Added"

 

[Yongle]

Hi Ray - I apologise, but I do not understand what you want at all
Are trying to save the newly created workbook or save one worksheet (ws)
- what should its name be?
- where should it be saved?

What is the "date file" in N16
- is it the required file name?

"Add some text to it "
- what is it? the value in N16 or the worbook itself?
- what is the text to be added?

"the same folder it existed in as a file"
- no idea what this means or how to get at the folder path
- what is it?