make text file of a shared workbook

Hello all,
I am trying to make a Text Tab Delimited copy of an Excel workbook. The plan is to set up a Windows Task Scheduler task to open the spreadsheet overnight and run the macro to create the text file. My VBA works fine until I make the workbook shared, then I get a Run Time 1004 error: Method 'SaveAs' of object'_Workbook' failed. The code works when the document is not shared. I am able to manually Save As to a text file while worksheet is shared, but cannot seem to do it via macro. I tried adding a ling of code to unshare the workbook before Save As, which works, but then when I reopen the original file, it is no longer shared, even though nothing in the code says to save the original file. Below is what I have. Any ideas?

Please Login or Register  to view this content.