I am using this to save a workbook, but was hoping that it would not ptompt me but to just save.
I am using 2003 right now. Anyone to bypass the msgbox that asks me what directory and oka to save??HTML Code:
I am using this to save a workbook, but was hoping that it would not ptompt me but to just save.
I am using 2003 right now. Anyone to bypass the msgbox that asks me what directory and oka to save??HTML Code:
If you merely want to save the workbook then
![]()
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you so much - did not think it was that easy!!!
JUst tried it - already ahd the macro up and ready to start playing with it when your reply came in -thank you again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks