I am using office 2011 for mac, the forms that I wish to extract are as attached, about 50 of them all in one folder. I am sure that I have got this to work in the past, trying again today I cannot get it to work.
When I use macropod's VB above, I get a runtime error saying that Activex cannot create an object, and debug takes me to the line:
Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0)
I'd appreciate any advice "for dummies", even things like where to put correct paths etc.
