|
-
Oct 11th, 2000, 09:05 AM
#1
Thread Starter
Lively Member
Hi,
I' ve got a problem zith excel '97.
I' ve opened a text file in excel,
made some changes and want to do a save as
from the open file with the same name but
with an other fileformat. The code works but
excel application comes with a msgbox, asking
if I'm sure a want to save the file, because
it already exists. How can I catch that msgbox?
I don't want the user to see this msgbox.
What do I have to do...? Can anybody help me
with this little problem?
This is a piece of my code
appExcel.ActiveWorkbook.SaveAs _
FileName:=TextFile, _
FileFormat:=xlTextWindows, _
CreateBackup:=False, _
Accessmode:=xlExclusive, _
ConflictResolution:=xlLocalSessionChanges
appExcel.ActiveWorkbook.Close _
Savechanges:=False
appExcel.Application.Quit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|