ʾ Àý£º
2.1.15 GetDocumentObject Ô ÐÍ: IDispatch* GetDocumentObject(); ¹¦ ÄÜ£º
»ñÈ¡Îĵµ¶ÔÏóµÄActiveDocument¶ÔÏ󣬴˽ӿڷdz£ÖØÒª£¬»ù±¾ËùÓеÄVBA¹¦Äܶ¼¿ÉÒÔͨ¹ýÕâ¸ö½Ó¿ÚÀ´ÊµÏÖ¡£ ²Î Êý£º
·µ»ØÖµ: ActiveDocument¶ÔÏóµÄDispatch ʾ Àý£º
/* ÒÔϵÄJavaScriptΪ²ÉÓÃActiveDocumentµÄ·½Ê½Ö±½Ó²Ù×÷VBA£¬ÏòDOCÎĵµµÄÊéÇ©
ÖмÓÈëÒ»¸öͼƬ¡£
function AddPicture(strMarkName,strBmpPath,vType) ÔÚÊéǩλÖòåÈëͼƬ, strMarkName ÊéÇ©µÄÃû³Æ strBmpPath ͼƬµÄ·¾¶
vType ²åÈëºóµÄͼƬµÄÑùʽ£¬5Ϊ¸¡¶¯ÔÚÎÄ×ÖÉÏÃæ AddPicture(\ AddPicture(\ */
function AddPicture(strMarkName,strBmpPath,vType) {
//¶¨ÒåÒ»¸ö¶ÔÏó£¬ÓÃÀ´´æ´¢ActiveDocument¶ÔÏó var obj;
obj = new Object(document.all.WebOffice1.GetDocumentObject()); if(obj !=null){
var pBookMarks;
// VAB½Ó¿Ú»ñÈ¡ÊéÇ©¼¯ºÏ
pBookMarks = obj.Bookmarks; var pBookM;
// VAB½Ó¿Ú»ñÈ¡ÊéÇ©strMarkName
pBookM = pBookMarks(strMarkName); var pRange;
// VAB½Ó¿Ú»ñÈ¡ÊéÇ©strMarkNameµÄRange¶ÔÏó
pRange = pBookM.Range; var pRangeInlines;
// VAB½Ó¿Ú»ñÈ¡ÊéÇ©strMarkNameµÄRange¶ÔÏóµÄInlineShapes¶ÔÏó
pRangeInlines = pRange.InlineShapes; var pRangeInline;
// VAB½Ó¿Úͨ¹ýInlineShapes¶ÔÏóÏòÎĵµÖвåÈëͼƬ
pRangeInline = pRangeInlines.AddPicture(strBmpPath);
//ÉèÖÃͼƬµÄÑùʽ£¬5Ϊ¸¡¶¯ÔÚÎÄ×ÖÉÏÃæ
pRangeInline.ConvertToShape().WrapFormat.TYPE = vType; delete obj;
} }
2.1.16 GetFieldValue Ô ÐÍ: BSTR GetFieldValue(BSTR strFieldName, BSTR strSheetName); ¹¦ ÄÜ£º»ñµÃÊéǩλÖõÄÊýÖµ ²Î Êý£º
strFieldName£ºÊéÇ©µÄÃû×Ö
strSheetName£ºÔ¤Áô×ֶΣ¨ÖµÎª¿Õ£©
·µ»ØÖµ: ·µ»ØÊéÇ©µÄÖµ ʾ Àý£º
//»ñµÃÊéÇ©µÄÖµ
var strFieldValue=document.all.WebOffice1.GetFieldValue(\
2.1.17 GetTempFilePath Ô ÐÍ: BSTR GetTempFilePath(); ¹¦ ÄÜ£º»ñµÃÁÙʱÎļþ·¾¶ ²Î Êý£º ·µ»ØÖµ: µ±Ç°ÎļþµÄÁÙʱ·¾¶ ʾ Àý£º
var strTempPath=document.all.WebOffice1.GetTempFilePath ()£»
2.1.18 GetRevCount Ô ÐÍ: long GetRevCount(); ¹¦ ÄÜ£º»ñÈ¡ÐÞ¶©½ÚµãµÄ¸öÊý ²Î Êý£º
·µ»ØÖµ: »ñÈ¡ÐÞ¶©½ÚµãµÄ¸öÊý ʾ Àý£º
2.1.19 GetRevInfo Ô ÐÍ: BSTR GetRevInfo(long lIndex, long lType);
¹¦ ÄÜ£º»ñÈ¡ÐÞ¶©½ÚµãµÄÐÅÏ¢£¨ÐÞ¶©ÈË£¬ÐÞ¶©µÄʱ¼ä£¬ÐÞ¶©µÄ¶¯×÷£© ²Î Êý£º
lIndex: ÐÞ¶©µÄ½Úµã±àºÅ lType: »ñÈ¡µÄÐÅÏ¢±àºÅ ·µ»ØÖµ: ʾ Àý£º
//1.»ñÈ¡ÐÞ¶©µÄÓû§
vUserName = document.all.WebOffice1.GetRevInfo(i,0); //2.»ñÈ¡ÐÞ¶©µÄʱ¼ä
vDate = new String(document.all.WebOffice1.GetRevInfo(i,1)); //3.»ñÈ¡ÐÞ¶©µÄ¶¯×÷
var vRet = document.all.WebOffice1.GetRevInfo(i,2); vRet == \±íʾ\²åÈë\µÄ²Ù×÷ vRet == \±íʾ\ɾ³ý\µÄ²Ù×÷ //4.»ñÈ¡ÐÞ¶©µÄÄÚÈÝ
vUserName = document.all.WebOffice1.GetRevInfo(i,3); //×ÜÌåµÄÀý×Ó´úÂë var vCount;
vCount = document.all.WebOffice1.GetRevCount(); var vOpt = 0; var vDate;
for(var i=1; i<= vCount; i++){
vOpt = document.all.WebOffice1.GetRevInfo(i,2); if(\ vOpt = \²åÈë\
}else if(\ vOpt = \ɾ³ý\ }else{
vOpt = \δ֪²Ù×÷\ }
vDate = new String(document.all.WebOffice1.GetRevInfo(i,1)); vDate = parseFloat(vDate); dateObj = new Date(vDate);
alert(dateObj.getYear() + \Äê\ÔÂ\dateObj.getDate() +\ÈÕ\+ dateObj.getHours() +\ʱ\+ dateObj.getMinutes() +\·Ö\Ãë\
alert(\Óû§:\+ \²Ù×÷:\+ vOpt + \ÄÚÈÝ:\
}
2.1.20 GetFileSize Ô ÐÍ: long GetFileSize (LPCTSTR strFilePath); ¹¦ ÄÜ£º»ñÈ¡±¾µØÎļþµÄ´óС ²Î Êý£º ·µ»ØÖµ: ʾ Àý£º
var vLen = obj.GetFileSize(\
2.1.21 GetBookMarkCount Ô ÐÍ: long GetBookMarkCount(); ¹¦ ÄÜ£º»ñÈ¡ÎĵµÖÐÊéÇ©µÄ×ÜÊýÁ¿ ²Î Êý£º ·µ»ØÖµ: ʾ Àý£º GetFileSize
2.1.22 GetBookMarkInfo Ô ÐÍ: BSTR GetBookMarkInfo(long lIndex, long lType); ¹¦ ÄÜ£º»ñÈ¡¸÷ÊéÇ©µÄÐÅÏ¢£¨Ãû³ÆºÍ±äÁ¿£© ²Î Êý£º ·µ»ØÖµ: ʾ Àý£º
var vBKCount;
vBKCount = document.all.WebOffice1.GetBookMarkCount(); var iIndex; var vName; var vValue; var vShowInfo; vShowInfo = \
for(iIndex = 1; iIndex <= vBKCount; iIndex++){
vName = document.all.WebOffice1.GetBookMarkInfo(iIndex,0 ); vValue = document.all.WebOffice1.GetBookMarkInfo(iIndex,1 ); vShowInfo += \ vName = \ vValue = \ }
alert(vShowInfo);
2.1.23 HideMenuItem Ô ÐÍ: long HideMenuItem(long lMenuType); ¹¦ ÄÜ£º¿ØÖÆ×ÔÓй¤¾ßÀ¸µÄÏÔʾ ²Î Êý£º
lMenuType¹¤¾ßÀ¸¿ª¹Ø£¬²ÉÓÃ32λµÄÊý×Ö×÷Ϊ¿ª¹Ø£¬µ±Ïà¹ØÎ»Îª1µÄʱºò£¬°´Å¥ÏÔʾ£¬Îª0Êǰ´Å¥Òþ²Ø¡£
enum{
vNew = 0x01, //н¨ vOpen = 0x02, //´ò¿ª vSaveAs = 0x04, //±£´æ vPrint = 0x10, //´òÓ¡ vPrintView = 0x20, //´òÓ¡Ô¤ÀÀ vReturn = 0x1000, //È«ÆÁ vFullScrean = 0x2000 //·µ»Ø };
·µ»ØÖµ: ʾ Àý£º
//Ö»ÏÔʾн¨ºÍÈ«ÆÁ°´Å¥
Object.HideMenuItem(0x01 + 0x1000);
2.1.24 HideMenuAction Ô ÐÍ: long HideMenuAction(short shMenuMode, long lValue); ¹¦ ÄÜ£ºÉèÖò˵¥µÄÒþ²ØºÍÏÔʾ¡£Ö§³ÖOffice2007µÄ²Ëµ¥Òþ²ØºÍÏÔʾ ²Î Êý£º(½öÊÊÓÃÓÚOffice2007)
shMenuMode£ºÉèÖÃģʽ£º¾ßÌåÖµ¼°º¬ÒåÈçÏ£º
0£ºOffice2003ÒÔÏ£¬Ö±½Ó¹Ø±Õ²Ëµ¥£¬ÔÝδ֧³Ö¡£¿ÉʹÓÃSetToolBarButton2½Ó¿Ú¿ØÖÆ
1£ºOffice2007ÒÔÉÏ£¬ÐèÒªÉèÖùرղ˵¥Áбí 2£ºÀ©Õ¹Öµ£¬ÔÝÎÞº¬Òå 3£ºÀ©Õ¹Öµ£¬ÔÝÎÞº¬Òå 4£ºÀ©Õ¹Öµ£¬ÔÝÎÞº¬Òå
5£ºÉèÖùرղ˵¥Áбíºó£¬Ðèµ÷ÓôËÖµ¼¤»î¡£²¢µÚ¶þ¸ö²ÎÊýÉèÖÃΪ0£¬¾ßÌå¼ûʾÀý¡£
6£º»Ö¸´²Ëµ¥ÏÔʾ¼°¹¦ÄÜʹÓ㬵ڶþ¸ö²ÎÊýÉèÖÃΪ0 lValue:ÉèÖÃÒªÒþ²ØµÄ²Ëµ¥¼°½ûÖ¹¸´ÖÆ¡¢Õ³Ìù¹¦ÄÜ 0x1000£ºÊ®½øÖÆÎª4096--Õ³ÌùÎÞЧ 0x2000£ºÊ®½øÖÆÎª8192¡ª¸´ÖÆÎÞЧ
0x100000£ºÊ®½øÖÆÎª1048576¡ª¿ªÊ¼²Ëµ¥
0x200000£ºÊ®½øÖÆÎª2097152¡ª²åÈë²Ëµ¥ 0x400000£ºÊ®½øÖÆÎª4194304¡ªÒ³Ãæ²¼¾Ö²Ëµ¥ 0x800000£ºÊ®½øÖÆÎª8388608¡ªÒýÓò˵¥