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

folderexists code no longer works after moving to excel 2003
 

sdharris - ExcelForums.com shared this with us in
microsoft.public.excel.programming:

Folks,

I have a spreadsheet with a macro that checks for two folders on the
local disk before starting. It works fine on Excel XP and lower but
on 2003 this one line causes an error messages "object variable or
with block variable not set"

If Not fs.folderexists("c:\temp") Then

If I omit the if statement knowing that the folder exists the FS
object functions perfectly for other tasks and the object is created
in earlier code within the same function.

Any ideas?

Cheers

It's difficult to comment on your code without context. It's probably
something with the FileSystemObject but you really need to show more
code.

--
Amedee Van Gasse using XanaNews 1.17.4.1
If it has an "X" in the name, it must be Linux?