LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet SUM(C:C) or indeed any SUM no longer works Excel 2003 knowq.biz/video.htm Excel Worksheet Functions 14 November 13th 06 03:19 PM
Excel 2003 Issue with UsedRange.Copy (code works in Excel 2002) TechFirm Excel Programming 4 January 21st 05 01:53 AM
Office 2003 - "autocomplete" in file | open or file | save no longer works Lanwench [MVP - Exchange] Excel Discussion (Misc queries) 4 January 12th 05 01:35 AM
VB6 Excel 97 code no longer works if Win2K SP3/4 applied. Tim R[_3_] Excel Programming 5 October 10th 04 06:24 AM
Macro no longer works now that in Excel XP C.B.[_2_] Excel Programming 0 December 14th 03 09:49 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"