Thanks for your answer but I Want to open the worksheet in a vfp form. The code you gave me will open an excel workbook outside vfp.
Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Harvey Sent: Saturday, April 19, 2008 3:12 PM To: 'ProFox Email List' Subject: RE: Open a specific Excel worksheet inside a VFP Form If you know how to open 'a' worksheet, you should know you can open a specific excel document, which is your template. oexcel=CREATEOBJECT('excel.application') lcfile=GETFILE('xls') oexcel.Workbooks.Open(lcfile) oexcel.Visible=.t. JH -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Sent: Saturday, April 19, 2008 8:32 AM To: 'ProFox Email List' Subject: Open a specific Excel worksheet inside a VFP Form Hello All This is what I want to do: I want to open an excel worksheet in a vfp form the user will fill up data then I want to import back the information My problem is that I need to have a specific worksheet open. I know how to add a worksheet to the form I know how to import the excel data but I am not able to fill the opened worksheet with my "Template worksheet". Thanks for your answer [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/!&!AAAAAAAAAAAYAAAAAAAAAGXvpAt4R0FPkNj9Ft7KGBTCgAAAEAAAAEjRT0xZ18JNloB4cHzR/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
