do what Bob said. After the error go to Tools=References in the VBE and
resolve the reference that is shown as MISSING.

--
Regards,
Tom Ogilvy


"AmyTaylor" wrote:


Hi both, tried pasting again as suggested, it still doesnt work, it gets
stuck at the word Left on the line
FolderName = WbMain.Path & "\" & Left(WbMain.Name, Len(WbMain.Name) -
4)

Sorry to be a pain !
Amy xx


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=539200