>hello,
> I am having problem with the following command with micro substitution. Could anyone help me out??
>
> oExcel = createobject('Excel.Application')
> With oExcel.Workbooks.Open(&SOURCE_FILE)
>
>It works find if I substitute "&source_file" with getfile() to open the file everything works. thanks.
>sherry
Sherry, you don't need macro substitution in here.
source_file = "book1.xls"
oExcel.Workbooks.Open(source_file)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison