I am trying to get a macro to run correctly on Excel 2000. Currently it gives me an error. I am not sure what needs to be done as this isn't my code, rather something I found in response to my VP wanting to track versions.
Code is attached below. I'm getting a compile error, "Sub or Function not defined"on the line [I]If FileExist(FolderPath & SaveName & SaveExt) = False Then[I] Which means I likely have the same problem with a similar line further down the macro.
I assume that the issue is the FileExist as that doesn't seem to exist in Excel 2000 VBA. There is a FileExists but that doesn't solve the problem. I am unsure where to go from here to make this work in 2000. I just don't know enough to be able to resolve this one on my own.
Any input or suggestions will be very gratefully accepted.
Thanks,
Bill
Please Login or Register to view this content.
Bookmarks