| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| save original data after macro is run again | New Users to Excel | |||
| Problem with external data | Excel Discussion (Misc queries) | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Macro does not run when data refreshed | Excel Discussion (Misc queries) | |||
Linear Mode
