Re: Argomenti di Save per excel

Article View: free.it.visual-basic

Article #3651

Back to free.it.visual-basic Previous Next

#3651

From: Roscio
Date: Tue, 21 May 2002 11:56

28 lines
1985 bytes

"AccessDenied" <access_deniedTOGLIMI@katamail.com> wrote in message
news:%EEv8.57200$m41.1479441@twister2.libero.it...
> scusate la banalit� della domanda ma mi son dimenticato gli argomenti da
> passare al comadno
>
> dim Obj As new Excel.Application
> Obj.Activeworkbooks.Save "??","??"

E si vede proprio che ti sei dimenticato !... :-)))

Il comando Save non ha parametri, in quanto salva
il modulo corrente con i settings attuali.

Forse ti riferivi al comando SaveAs che ha i seguenti parametri:

SaveAs(Filename, FileFormat, Password, WriteResPassword,
                ReadOnlyRecommended, CreateBackup, AddToMru,
                TextCodePage, TextVisualLayout)

Esempio:

ActiveWorkbook.SaveAs Filename:="C:\MiaDir\MioFile.xls",
                FileFormat:=xlNormal, Password:="", WriteResPassword:="",
                ReadOnlyRecommended:=False, CreateBackup:=False

--
Er Roscio.

Technical Details

Message-ID: <DjrG8.90348$5k4.2029329@twister2.libero.it>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news.maxwell.syr.edu!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail

References: <%EEv8.57200$m41.1479441@twister2.libero.it>

Show Full Headers

Complete Article Headers

X-Google-Language: ITALIAN,ASCII
X-Google-Thread: f94ee,5363117ef371bfba
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2002-05-21 05:45:27 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!207.217.77.43.MISMATCH!newsfeed1.earthlink.net!newsfeed.earthlink.net!news.maxwell.syr.edu!nntp.infostrada.it!twister2.libero.it.POSTED!not-for-mail
From: "Roscio" <sergint@libero.it>
Newsgroups: free.it.visual-basic
References: <%EEv8.57200$m41.1479441@twister2.libero.it>
Subject: Re: Argomenti di Save per excel
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Message-ID: <DjrG8.90348$5k4.2029329@twister2.libero.it>
Date: Tue, 21 May 2002 13:56:10 +0200
NNTP-Posting-Host: 151.29.23.177
X-Complaints-To: abuse@libero.it
X-Trace: twister2.libero.it 1021985123 151.29.23.177 (Tue, 21 May 2002 14:45:23 MET DST)
NNTP-Posting-Date: Tue, 21 May 2002 14:45:23 MET DST
Organization: [Infostrada]

Reply to Parent Message