From: macronewbie on 6 Jun 2010 00:41
Just would like to ask help on how to automatically save a created file just
by the use of command button.
I have below macro code:
Dim sh As Worksheet
Set sh = ActiveSheet
On Error Resume Next
On Error GoTo 0
I want to "save as" the generated new workbook automatically when I click
the command button to create the new wokbook. Is this possible? THANKS!
From: Project Mangler on 6 Jun 2010 06:18
"macronewbie" <macronewbie(a)discussions.microsoft.com> wrote in message
> I want to "save as" the generated new workbook automatically when I click
> the command button to create the new wokbook. Is this possible? THANKS!
Not sure if you want to be able to choose a path and filename. This is a
Prev: Actively select cells/ranges/sheets and Paste Link
Next: Most Recent Custom View