Saving Excel Files to Two drives

[The Shadowman]

Hi I am a first time poster so forgive me if I am not posting in the correct area.

I have for many years been using Excel 97 and created many successful macros to save files to c: and my backup drive at the same time. However, I have just upgraded to Excel 2019
and when I create a macro to save to C: and my backup drive, It saves to the backup drive, but not to C:

Does anybody have a clue to why this does’t work. A straight forward macro saving to C: works correctly

Thanks for any advice given

Robert

 

[Logit]

Are you saving to a specific FOLDER on the C Drive ... or directly to the root C Drive ?

I've had issues in the past having files saved to the C Drive here. It appears MS Windows doesn't like that ... wants to protect the C Drive for some reason.

 

[The Shadowman]

I am saving to a specific drive on C: ,but it doesn’t work. the backup that does work is a usb external drive

 

[Logit]

Guess you should post your code. Perhaps there is something there ?

 

[Logit]

For reference ... I created a Folder on my C Drive and named it "Test". Then I used this macro to save an .XLSB workbook to that folder :

Option Explicit

Sub SaveBookAs()

Dim Path As String
Dim filename1 As String

Path = "C:\Test\"   '<-- edit path as required
filename1 = Range("A1").Text

Application.DisplayAlerts = False

    ActiveWorkbook.SaveAs Filename:=Path & filename1 & ".xlsb"
    
Application.DisplayAlerts = True

Application.Quit
Application.Visible = False

End Sub

 

[The Shadowman]

Thank you. I think I have solved the problem. I had pasted a portion of an XLSX file into an XLS file and consequently the file would not save in the normal way. I suspect it is something to do with ”compatibility mode”. It’s beyond me, but I got there in the end. Thank you for help