LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

--
mkerste
-----------------------------------------------------------------------
mkerstei's Profile: http://www.excelforum.com/member.php...fo&userid=2568
View this thread: http://www.excelforum.com/showthread.php?threadid=39339

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get External Data Macro mkerstei Excel Discussion (Misc queries) 0 August 5th 05 06:46 PM
import external data via macro/vba question Drabbacs Excel Programming 1 May 24th 04 11:36 PM
Run Macro on External Data Refresh John Witte Excel Programming 3 December 3rd 03 01:42 PM
Run Macro on External Data Refresh John Witte Excel Programming 0 December 3rd 03 12:49 AM
vba macro for getting external data pmz Excel Programming 1 October 31st 03 07:42 AM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"