Hi Pro,
May I know that what coding should I write for display a excel file by using vb code?Please teach me or give some example for me.
Waiting for your advices...

Thank you.

Hi ivanlaw

Do you want to show the Excel Sheet on your userform or code?


If you want to show the Excel you have used in the program then set the Application.Visible option to True

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,

Thanks for your helping.It is works.

Hi there,

I got one more thing need to ask which is how to copy a file to another place by using vb coding???
Please teach me...--'
Waiting for your advices

Thank you.

hi there.. there is a copyfile function you can use to do it... of you can use the filesystemobject...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Here are the methods you can use

Dim FSO As FileSystemObject

' You need to add Microsoft Scripting Runtime library to access the FileSystemObject
Set FSO = New FileSystemObject


' Copy without overwriting files
FSO.CopyFile "c:\temp.xls", "d:\temp.xls", False

' Copy with overwriting files
FSO.CopyFile "c:\temp.xls", "d:\temp.xls", True

' Without using File System Object
FileCopy "c:\temp.xls", "d:\temp.xls"


http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)