- ©«¤l
- 913
- ¥DÃD
- 150
- ºëµØ
- 0
- ¿n¤À
- 1089
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- office 2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-8-28
- ³Ì«áµn¿ý
- 2023-7-19
|
¦^´_ 5# hugh0620
±z¦n,
±zק諸²Ä¤@½g¥i¥HÂà´«¤å¦r,¦ý¶È©ó¦P¤@sheet¤¤ªº¤å¦r.
²Ä¤G½g§ÚפF(*.xlsx),¦]¬°§Ú·Qn¤GºØÀÉ®×Ãþ«¬³£¥i¥H¥Î,¦ýµL½×§Ú§ï¦¨ (*.xlsx), *.xls" ©Î (*.xls), *.xlsx",·í§Ú«öÂà´«¶s®É¨Ã¤£·|¤GºØÃþ«¬³£¥X²{,¦Ó¥B¨C¦¸«öÂà´«¶sexcel´N·|·í±¼,
¦pªG§Ú¤@ª½¤£¥h²z¥¦,¨ä¹êexcel¤]¤£¥Î«¶},¦ý¥¦¨Ã¤£·|Âà´«.
patch = Application.GetOpenFilename("Microsoft Excel ¬¡¶Ã¯ (*.xlsx), *.xls")
¥t¥~½Ð±Ð¤@Ó¦sÀÉ°ÝÃD,¥H¤U¦s¬°.xlsx®É¤@¤Á³£¨S¦³°ÝÃD,¦ýY¦s¦¨.xls®É,¦sÀɮɨS°ÝÃD,¦ýn¥´¶}¦sÀɫ᪺¤å¥ó´N·|¥X²{¿ù»~°T®§,¥i§_À°§Ú¬Ý¤@¤U°ÝÃD©Ò¦b?
ActiveWorkbook.SaveAs "D:\" & [Q5] & " vs " & [C6] & "_PO#" & [V7] & "_" & [C16] & " booking to " & [C19] & ".xlsx"
|
|