I need help writing a macro that will

1. Open another workbook with a path

2. I have a listbox in the original workbook and I would like to push the checked options into a range A1:A10 on the opened workbook.

3. I would then like to "save as" for the opened workbook.

I don't think I would need to upload a sample workbook, can someone just put in filler values for the path and workbook names for 1 & 2?

Any help is appreciated.