Not saving as new workbook without Save As window

[kienfred]

Greetings all,

I am working on "Planning" Workbook which will copy the completed Plan (Sheet) to a new workbook and save this new workbook to a network drive. The new work books name is based on a couple of cells from the original Planning Workbook. I have tried all suggestion I have come accross the various forums but it always opens the "Save As" Window. I do not get errors, filepath and file name variables are accurate.

Can anybody help out with this please?

[TMS]

Welcome to the forum.

How would you have us help you? No workbook, no worksheets, no data, no code, no process outline, ...

I have tried all suggestion I have come across the various forums

... so, what would the suggestions you have tried look like?

Regards, TMS

[kienfred]

Hello TMS,

All I am looking for is the code to save a New Workbook which contains the Copy of the sheet with the Planning sheet of the original Workbook. All this works, I get a new Workbook with the copy of the desired sheet. Only when it comes to the saving part I am not sure how to get this done without opening the "Save As" window.

Cheers

[TMS]

Maybe:

Please Login or Register  to view this content.

[kienfred]

Hello TMS,

Running the code below will show the "Sava As" Window. I would like no user input for saving this file. I have the File path commented out for now, chDir also. Any suggestions?

Please Login or Register  to view this content.

[TMS]

Check the syntax of the SaveAs (see my previous post)


http://msdn.microsoft.com/en-us/libr...ffice.15).aspx



Regards, TMS

[kienfred]

Hello TMS,

You are absolutely right, my appologies but correcting the syntax still does not eliminate the "Save As" Window. I have tried everything I could find and nothing has stopped the window from coming up. What I can say is that if I save "ThisWorkBook" it will save without the window but I need to save the NewBook!

Please Login or Register  to view this content.

[kienfred]

Anybody can help with this?

[TMS]

Suggest that you post a sample workbook (as I hinted in my original response).

[kienfred]

Thank you TMS,

My issue has been resolved!

Cheers

[TMS]

What was the solution?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[kienfred]

Hallo TMS,

The workbook has in the Project Window 2 more projects showing (Not the Personal WB) even only one Excel session was running. By stepping through my Code i was taken to the "other Project". I commented out the code of the other Projects resaved my file and now I can run my Code. I am not sure of the purpose of those projects which appear in any Excel session. Well, except one!

Cheers!

[TMS]

Did you try

Please Login or Register  to view this content.

Regards, TMS