View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
saman110 via OfficeKB.com saman110 via OfficeKB.com is offline
external usenet poster
 
Posts: 80
Default Import data into worksheet

Hi,

I'm looking for a macro that prompts and forces the user to import 2 files
and copy it into two different worksheets. (If possible, when user denies to
import files, Excel close)

First file is a .csv file that. when user imports the file, It should be
imported to wks1.
Second file is a .xls file which goes to wks2.

Any help?

Thx.

--
Message posted via http://www.officekb.com