Hello all!

Thanks Mudraker. Let me reframe the question again.
Here is the problem. I used a variable 'myfile' with th
getopenfilename application as follows for the user to browze pick
*.scompfinal file, as follows.

myfile = Application.GetOpenFilename("scompfinal files,*.scompfinal")
myfile could thus be n1m2.scompfinal,a1,b2.scompfina
etc...anything.....

But after I read the contents of this file to another existin
worksheet called 'vtec.xls', that already exists in the workbook,
would like to delete myfile (the just read-in file).

I am not able to select the myfile for me to copy the contents out o
that into 'vtec.xls'.
I tried the following two ways, to select the currently read-in myfil
but won't work, it'z giving me errors..

Worksheets("myfile").Activate, Sheets(myfile).Select etc.....

Thanks, would appreciate a reply.

Regds,
Arun................
Vtec Corp

--
Message posted from http://www.ExcelForum.com

Arun,

It is not the worksheet that is called myFile, but the workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"aiyer >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello all!
>
> Thanks Mudraker. Let me reframe the question again.
> Here is the problem. I used a variable 'myfile' with the
> getopenfilename application as follows for the user to browze pick a
> *.scompfinal file, as follows.
>
> myfile = Application.GetOpenFilename("scompfinal files,*.scompfinal")
> myfile could thus be n1m2.scompfinal,a1,b2.scompfinal
> etc...anything.....
>
> But after I read the contents of this file to another existing
> worksheet called 'vtec.xls', that already exists in the workbook, I
> would like to delete myfile (the just read-in file).
>
> I am not able to select the myfile for me to copy the contents out of
> that into 'vtec.xls'.
> I tried the following two ways, to select the currently read-in myfile
> but won't work, it'z giving me errors..
>
> Worksheets("myfile").Activate, Sheets(myfile).Select etc.....
>
> Thanks, would appreciate a reply.
>
> Regds,
> Arun................
> Vtec Corp.
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>