Select a browze picked file and copy Read contents into a work sheet!

  • Thread starter Thread starter aiyer
  • Start date Start date
A

aiyer

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
 
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)
 
Back
Top