hello, i am new to this forum. hope i find good help and hope i can help others.

Well, i am coding a vbscript to copypaste stuff form one xls file to other depending on some criteria.

now the file1.xls is password protected and i m not able to open it automatically. excel opens and prompts me for the password.

i tried this
http://www.excelforum.com/excel-prog...matically.html
but sadly didnt help me.

also i write code in notepad and save it as .vbs file and double click to execute.

Now even if i type a simple statement "Dim FileName as String" and try to execute file it gives me error "expecited end of statement"
but just this works :-
Dim Filename
Filename="blahblah"

I'm using windows XP and executining it in WSH environment.

can someone please help me with this?
thanks a lot.