View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Walt[_2_] Walt[_2_] is offline
external usenet poster
 
Posts: 4
Default variable 'open' command

Hi Guys

I have the following problem:
I have to copy data from one excelfile (1.xls) to another
(summery.xls). No problem so far. it looks like

Workbooks.Open ("c:\[...]\1.xls")
Windows("1.xls").Activate

But now the path and the file itself changes! i need some kind of
query to tell to program which file it should use.

I couldn't find anything in the helpfiles which are not helpful at
all, btw.

Help is very much appreciated!
Walt