View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kate T[_2_] Kate T[_2_] is offline
external usenet poster
 
Posts: 1
Default File name a variable

Hello,

I need a macro that will prompt me to open a file (of my choosing from
anywhere in my browser), copy data from different sheets within that File
(The sheets will always be named the same, but the file name will change),
and then close the file without saving.

Thanks!