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?

Hi Eunice,

See Ron de Bruin at:

http://www.rondebruin.nl/copy3.htm

for sample code and techniques.


---
Regards,
Norman



"Eunice W" <[email protected]> wrote in message
news:[email protected]...
>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?

Thank you Norman, looks like just the ticket. How ever did you locate this!

"Norman Jones" wrote:

> Hi Eunice,
>
> See Ron de Bruin at:
>
> http://www.rondebruin.nl/copy3.htm
>
> for sample code and techniques.
>
>
> ---
> Regards,
> Norman
>
>
>
> "Eunice W" <[email protected]> wrote in message
> news:[email protected]...
> >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?
>
>
>