View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
KHashmi316[_3_] KHashmi316[_3_] is offline
external usenet poster
 
Posts: 1
Default Import Data macro


Worked like a charm -- thank you!

May I ask for one more tweak? In it's current form, the InputBox asks
for the filename with complete file path. Is it possible to design the
InputBox so that one can *Browse* for a file. Often I find it helpful to
type/paste in a simple directory path (e.g. C:\Excel_files\) and choose
the file I wish to import.

-KH


--
KHashmi316
------------------------------------------------------------------------
KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439
View this thread: http://www.excelforum.com/showthread...hreadid=374615