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]
