¥H€U¬O§ÚŠ^µª¥t€@Ó¶K€å¡A¥i°ÑŠÒ
************************************************************************
§Ú³£¬OµL·N€€µo²{ªº¡C§Ú¹ÁžÕ¶} 1.xls¡AŠýµoı PACKING LIST
Ó±i sheet n«Ü€[¡C§Ú §â¥Šclose€F¡AŠA¶}±Ò Excel ¡AExcel€J±Š³
Ó€å¥óŽ_ì¡A°Ý§ÚnønÀxŠs¡A§ÚÃhºÃÓ file Ãa÷¡AŠAÀxŠs¥t€@Ó
ÀÉŠW¡AŠý¬O°ÝÃD€@ŠA«Ž_¡C§Ú€§«á¹ÁžÕÀxŠs¬° Excel 95 ®æŠ¡¡A
ŠA¶}±Ò Excel 95 ®æŠ¡šº±i¡AŠbPACKING LIST Ó±i sheet¡A
ŽNš£šì©³Š³±øœu¡AŠP 1.xls øŠP¡A§Ú€§«á¹ÁžÕ §R°£šº±øœu¡A
Šý¬O§R°£€F«ÜŠhŠž¡Ašº±øœu³£ŠA¥X²{¡C«ášÓ§Úµoıšº±øø«Yœu¡A
ŠÓ¬O retangular box (°ª«×«Y 0)¡AŠ³ŠnŠhÓ³oŒËªº object «Å|€@»ô¡A
©Ò¥H§R°£·¥³£ÁÙŠsŠb¡APACKING LIST šº±i sheet Š³ 4 ±ø³oŒËœu¡A
Á`Š@¶W¹L 2700 Ó retangular boxes¡C
§Ú€£¬O§R°£©ÒŠ³ boxes ŠA save °µ "New 1.xls"¡AŠ]¬°šCŠž¥u¥i¥H¿ïŸÜ
šì³Ì³»ºÝšºÓ¡A³oŒË°µ·|ªá«ÜŠh®É¶¡¡C§Ú¬O copy 1.xls €J±ªº€œŠ¡
ŠP®æŠ¡ (¥Î ¿ïŸÜ©Ê¶K€W) ¥h·sªº workbook ŠAÀxŠs¬° "New 1.xls"¡A
D boxes ŽN€£·|§Û¥h "New 1.xls"¡C€p€ß šºšÇ formula ·|«üŠV workbook
"1.xls"¡A¥i¥H¥Î search & replace¥h §ó§ï "New1.xls" €J±ªº formula¡C
øžÓ«{ abc,
§Ú¥ò·Q°Ý€U,À³žÓÂIŒËݯ¥XdÁôÂùπù€Î±Nšä×¥¿©O. Š]¬°§ÚÁÙŠ³«ÜŠh©OdÀÉ®×.
·ÐœÐœç±Ð!
kk
This one is better (53KB). It retains the format in 1.xls with print
format set.
Too many drawing objects in the file.
There are over 2700 rectangular boxes (shown as hidden lines)
in the PACKING LIST sheet!!!
A revised one is attached (47KB)
œÐ°ÝÂIžÑÓfileŠš519kbËÝ€j. ÂIŒË±NÊ\ÁY²Ó©O?
øžÓ!!
************************************************************************
œL©Îšä¥LìŠ]), ŸÉP·ínœÆ»s³o±i worksheet €Wªº¥ôŠóžê®Æ®É³£nªá«Üªø®É¶¡, œÐ°ÝŠ³¬Æ»ò€èªk¥i¥H§Ö³t©ÎŠÛ°ÊŠa§R°£Š¹ worksheet €W©ÒŠ³€åŠr€è
¶ô©O?
ÁÂÁÂ