Katy Jordan
Well-known Member
- Joined
- Jun 28, 2008
- Messages
- 596
Hi, i have the following line of code saves file to the current path, i would like to save this to another location H:\Recs\Rec_Stats also i would like the file to save as month before so it should read Rec_Stats Feb-09
<TABLE style="WIDTH: 364pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=485 border=0><COLGROUP><COL style="WIDTH: 364pt; mso-width-source: userset; mso-width-alt: 17737" width=485><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 364pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=485 height=22>SaveCopyAs ThisWorkbook.Path & "\Rec_Stats " & Format(Date,"mmmm-yy") & ".xls"
</TD></TR></TBODY></TABLE>
<TABLE style="WIDTH: 364pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=485 border=0><COLGROUP><COL style="WIDTH: 364pt; mso-width-source: userset; mso-width-alt: 17737" width=485><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl66 style="BORDER-RIGHT: #f0f0f0; BORDER-TOP: #f0f0f0; BORDER-LEFT: #f0f0f0; WIDTH: 364pt; BORDER-BOTTOM: #f0f0f0; HEIGHT: 16.5pt; BACKGROUND-COLOR: transparent" width=485 height=22>SaveCopyAs ThisWorkbook.Path & "\Rec_Stats " & Format(Date,"mmmm-yy") & ".xls"
</TD></TR></TBODY></TABLE>