Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button help!!
Hi, I have been asked to create a button, when pressed it ask to save as to a
specific location, once saves I then need to to save again to a specific locaion. Please help gurus. Neil. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro button help!!
Try the below macro
Sub Macro() Dim intCounter As Integer, strFile As String Do While intCounter < 2 With Application.FileDialog(msoFileDialogSaveAs) .InitialFileName = "C:\" .Show strFile = .SelectedItems(1) End With ActiveWorkbook.SaveCopyAs strFile intCounter = intCounter + 1 Loop End Sub If this post helps click Yes --------------- Jacob Skaria "Neil Holden" wrote: Hi, I have been asked to create a button, when pressed it ask to save as to a specific location, once saves I then need to to save again to a specific locaion. Please help gurus. Neil. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop running macro button, like Ctrl-Break button | Excel Programming | |||
Stop running macro button, like Ctrl-Break button | Excel Programming | |||
Stop running macro button, like Ctrl-Break button | Excel Programming | |||
Can't select macro button after other button is pressed | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |