Record a macro where you save a file and select the filetype. As I recall, there is a constant that denotes the filetype.
John Harvey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Sunday, November 08, 2009 11:19 PM To: [email protected] Subject: Re: Importing from Excel 2007 Richard, thanks for jumping in. Unfortunately, the "saved as" file still does not want to be imported I issue the line oWorkbook.SaveAs('s:\Test2.XLS') How do I make sure this is an Excel 2003 file (or Excel 97 for that matter) S On Mon, Nov 9, 2009 at 5:02 PM, Richard Quilhot <[email protected]> wrote: > I don't believe there is any way to import a excel 2007 native file type. > What I did was to use ole via VFP to open the Excel 2007 do a save as excel > 2003 xls, then import that file into VFP. > you can then delete the 2003 xls file if you want to. > > Richard E. Quilhot C.N.A. > [email protected] > > > Stephen Leacock< > http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html> > - "I detest life-insurance agents: they always argue that I shall some > day > die, which is not so." > > On Sun, Nov 8, 2009 at 10:21 PM, Sytze de Boer <[email protected]> > wrote: > > > I need to update my system where my app does: > > > > appe from (xlfile) type xls > > > > I have a site where some users have Excel 2003, and some have gone to > > Excel2007 > > This creates problems. > > > > I've checked the archives and downloaded a system from Sweet Potato > > This pops up Select Data Source (and my clients will run away) > > > > It looks like I also need to read something that used to be with Advisor > > but > > I let the sub lapse > > I've tried to locate the author David Hagen but can't find him. > > > > Can I ask what my "profox buddies" are doing ?? > > > > -- > > Regards > > Sytze de Boer > > Kiss Systems > > Hamilton, NZ > > Ph: 64-7-8391670, Mob:64 21 937611 > > URL: www.kiss.co.nz > > > > > > --- StripMime Report -- processed MIME parts --- > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > --- > > [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/087301ca60fe$c0f7b7a0$42e726...@[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.
