Hello everyone I have the answer to my problem now, I am posting this for those that don’t have an answered or are having the same problem I was having too for running this macro staff!!
I started by trying and running through the following steps on your computer and see if that helps?
Download comdlg32.ocx from http://windowsxp.mvps.org/comdlg32.htm
and put it in C:\windows\system32
Then run regsvr32 c:\windows\system32\comdlg32.ocx from Start>Run
The errors I saw have been reported before, and it’s usually due to this file being missing.
Hope this will help everyone that is having the same problem as me