ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] compatibility mode

[µo°Ý] compatibility mode

·Q½Ð±Ð¤@¤U¤j¤j­Ì..
excel file±`±`³£¬Ý¨ìfile name«á­±µù©úµÛ compatibility mode
½Ð°Ý¬O¤°»ò·N«ä©O~~

·Q½Ð±Ð¤@¤U¤j¤j­Ì..
excel file±`±`³£¬Ý¨ìfile name«á­±µù©úµÛ compatibility mode
½Ð°Ý¬O¤°»ò·N«ä©O~~
jomeow µoªí©ó 2014-10-31 16:09

Ãþ¦ü³oÃþ°ÝÃDExcel ¥»¨­´N¦³´£¨Ñ¬d¸ß¾÷¨î³á,
¥u­n¦bExcelªºHelpµøµ¡¬d¸ß§Y¥i±o :
CompareMode ÄÝ©Ê
´y­z
³]©w©Î¶Ç¦^ Dictionary ª«¥ó¤¤ªº¤ñ¸û¦r¦êÃöÁä¦rªº¤ñ¸û¼Ò¦¡¡C

»yªk
object.CompareMode[ = compare]

CompareMode Äݩʨ㦳¤U¦C³æ¤¸¡G
³æ¤¸ ´y­z
object ¥²­n¤Þ¼Æ¡C©l²×¬O¤@­Ó Dictionary ª«¥óªº¦WºÙ¡C
compare ¿ï¾Ü©Ê¤Þ¼Æ¡C¦pªG´£¨Ñªº¸Ü¡Acompare ¬O¤@­Ó¥Nªí¤ñ¸û¼Ò¦¡ªº¡A¸Ó¤ñ¸û¼Ò¦¡¥Î©ó¹³ StrComp ³o¼Ëªº¨ç¼Æ¡C

³]©w
compare ¤Þ¼Æ¥i¥H¨ã¦³¤U¦C­È¡G

±`¼Æ   ´y­z
VbUseCompareOption -1 ¨Ï¥Î Option Compare ³¯­z¦¡ªº³]©w¶i¦æ¤ñ¸û¡C
vbBinaryCompare  0 ¶i¦æ¤G¶i¦ì¤ñ¸û¡C
vbTextCompare  1 ¶i¦æ¤å¦r¤ñ¸û¡C
vbDatabaseCompare  2 ¶È¥Î©ó Microsoft Access¡C¶i¦æ°ò©ó±z¦Û¤v¸ê®Æ®w¤¤¸ê°Tªº¤ñ¸û¡C

TOP

¦^´_ 2# luhpro


compatibility mode and compare mode are two different things.

nevertheless, i appreciate for your teaching of using F1 in excel.
Finally i got the ans.

Thank you very much for your teaching.
=)

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-11-1 19:37 ½s¿è
¦^´_  luhpro
compatibility mode and compare mode are two different things.
nevertheless, i  ...
jomeow µoªí©ó 2014-11-1 19:06

©êºp,¬Ý¨ì¬OExcel¥Îªº,
¤U·NÃÑ·Q¨ì¬OÀɮתº¼Ò¦¡,
¨S¦³¯d·N¨ì­^¤å«÷¦r¤£¦P,
¸Ó½g¦Û§R. ( ±à...¨t²Î¤£Åý§RO.O")

¥H¤U¬O§Úºô¸ô¤W§ä¨ìªº¬ÛÃö¸ê°T:
Compatibility mode
compatibility mode (¬Û®e¼Ò¦¡)
¬Û®e¼Ò¦¡¬O¤@ºØ³nÅé¥i¥HÃþ¤ñ³nÅ骺ª©¥»¨Ï¹L®Éªº³nÅé©ÎÀÉ¡A
¥H«O«ù¬Û®e¹q¸£ªº¸û·sªºµwÅé©Î³nÅ骺³nÅé¾÷¨î¡C

¨Ì§A©Ò­z¥i¯à´N¬O¥Îª©Excel³nÅé¶]·sª©Excel³nÅé°µ¥X¨Óªº·sª©Excel®æ¦¡ÀÉ®×,
¨Ò¦p Excel 2000 + Microsoft Office Word¡BExcel ¤Î PowerPoint Àɮ׮榡¬Û®e©Ê®M¥ó Ū¨ú Excel 2003 ¥H«áª©¥»ªº³nÅé,
°µ¥X¨Ó«D¨ä­ì¥ý³]­p¥i¤ä´©ªºÀÉ®×(¨Ò¦p : *.xlsx, *.xlsm...).
³oºØ¤è¦¡¥u¯à¹ê²{¤@³¡¤À°ò¥»©Î¨âªÌ¦@¦³ªº¥\¯à,
¦Ü©ó¹³¤@¨Ç·sª©Excel·s¼Wªº¤½¦¡¨ç¼Æ©Î·s¼W¼Ò¦¡¥i¯à´N¤£¤ä´©¤F.

TOP

¦^´_ 4# luhpro


§Ú³£¬O¦]¬°§A±Ð§Ú¦b»¡©ú«K¥i¥H§ä¨ìµª®×..
²{¦b§Ú·|¦h¥ÎEXCEL¸ÌªºDICTIONARY..
³o¼Ë§Ú«K¤£¥Îµo³o¨Ç²Â²Âªº°ÝÃD..
·PÁ¤j¤jªº±Ð¾É...  m(_ _)m
¨£¯º~~   ^^!!

TOP

compatibility mode ( ¬Û®e¼Ò¦¡ , ¸ó EXCEL ª©¥» )

http://office.microsoft.com/zh-tw/excel-help/HA010342994.aspx

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD