folderexists code no longer works after moving to excel 2003
Folks,
I have a spreadsheet with a macro that checks for two folders on th
local disk before starting. It works fine on Excel XP and lower bu
on 2003 this one line causes an error messages "object variable o
with block variable not set"
If Not fs.folderexists("c:\temp") Then
If I omit the if statement knowing that the folder exists the F
object functions perfectly for other tasks and the object is create
in earlier code within the same function.
Any ideas?
Cheer
|