- ©«¤l
- 124
- ¥DÃD
- 43
- ºëµØ
- 0
- ¿n¤À
- 167
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows7
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2011-3-16
- ³Ì«áµn¿ý
- 2021-10-7
|
³Æ¥÷¸ê®Æ
¥¦w
¨C¶g¤³£n³Æ¥÷¸ê®Æ
¦p¦óÅýÀɮרC¶g¤¦Û°Ê°õ¦æ©O
Sub Backup()
FileDate = Format(Date, "yyyymmdd") ' ¦~¤ë¤é®æ¦¡¦@8ӼƦr(³Æ¥÷)
ActiveWorkbook.SaveCopyAs Filename:= _
"\\Web_server\pcmac¥æ´«°Ï\³Æ¥÷\" & FileDate & ".xls"
End Sub |
|