Here's a snippet:
ActiveWorkbook.SaveAs Filename:="C:\Users\QuilhotR\My Documents\Book1.xls",
_
FileFormat:=xlExcel9795, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
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 Mon, Nov 9, 2009 at 12:18 AM, Sytze de Boer <[email protected]> wrote:
> 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/[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.
