View Single Post
  #8  
Old March 12th 07, 08:20 PM posted to microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,156
Default How to have Outlook create folder if folder is not present?



This works without refs but you won't have help by IntelliSense:

Dim fso as Object
Set fso=createobject("Scripting.FileSystemObject")

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
The most effective way to assign Outlook categories:
http://www.shareit.com/product.html?...4&languageid=1
(German: http://www.VBOffice.net/product.html?pub=6)


Am Mon, 12 Mar 2007 12:14:49 -0400 schrieb StargateFanFromWork:

"StargateFan" wrote in message
...
On Fri, 9 Mar 2007 18:18:18 -0500, "Ken Slovak - [MVP - Outlook]"
wrote:

[snip]

Make sure you have a reference set to IWshRuntimeLibrary
(C:\WINDOWS\system32\wshom.ocx) in Tools, References


Thanks very much for the script. No wonder I wasn't getting the
recommendations given to work, too much needed to be done that I
didn't know about! g

I searched for this wshom.ocx file and I have this in the system32
fldr, just as you say, so that part will be okay.

"References", however, is missing from my Tools menu. I just did an
MS KB search and even though I haven't found anything so far related
to this


(http://support.microsoft.com/search/...%3D1033&spid=2
557&query=references+menu+missing&adv=&mode=r&cat= False),
I did find out how to add things via this article
http://support.microsoft.com/kb/264625/en-us which I'm hoping will
help me get this option. What I don't have installed for O2K turns
out to be these 3 items:

- Collaboration Data Objects
- Electronic Forms Designer Runtime
- Symantec Fax Starter Edition (Internet Mail Only Configuration)

The last one seems highly unlikely and the 2nd one somewhat unlikely
to have anything to do with this missing menu item, but would the
first item give me that option in Tools, by any chance? I don't know
how else to get it on the Tools menu.

Oh, I'm guessing it would be good to mention that I install O2K as
Corporate or Workgroup mode (because that works best for me). g
Don't know if that has anything to do with this.

tia! D


Trying again. As I mentioned on Friday, "References" doesn't appear in my
Tools menu.

I went ahead just now and tested this macro out anyway. Sure enough, it
doesn't work. I imagine it's because of the things above that I must do

but
can't yet.

When I click on the button to which I attached the above script, it goes
into the vbe and says:

"Compile error:
User-defined type not defined"

and this "objFSO As Scripting.FileSystemObject" gets highlighted in

yellow.



tia for help in resolving this. D
(I have O2K on Win2K here at the office)

Ads
 

Mortgage - NFL Forum - Loans - Wills - Daily funny video