VBA to save worksheet with a prefined file path and file name

Hi all,

Can anyone help?

I have a workbook which has four worksheets, I want to save the active worksheet (but start from row 10 to the end) to new workbook when user clicks the submit command button which is within the same worksheet.

The file path must be predefined as S:\Timesheet\this part should fetch todays date in the format yyyy-mm-dd and add the text in cell c1. So for example…

A user clicked the submit button and the save as is prompted with the file name and file path already defined.

S:\Timesheet\2014-05-15 NEW1.xlsx

Can anyone advise how I can achieve this.


Many Thanks in advance.

Hi

just see the attached file.......

Many Thanks for your reply Sunil.

The macro works nicely however the text name New1 should be referenced to a cell and pickup the title within the cell. The cell is referenced from another worksheet so it won’t conflict the clear down code at the end.

Cheers, Kiran

Hi there,

I am getting a VBA error message, please see attachment. Can anyone help?

Thanks