Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SaveAs Method to Save Excel Worksheet

Status
Not open for further replies.
dmposey61

dmposey61

Technical User
Mar 26, 2004
11
US
I want to automatically save an updated excel worksheet to a particular folder on a network drive. I tried using the SaveAs method but I cannot seem to get my path to work.

Can someone please help me with the code to save a document with the path name so each individual does not have to do a manual "File - Save As" each time.

Thank you!
 
Status
Not open for further replies.

Similar threads

ladyck3
  • Locked
  • Question
Excel 365 - Working with Tables - Calculating data from one worksheet to another. 2
2
Replies
30
Views
459
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
863
shytott
shytott
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
291
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
287
combo
combo
Rick_Stanich
  • Locked
  • Question
Save active Excel file to new location
Replies
6
Views
130
Rick_Stanich
Rick_Stanich

Part and Inventory Search

Sponsor

Back
Top