GetOpenFilenameªº»yªk°ÝÃD
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 61
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW®ç¶é
- µù¥U®É¶¡
- 2010-9-1
- ³Ì«áµn¿ý
- 2019-4-26
|
GetOpenFilenameªº»yªk°ÝÃD
¤p§Ì³Ìªñ¦b¨Ï¥ÎGetOpenFilename®Éµo¥Í¤F¤@¨Ç°ÝÃD¤@ª½µLªk±Æ°£¡A
¥H¤U¬O§ÚºI¨ú¤F§Úµ{¦¡½Xªº³¡¤À¡A
¥Ø«e¤p§Ì¹J¨ìªº°ÝÃD´N¬O§Ú¦b§PÂ_FO¦b¶}±ÒÂÂÀÉ®ÉY«ö¤U¨ú®ø·|¥X²{¿ù»~¡A
Y§Ú¦bIf UBound(FO) > File_qty Then«e±¦A¥[¤JIf FO = False Then¨Ó§PÂ_®É¥i¥H¸Ñ¨M¡A
¦ýY§Ú¹ê»Ú¦³¸ü¤JÀɮ׮ɴN·|µo¥Í«¬ºA¤£²Åªº°ÝÃD¡A¦ÓµLªkÄ~Äò«á±ªºµ{¦¡¡A½Ð¦U¦ì¤j¤jÀ°§Ú¸Ñ´b¤@¤U¡AÁÂÁ¡C
File_qty = Sheets(SN_1).Cells(2, 6)
FO = Application.GetOpenFilename("Excel File(*.CSV) (*.CSV),(*.CSV)", , , , True)
If UBound(FO) > File_qty Then
MsgBox ("¸ü¤JÀɮפj©ó" & File_qty & "Ó¤w¶W¥Xµ{¦¡¤W¡A½Ð«·s¿ï¾ÜÀÉ®×»P½T»{¸ü¤J¼Æ¶q¬O§_¤p©ó©Îµ¥©ó" & File_qty & "Ó¡AÁÂÁÂ!!")
Sheets(SN_1).Select
Else
For I = 1 To UBound(FO)
Sheets(SN_2).Select
WB = ActiveWorkbook.Name
WS = ActiveSheet.Name
Workbooks.Open Filename:=FO(I), ReadOnly:=False, Notify:=False
FN = ActiveWorkbook.Name
SN = ActiveSheet.Name
Range("A1:O15").Copy
Windows(WB).Activate
Sheets(SN_2).Cells(1, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
NN = [A65536].End(xlUp).Row
Windows(FN).Activate
ActiveWorkbook.Close SaveChanges:=False
Windows(WB).Activate
ID = Cells(2, 3)
T = Split(Trim(Cells(3, 3)), " ")
Range(Cells(7, 1), Cells(NN, 15)).Copy
Sheets("LED´ú¸Õµ²ªG").Select
Cells((I - 1) * 20 + 8, 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Cells((I - 1) * 20 + 4, 2) = Mid(ID, 1, Len(ID) - 4)
Cells(I + 4, 20) = Mid(ID, 1, Len(ID) - 4)
Cells((I - 1) * 20 + 5, 2) = T(0)
Cells((I - 1) * 20 + 6, 2) = T(1) & " " & T(2)
Next I
Sheets("LED´ú¸Õµ²ªG").Select
Application.Run ("Calculate_Mcd")
End If |
|
|
|
|
|
|
- ©«¤l
- 20
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 61
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW®ç¶é
- µù¥U®É¶¡
- 2010-9-1
- ³Ì«áµn¿ý
- 2019-4-26
|
GB¤j¤j¯u±j¡A
§Ú´N¥d¦bFO¦³Åª¨úÀɮ׮ɬO°}¦C»P«ö¤U¨ú®ø®É«¬ºA¤£²Å¦Ó¥d¦í¡A
Åý§Ú¾Ç²ß¨ì¤£¦Pªº¼gªk¤F~~·PÁÂGB¤j¤jªº«ü¾É!!! |
|
|
|
|
|
|