Excel ¶×¥X¦¨csvÀÉ + csvÀÉÀɮפj¤p®t²§
- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
Excel ¶×¥X¦¨csvÀÉ + csvÀÉÀɮפj¤p®t²§
Dear ¤j¤j!!
³Ìªñ¦b·d¸ê®ÆÂà¨ÓÂà¥h¡A¥t¦s¦¨ .CSVªº®æ¦¡¡A
¦pªG¬Oª½±µ±qEXCEL¦s¦¨ .CSV®æ¦¡¡AÀÉ®×·|Åܫܤj!!
¦ý¼t°Ó¡Aµ¹ªº.CSV Àɮ׫ܤp¡C
¹Á¸Õ¥Î¥t¦s·sÀÉ¡A¦ý¤@ª½¨S¦³¦¨¥\¡A°ÝÃD¦p¤U¡G
1¡BcsvÀɮפj¤p¡Gtest01¡Btest02¡A¤º®e¤@¼Ë¡A¦ý¬OÀɮפj¤p®t«Ü¤j¡A¬O¬Æ»òì¦]©O? (Ó¤H²q´ú¬OcsvªºÀÉ®×°ÝÃD¡GMacintosh CSV¡BMSDOS CSV¡BWindows CSV)
test_01.zip (1.12 KB)
test_02.zip (3.16 KB)
2¡B¶×¥Xcsv¡G¦b¹Á¸Õ±qexcel Âà´«ÀɮסA±N¨ä¤¤¤@ÓsheetÂà¥X¥t¦s¦¨csvÀÉ (¥B¬OnÂন¹³test01À£ÁYÀɤj¤pªºcsvÀÉ)
¦ý¤@ª½¥d¥dªº¡A
½m²ßÀÉ_¸ê®Æ¶×¦¨csvÀÉ.zip (83.43 KB)
- Private Sub CommandButton3_Click() '¶×¥X¸ê®Æ
- NA01 = "test"
- Sheets("¸ê®Æ").Select
- Sheets("¸ê®Æ").Copy
- ActiveWorkbook.SaveAs Filename:="D:\Users\Hugh\Desktop\" & NA01, FileFormat:=xlCSV
- End Sub
½Æ»s¥N½X ½Ð¤j¤j«üÂI¤@¤U!! |
|
¾Ç²ß¤~¯à´£¤É¦Û¤v
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-23
|
[¸ê®Æ]¤u§@ªí³Q[®æ¦¡]¦ûº¡¤F1000¦æ,
Âà¥Xªºcsv¥]§t¤F¤@°ïªÅ®æ,
¥i¥Î[°O¨Æ¥»]¬Ý¤@¤U text_02, ¥kÃä¤Î¤U¤è¤@¤j°ï³r¸¹,
·íµMÀÉ®×´N¤j¦h¤F!
¥i¿ï¨ú¾ã±i¤u§@ªí, ²M°£¥þ³¡ªº®æ¦¡³]©w, ¦A°õ¦æÂàcsv |
|
|
|
|
|
|
- ©«¤l
- 2834
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2890
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-23
|
Sub Macro1()
NA01 = "test"
Sheets("¸ê®Æ").Cells.ClearFormats
Sheets("¸ê®Æ").Copy
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.Path & "\" & NA01, FileFormat:=xlCSV
End Sub |
|
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
csvÀɮפj¤p¡Gtest01¡Btest02¡A¤º®e¤@¼Ë¡A¦ý¬OÀɮפj¤p®t«Ü¤j¡A¬O¬Æ»òì¦]©O?
csv ª½±µ¥Îµ§°O¥»³nÅé´N¥i¥H¶}¤F
§A¥i¥H¸ÕµÛ¶}±Ò¨Ó¬Ý¬Ý
´Nª¾¹D¤F
©Ò¿×ªº¤º®e¤@¼Ë¬O¿ùı |
|
|
|
|
|
|