Thread: Save As Problem
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
mtm4300 via OfficeKB.com mtm4300 via OfficeKB.com is offline
external usenet poster
 
Posts: 43
Default Save As Problem

Many people will be using this program and it is not feasible for me to go
around to everyone's PC and disable the Windows Update.

When I click on my "Save As" command button a new workbook is created with
one sheet. If I close the copied workbook I get prompted to Save (YesNoCancel)
.. This is fine. However, when people click on a Save As button, they expect
to have their file saved already.

I would like to have the worksheet copied, and then the Excel Save As Form
appear. This will allow the user to type in a name for the workbook and also
let the user place it into any directory. Is this possible?

Patricia Shannon wrote:
A recent Windows update has caused problems for many people in opening and
saving files.
See the following for possible solutions:

http://www.microsoft.com/communities...1d7&sloc=en-us

http://www.microsoft.com/communities...21d&sloc=en-us

http://www.microsoft.com/communities...a-4b9fcf741916

I have a large workbook with hundreds of sheets. I have created a button on
each sheet to display a userform. On this userform, the user is allowed to

[quoted text clipped - 4 lines]
can copy the worksheet, but I am having trouble with the Save As function.
Can someone point me in the right direction? Thanks.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200604/1