Get External Data Macro
 

I need a macro that does the following:
Inserts a new worksheet
Names the worksheet Sheet1 (or any other name)
Prompts for Get External Data (allowing the user to find the file)

Is there any way to do this? Or at least the last 2 parts?


--
mkerstei
------------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...o&userid=25688
View this thread: http://www.excelforum.com/showthread...hreadid=393385