Saving to external sheet

[Bigjayce]

Hi all,

I have created a userform to help with data entry, basically the form takes the data required and enters it into the correct places on the main spreadsheet.

What I need to do is provide a SAVE button where the operator will click it, enter a filename and this will then save the data without all my vba code into a seperate sheet with the filename the user specified.

I can make it so the sheet is saved but I get a copy of the full workbook when I only need one sheet from it - is it possible ?

Thanks to all

Jayce

[theDude]

Jayce,

The following code will work for you as long as the file you are working with does not have File Sharing turned on:

Please Login or Register  to view this content.

Hope this helps,
theDude

[Bigjayce]

It kind of works but leaves the save path in the userform

Jayce