jmaocubo
02-15-2013, 11:36 AM
Hello everyone
I need your help ....
I've looked on the forums for a solution but can not find any that do the work, or adapt one to my case.
I have a userform with several fields, then I created a button that transfers that data into a form in sheets
("Checklist").
I can't find out how to do the rest of the code:
1) to open windows explorer to saveas path (path from cell A2 sheets ("ADIMN"),
2) then let me choose the rest of the path and save only the Checklist sheet in a new workbook.
3) The name of the new workbook will be the constant in sheets ("Checklist"). Range ("A8"). Value and the rest of the name
will be added manually
4) In the original file: fields clearcontents
Can anyone help me?
Thanks in advance
Miguel
I need your help ....
I've looked on the forums for a solution but can not find any that do the work, or adapt one to my case.
I have a userform with several fields, then I created a button that transfers that data into a form in sheets
("Checklist").
I can't find out how to do the rest of the code:
1) to open windows explorer to saveas path (path from cell A2 sheets ("ADIMN"),
2) then let me choose the rest of the path and save only the Checklist sheet in a new workbook.
3) The name of the new workbook will be the constant in sheets ("Checklist"). Range ("A8"). Value and the rest of the name
will be added manually
4) In the original file: fields clearcontents
Can anyone help me?
Thanks in advance
Miguel