SaveAs

  • Thread starter Thread starter Hayman
  • Start date Start date
H

Hayman

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

Hayman
 
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
 
I think the English from Fergus too, never doubt of that, I thought he lives
in Oxford England.
 
Hello,

Fergus Cooney said:
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?
Click to expand...

A: Ask in the Excel ng:

news://news.microsoft.com/microsoft.public.excel.programming

Regards,
Herfried K. Wagner
 
Hello,

Hayman said:
How to overwrite an existing file without asking the user if he wants to
overwrite it or not?
Click to expand...

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

HTH,
Herfried K. Wagner
 
Back
Top