Saving only the current, active workbook

Hi SimGin,

Try this instead...

Please Login or Register  to view this content.

abousetta

try to remove this line and see whether you can run the macro

ThisWorkbook.ActiveSheet.Copy

Hi SinGin,

Is this thread a continuation of another thread http://www.excelforum.com/excel-prog...worksheet.html ? If so, please close one of them so are not responding to the same question on multiple threads.

abousetta

Thanks a lot for your help, it's still not quite working like I was hoping though.

The code you provided doesn't run all the way and the debugger calls up this line -->wb.SaveAs DstFile 'Save file

Your second suggestion (to remove that one line from the original code) saves the entire spreadsheet to include all workbooks. What I need is for it to save only the current sheet, but not to exit the original spreadsheet because I need to save other parts of it separately.

It is a continuation of another post. I had actually marked it as solved at one point before I realized it wasn't quite working and since it was old it didn't seem like it was getting any suggestions after I marked it "unsolved" for lack of a better term. I'd be more than happy to close the original and have tried, but for the life of me can not figure out how. As much as you've helped me already I hate to even ask, but can you tell me how to close a post?

Hi SinGin,

Could you post a dummy workbook? The code works fine on my computer, and I don't know why its not working on yours. Also could you tell me what the error message says.

abousetta

Hi SinGin,

Try adding this to the top of top of the code I sent you after the declarations:

Please Login or Register  to view this content.

Let me know if it works.

abousetta

Hi SinGin,

I tried the following code out on a dummy workbook and it seems to work.

Please Login or Register  to view this content.

abousetta

Abousetta, you're a genius! Thanks a lot man, really. I realize why they weren't working for me. The macros I built would change the name of a few sheets and hide a few and for some reason the code you wrote didn't like that. Once I took that part of my code out it worked great! I used the last code you gave me and it worked perfectly, the other solutions might work for me now too but I haven't had a chance to try them yet. Thanks again.

Hi SinGin,

All the code I have provided you with was created through the help of good people on this site and other similar sites. I am only an amateur at writing code and am just trying to help others whenever I can. I'm glad the code worked for you as it has worked for me.

Good luck,

abousetta