Member Avatar for huaso

Hi!

I need help for somethig I guess is very simple:

I have a file that needs to be replaced with the same name. I'm saving it with the following code:

ActiveWorkbook.SaveAs Filename:="\GA\temp\AR.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

But there is a file in that location with the same name, which is the one that I need to replace. And it wil always be like that.

I need to know how to get rid of the warning that asks me if I want to rplace the existing file or not.

Thank you!

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by iamthwee
Member Avatar for iamthwee

Can't you delete the file first then write it again with the same file name?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.