Hello Again,
First I'd like to say thanks to all those that helped before.Now i have a new problem.
I'm trying to get excel to open an existing file on my network and save it with a name including text from listbox1 then i want it to make a number of copies of the existing sheet in that workbook. # of copies would come from listbox2. any suggestions or help would be appreciated.
First I'd like to say thanks to all those that helped before.Now i have a new problem.
I'm trying to get excel to open an existing file on my network and save it with a name including text from listbox1 then i want it to make a number of copies of the existing sheet in that workbook. # of copies would come from listbox2. any suggestions or help would be appreciated.