Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 88
Default Automate importing

How can i automate importing of worksheets from cvs files into an open
workbook? I was thinking of creating a button to contain a macro that would
have a pop up window that let the user choose the file to import, and have
the macro delete the old tab and rename the imported tab what ever i hard
code it to be. I could really use some help on this whole thing I know what
i want but dont know how to get there.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Automate importing

See your other thread.

"jln via OfficeKB.com" wrote:

How can i automate importing of worksheets from cvs files into an open
workbook? I was thinking of creating a button to contain a macro that would
have a pop up window that let the user choose the file to import, and have
the macro delete the old tab and rename the imported tab what ever i hard
code it to be. I could really use some help on this whole thing I know what
i want but dont know how to get there.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1


--

Dave Peterson
Reply
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
Importing Alan Beban's code on Arrays; Importing a module or a project Steve G Excel Worksheet Functions 4 August 27th 07 04:18 PM
automate importing jln via OfficeKB.com Excel Programming 10 November 7th 06 01:13 PM
automate importing text files? sinnetBS Excel Discussion (Misc queries) 0 June 22nd 06 11:34 PM
Excel.......Automate importing multiple changing CSV's Devon[_2_] Excel Programming 1 August 28th 04 12:57 AM
Automate Add-In Geerty Excel Programming 2 June 6th 04 11:27 PM


All times are GMT +1. The time now is 07:10 AM.

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"