Creating Seperate workbooks from origional Workbook

Hey, I have a Workbook which is an information sheet. I have it so it 9 sepearte worksheets, which I bring copy over into seperate workbooks and thensave then as a CSV file on my Desktop. Now, I have a code which works perfect that i recorded, but im cleaning it up so it is much nicer: now i keep getting an error at: Dim lCalc As XlCalculaion.... If anyone can give me a hand greatly appreciated. I just started work with VBA, so im still new.

thanks,

Please Login or Register  to view this content.