Hi all,
I'm trying to create a macro/program that when execute will:
1. Ask user to select and open an Excel file.
--archieved this by using GetOpenFile method.
2. Ask user to select multiple sheets in the opened file.
--GOT STUCK here.
3. Copy some infos from the selected sheets to other sheet in othe
file.
I'm stuck in 2. How do I ask user to select multiple sheets?
I tried to open the file and loop through th
Activewindow.Selectedsheet, but only one sheet was selected. There i
no dialog to temporarily stop the macro and ask user to select th
sheets. Any idea how can I solve this
--
hidek
-----------------------------------------------------------------------
hideki's Profile:
http://www.excelforum.com/member.php...fo&userid=1890
View this thread:
http://www.excelforum.com/showthread.php?threadid=49236