>>Hi.
>>
>>i hv try your method. But it seems that it is better to use to create a excel file. But if i already hv a excel file and want to read it data. I've try to searching in MSDN, and following the syntx. But some error occurs. Something like "Remote Server does not exist".
>>Is that any other method to open an excel file and get the data to the text field?!
>
>Instead of XL.Workooks.Add, see the help file for XL.Workbooks.Open. You can also look at the GetObject function.
See this link:
http://msdn.microsoft.com/library/techart/offaut.htm
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com