View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sdharris - ExcelForums.com sdharris - ExcelForums.com is offline
external usenet poster
 
Posts: 1
Default 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