This is the code that I have in Excel to save the sheet. when I put the code in
access it does not work.
Workbooks.Open Filename:="W:\DATA MANAGEMENT SERVICES\MASTER PEOPLESOFT
TABLES\R&D-ACCRUALS.xls"
Workbooks("R&D-ACCRUALS.xls").Activate 'Accruals
ActiveWorkbook.SaveAs Filename:= _
ActiveWorkbook.FullName _
, FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
Application.Wait (Now + TimeValue("0:00:01"))
ActiveWorkbook.Close False
Application.Wait (Now + TimeValue("0:00:01"))
Jim
----- Original Message ----
From: Willard Seehorn <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, May 16, 2008 1:57:32 PM
Subject: Re: [ms_access] How do I open and save a worksheet using access
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] net>
>To: [EMAIL PROTECTED] ps.com
>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]
[Non-text portions of this message have been removed]
