SaveAs

[Hayman]

Hello,
How to overwrite an existing file without asking the user if he wants to
overwrite it or not?

Hayman

[Fergus Cooney]

Hi Hayman

I just want to state a possible interpretation of your query - judging from
the other two questions of yours

|| I was wondering if there is a way to send
|| an excel sheet as an attached
|| file without sending this file to outlook

and

|| I'd like to insert a jpg file in an excel sheet
|| Can you help me please in that?

I'm guessing that you mean

Q: How do I get Excel to save and overwrite an existing file without asking
the user if he wants to
overwrite it or not?

[I'm leaving the answering to the others. :-)]

Regards,
Fergus

[Cor]

I think the English from Fergus too, never doubt of that, I thought he lives
in Oxford England.

[Herfried K. Wagner [MVP]]

Hello,

"Fergus Cooney" <fi******@tesco.net> schrieb:

I just want to state a possible interpretation of your query
- judging from the other two questions of yours

|| I was wondering if there is a way to send
|| an excel sheet as an attached
|| file without sending this file to outlook

and

|| I'd like to insert a jpg file in an excel sheet
|| Can you help me please in that?

I'm guessing that you mean

Q: How do I get Excel to save and overwrite an existing file without
asking the user if he wants to overwrite it or not?

A: Ask in the Excel ng:

news://news.microsoft.com/microsoft....el.programming

Regards,
Herfried K. Wagner
--
MVP · VB Classic, VB .NET
http://www.mvps.org/dotnet

[Herfried K. Wagner [MVP]]

Hello,

"Hayman" <ha****@boozallen.com> schrieb:

How to overwrite an existing file without asking the user if he wants to
overwrite it or not?

\\\
Dim o As SaveFileDialog
o.OverwritePrompt = False
If o.ShowDialog(Me) = DialogResult.OK Then
...
Else
...
End If
///

HTH,
Herfried K. Wagner
--
MVP · VB Classic, VB .NET
http://www.mvps.org/dotnet

[Hayman]

Thank you so much Ken
This really worked, your help is appreciated
Hayman

"Ken Tucker" <vb***@bellsouth.net> wrote in message
news:eJ**************@TK2MSFTNGP12.phx.gbl...

Hi,

Set the excel.application variable displayalerts property to false. Here is a link on how to automate excel
http://support.microsoft.com/default...b;en-us;301982.

Dim oXL As Excel.Application

Dim oWB As Excel.Workbook

Dim oSheet As Excel.Worksheet

Dim oRng As Excel.Range

' Start Excel and get Application object.

oXL = CreateObject("Excel.Application")

oXL.Visible = True

' your code to automate excel goes here

oXL.DisplayAlerts = False

oSheet.SaveAs("C:\Test.xls",
FileFormat:=Excel.XlFileFormat.xlXMLSpreadsheet)

oSheet = Nothing

oWB = Nothing

oXL.Quit()

oXL = Nothing

Ken
-------------------
"Hayman" <ha****@boozallen.com> wrote in message
news:OM**************@TK2MSFTNGP12.phx.gbl...

Hello,
How to overwrite an existing file without asking the user if he wants to
overwrite it or not?

Hayman