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