Hi Matt
I do not know how to work with files in Office 97.
Do a file search on your computer for a file called scrrun.dll. Should be in system folder. Microsoft Scripting Runtime
If you have it, I can help you.
If not then someone else will...
Tom
Sub MoveFiles()
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
'creates the destination directory if it does not exist
fso.MoveFolder "C:Current", "C:Saved"
End Sub
Tom
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.