Maybe like this: Hey, Scripting Guy! How Can I Connect to a Folder When There’s an Apostrophe in the Folder Name? (look at the last bit of code at the bottom)
Quote:
For example, if you want to know the size of Ken Myer’s Folder, use this code:

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder("C:\Ken Myer’s Folder")
Wscript.Echo "Size: " & objFolder.Size