View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eunice W Eunice W is offline
external usenet poster
 
Posts: 2
Default Excel-VB Macro Variables

I have not worked with macros but I think I could use one to really speed
things up. How do I assign a variable in VB to pick up the name of an Excel
file that changes each time I open a new file? I have to open many files,
and copy various cells to another spreadsheet. Any ideas?