VBA move and rename file issue

[anichols]

Hello all,

I have a fairly simple code that selects a source file and then moves it to a new location and renames it. My issue is, if I put the location directly in the code it works. If I try to use a cell reference that has the same location in the cell, it doesn't. Not sure why as similar functions using the identical cell reference seems to work.

Sub Prologue()
Dim OldName, NewName
'OldName = "P:\Servicing\Prologt.csv": NewName = "P:\Servicing - 2. Specific\Crest - 37\5. Reporting\c. Daily Reports\Prologue\2021\2021.03\2021.03.24\Prologt_03-24-2021.csv"
OldName = "P:\Servicing\Prologt.csv": NewName = (Sheets("DAILY02").Range("D6").Value)
Name OldName As NewName
End Sub

Any help would be greatly appreciated!

 

[Joe4]

What happens when you try this:

Sub Test()
    Dim OldName As String, NewName As String
    OldName = "P:\Servicing\Prologt.csv"
    NewName = Sheets("DAILY02").Range("D6").Value
    MsgBox (OldName = "P:\Servicing - 2. Specific\Crest - 37\5. Reporting\c. Daily Reports\Prologue\2021\2021.03\2021.03.24\Prologt_03-24-2021.csv")
End Sub

Does it return TRUE or FALSE?

 

[anichols]

What happens when you try this:

Sub Test()
    Dim OldName As String, NewName As String
    OldName = "P:\Servicing\Prologt.csv"
    NewName = Sheets("DAILY02").Range("D6").Value
    MsgBox (OldName = "P:\Servicing - 2. Specific\Crest - 37\5. Reporting\c. Daily Reports\Prologue\2021\2021.03\2021.03.24\Prologt_03-24-2021.csv")
End Sub

Does it return TRUE or FALSE?

False

 

[Joe4]

That means that the value you have typed in cell D6 is NOT the same as what you had hard-coded into the VBA code.
You have some difference between the two.
That may be the cause of your errors.

 

[anichols]

So I took the exact file path from the msgbox and pasted it into the cell. I reran the code and still returned false (which presumably should have returned true.)
One thing I've noticed twice when closing the file, is that even with no VBA running or paused, I will get a error popup saying run time error '9' Subscript out of range.