B
Barbara
Problem Description: The default file location to open and
save files on our network is our S:\ drive. However, I
have one excel worksheet that, when completed, needs to be
saved to a different drive (E:\ drive). Unfortunately, no
one remembers to change the drive letter when saving these
special forms, so these worksheets, that our auditors look
for, are never saved in the correct location and makes
them difficult to find when needed.
I want to create a macro so that after completion of this
special auditing form, the user can click a hotkey
sequence (CTRL-X) and the form will automatically be saved
in the E:\ drive where it belongs, rather than defaulting
to the S:\ drive. However, I need to add a "pause" feature
into the macro so the user can name their file with a
unique name, but I don't know how to do this. The steps to
the macro include:
1. File
2. Save As
3. Select E:\ drive
4. name file (this is where I would need a pause feature
so the user can complete the filename information, then
continue with Step 5 of the macro)
5. Save
How can I add a pause in to a macro? Thanks for your help.
Barbara Scace
Director, Information Systems and Grants
save files on our network is our S:\ drive. However, I
have one excel worksheet that, when completed, needs to be
saved to a different drive (E:\ drive). Unfortunately, no
one remembers to change the drive letter when saving these
special forms, so these worksheets, that our auditors look
for, are never saved in the correct location and makes
them difficult to find when needed.
I want to create a macro so that after completion of this
special auditing form, the user can click a hotkey
sequence (CTRL-X) and the form will automatically be saved
in the E:\ drive where it belongs, rather than defaulting
to the S:\ drive. However, I need to add a "pause" feature
into the macro so the user can name their file with a
unique name, but I don't know how to do this. The steps to
the macro include:
1. File
2. Save As
3. Select E:\ drive
4. name file (this is where I would need a pause feature
so the user can complete the filename information, then
continue with Step 5 of the macro)
5. Save
How can I add a pause in to a macro? Thanks for your help.
Barbara Scace
Director, Information Systems and Grants