I don't //know// enough about Access to know if it can change an Excel 2.0 spreadsheet to an Excel X.X version, but I suspect that it won't be able to do that. It can probably be done with a newer version of Excel, if you have that.
Will At 04:32 PM 5/16/2008, you wrote: >Sorry about the confusion >I am in Access and I want to have the code open up various spreadsheets >that are version 2.0. Save them to a higher version of Excel. I get these >spreadsheets downloaded from Hyperion (which only export to excel in 2.0). >The reason: >We transfer these spreadsheets into Access as tables and then copy each of >the tables out to other databases on the network. >We do this because they will not give us an odbc driver for peoplesoft. >I hope that this explains it better. If not let me know. > >Jim Wagner > > > >----- Original Message ---- >From: Willard Seehorn <[EMAIL PROTECTED]> >To: [email protected] >Sent: Friday, May 16, 2008 12:36:54 PM >Subject: Re: [ms_access] Repost: How do I open and save a worksheet using >access > > >I'm not clear on what you want > >Do you mean that you are in Excel, working in worksheet 1, you want to >click on a button in worksheet 1, automatically open worksheet 2 and then >have the same button click save work sheet 2? > >Why? > >Will > >At 02:53 PM 5/16/2008, you wrote: > >Hello User Group, > > > >I am reposting this because no one posted any messages back. I want to > >open an excel worksheet from a button and then save it. Can this be done? > > > >Jim Wagner > > > > > >----------- --------- --------- ------- > > > >Yahoo! Groups Links > > > > > > > >No virus found in this incoming message. > >Checked by AVG. > >Version: 8.0.100 / Virus Database: 269.23.16/1446 - Release Date: > >5/16/2008 7:42 AM > >[Non-text portions of this message have been removed] > > > > > > >[Non-text portions of this message have been removed] > > >------------------------------------ > >Yahoo! Groups Links > > > >No virus found in this incoming message. >Checked by AVG. >Version: 8.0.100 / Virus Database: 269.23.16/1446 - Release Date: >5/16/2008 7:42 AM [Non-text portions of this message have been removed]
