.xls save as .csv, but in a shared workbook

[Cougar]

Hello,

I've got the following macro that works perfectly when the workbook isn't shared. When I try and share the workbook, I get a method 'saveAs' of object '_workbook' failed error, that I cannot google a solution to.

Please Login or Register  to view this content.

Any help is greatly appreciated, as I need 3 guys to be working in this workbook all at the same time, but still retain access to the macro. As it is, we are having to yell out, "are you in the sheets?" - and I dislike sneakernet

Thanks again.

~C~

[Cougar]

I'm still looking for any help on this matter, thanks.