A laila, no ka laula i koho ʻia ma “Sheet2” (oWorksheetB.
hoʻohana mākou i ke ʻano “ForEach” e hoʻomaʻamaʻa i kēlā me kēia cell i ka pae i koho ʻia.
No kēlā me kēia cell, kiʻi kēia macro.
i ka waiwai o ka cell e ʻike inā pili ia i ka inoa i mālama ʻia ma ka papa inoa “Titles.
Inā loaʻa kahi pāʻani, e kiʻi kēia macro i ke
poʻo inoa pili a me ka macro ka e kūʻai i ka papa inoa helu hoʻolaha fax pāʻoihana loulou.
Mai ke poʻo inoa a me nā hoʻonohonoho loulou a hoʻohana pū i “cell.
GetAddress” no ka loaʻa ʻana o ka helu o ka cell o kēia manawa maSheet2″. ʻ
O ka hope, hoʻonoho i ka loulou i.
Sheet2″ me ka hoʻohana ʻana i ke poʻo inoa a me ka loulou.
:Hiki i nā Hyperlinks ke ho’onui i ka nani a me ka ikaika.
O nā laulapalapala, e ‘ae ana iā ‘oe e komo ma’alahi i nā.
kumuwaiwai ko’iko’i ma kāu mau palapala. Ma kēia moʻomanaʻo moʻomanaʻo
hele mākou iā ʻoe ma nā ka macro ʻanuʻu o ke kākau ʻana i kahi macro e unuhi i ka ʻikepili loulou mai kahi pālahalaha ʻē aʻe a hoʻokomo i nā loulou i loko o kahi pālapa.
Hoʻokomo i nā loulou i kāu pāpalapala me ONLYOFFICE macro
Kūkulu macro
ʻO ka mea mua, ho ka papa kuhikuhi adb macroʻomaka mākou i ʻelua mau ʻokoʻa “oWorksheetA” a me “oWorksheetB”, e hōʻike ana i nā pepa hana i kapa ʻia ʻo “Sheet1” a me “Sheet2” i loko o ka palapala. Ua hana pū mākou i ʻelua papa inoa ʻole ʻo Titles and Links e mālama i ka ʻikepili mai “Sheet1”:
A laila e hoʻohana i kahi loop loop
e hoʻololi i nā lālani pehea e hoʻohui ai i nā manaʻo i ka pdf ka macro ma “Sheet1” (a hiki i nā lālani 10 i kēia hiʻohiʻona). I loko o ka loop e kiʻi ʻia nā waiwai mai nā cell i nā kolamu A a me B, me ka manaʻo o ka kolamu A aia ke poʻo inoa a aia ka kolamu B i ka loulou. A laila mālama ʻia kēia mau waiwai i ke poʻo a me nā loulou loulou no ka hoʻohana hope ʻana: