Template Save As

J

James Fedor

New Member
Joined
Apr 13, 2006
Messages
20
When you click save for the first time after starting a new workbook from an XLT template, the SaveAsUI defaults to the user's default file location. What code will force the SaveAsUI for one particular template to default to a specific directory? I thought this would be easy, but I'm having great difficulty.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
You must log in or register to reply here.

Similar threads

C
  • Solved
My code in BeforeSave is preventing the save???
Replies
5
Views
302
Clif McIrvin
C
D
  • Question Question
Generating Reports in Word Using Data in Excel
Replies
1
Views
286
Dan_W
D
K
  • Question Question
Disabling Save button (while enabling SaveAs) NO LONGER WORKS!!! (Insert cursing emoji here)
Replies
4
Views
302
kgartin
K
A
  • Solved
Using VBA to loop through multiple Word Templates and fill them in with Excel Data
2
Replies
14
Views
1K
John_w
J
B
  • Question Question
VBA to save as 'Excel Workbook' (not Macro enabled)
Replies
4
Views
904
frabulator
frabulator

Forum statistics

Threads
1,223,231
Messages
6,170,885
Members
452,364
Latest member
springate

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top