v_gyku
10-28-2005, 10:02 PM
I have names of all worksheets from a single workbook in a listbox.
User will select multiple sheets from the listbox.
I want to copy each selected sheets to a temp workbook(for each sheet there will be a seperate temp workbook). These temp workbooks will be placed in a folder which is already created.
I have path of original workbook.
I have path where the tempworkbooks will be placed.
Thanks...
User will select multiple sheets from the listbox.
I want to copy each selected sheets to a temp workbook(for each sheet there will be a seperate temp workbook). These temp workbooks will be placed in a folder which is already created.
I have path of original workbook.
I have path where the tempworkbooks will be placed.
Thanks...