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
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