Pehea e hana hou i kela aku File Hoʻomakaukau No Kona Hiki i loaʻa pāhana paha waihona Ua pilikia ka

I ka hoʻohana 'ana MS kela aku palapala a MS ka hookipaia e assimilate oihana a me pihi i pono VBA (Ke kākoʻo XIX. Noi) no na Macros e hana kekahi ia hana, i ka mea hoʻohana e kiʻi i kekahi compilation hewa "E hiki anei i loaʻa pāhana a me ka waihona" .

• Mahele 1: He aha ka ke kumu o keia pilikia?
• Part 2: Pehea e hana hou i hana hewa kela aku File
• Mahele 3: hana hou i MS kela aku File me kela aku ka hana hou i nā mea hana

Mahele 1: He aha ka ke kumu o keia pilikia?

• Kēia hewa ua ana, kena ae la ia e ka mea hoʻohana ka MS ka hookipaia a me MS kela aku polokalamu. Ke kumu o ia o ka papa i ka olua i kekahi mea a me 'ano o ka waihona i ka nalowale, a ma keia hope aku,ʻaʻole i loaʻa ma ka polokalamu. Alaila, o ka polokalamu hiki ole ke hoʻohana VB a anakahi iki muli oihana a me pihi. No ia mea, he manaʻo a ua hoouna mai.
• I kekahi manawa, i ka waihona e e holo waena ma a holo aku la i kekahi o kaʻalā iā loulou ma waena o waihona a me ka polokalamu kuhi. No laila, i ka compilation hewa ua puka mai ai.
• No ka mea, he maʻamau hale waihona puke no laila, kani nalowale waihona i kekahi wahi o ka liʻiliʻi loa wale. Ke'ē aʻe hiki kumu, ma ia hihia, o ua hale waihona puke Miss-ń o ke kumu o ka hewa. No ka laʻana, ka mea hoʻohana ke i ka waihona (noho Outlook) hoʻokolohua o 2007 akā, me ka olua i loko o ka eiae i e imi i 2010 hoʻokolohua o ka mea i ho'ākāka 'waihona. No laila, i ka polokalamu 'aʻole e loaʻa i ka AYEIE hale waihona puke pela ka hoopuka ana i kēia compilation hewa.
• Kekahi kumu o ka manaʻo no ka mea ia manaʻo e pili ana i ka hoʻohana 'ana o Microsoft XP i loaʻa i ka olua i ka pūnaewele hana ma VBA papahana. I ka wa e holo i kēia papahana ma MS Keena 2003, hookahi compilation hewa i Konakele. Ke kumu o ia 'o ia hoʻi mea' ole 'ano o ka waihona ua nalowale (paha,ʻaʻole i loaʻa).

Part 2: Pehea e hana hou i hana hewa kela aku File

No kekahi mau wahi, i hiki i kekahi pāʻoihana e rectify i ka pilikia 'ole, e hana hou i ino kela aku waihona mea mau ma laila. Like loaa mai i ka nalowale hale waihona puke a me ke kumu o ka OOAaAeAa ina mea i koe. Ka waihona ua laila, hou pahaʻOkoʻa ka kivila mai i ke hōʻoia hou i e kuhikihi ana i ka hale waihona puke kūpono.

Pehea la e hiki ai ia ke hana?

Ma hope o nāʻanuʻu:

KaʻAnuʻu 1. Open ka MS kela waihona, e haawi ana i ka manaʻo.

KaʻAnuʻu 2. hōʻoia 'ia ai ka pepa i loaʻa i ho'ākāka' oihana a me pihi ua wae.

Ka anu u 3. Press "Alt a me ka F11 ki", no ka VB Luna Hoʻoponopono i loko o kekahi pukaaniani hou (i lalo nei).

KaʻAnuʻu 4. Click ma luna Mea Hana 'ike no, a laila, koho i hoʻomaopopo' ia mai ka huki ia 'ike no, e like me ka hōʻike

KaʻAnuʻu Hana 5. Ma hope dialog pahu e hōʻike 'Missing mea waihona' ole 'ano' ua hōʻike, e like me ka hōʻike ma lalo nei

KaʻAnuʻu Hana 6. E like me ka luna 'ia inā ponopono mark ole me ka wiwoʻole waihona, uncheck ia, a kaomi OK

Kai 7. 'Ipuka, a hoola i ka palapala kela aku waihona.

Ano, e kaha i ka hōʻoia 'mauʻoihana e hana pono.

Mahele 3: hana hou i MS kela aku File me kela aku ka hana hou i nā mea hana

Ekolu-aoao kela aku waihona? Aiiio lako polokalamu i laila e hoʻonā a pau keia mau mea koke, a pololei. Kekahi o ka Best kela aku waihona hana hou i lako polokalamu , e hana hou, a loaa maoli ka pōʻino mai / ino kela aku AEIU ua ho'ākāka 'ia ma lalo nei.

Ua kela aku AEI? Aiiio lako polokalamu mea loaʻa no hookahi me pono me mau nenoai. Ke AEI hoʻomaikaʻi hou i nā mea hana a pau kākoʻo wale nō o nā puka makani, a Kākoʻo kela aku 2011 no ka Mac. Kēia 'ae i? Aiiio ino kela aku waihona (.XLS a me .XLSX), a hoihoi aku i nāʻikepili mai ka hoino pu i ka hou kela aku waihona.

KaʻAnuʻu Hana 1 E koho i ka hoino pu i kela aku waihona mai ka holo a me ka huli 'ana.

KaʻAnuʻu Hana 2 Chooes kekahi a me nā mea a pau me ka hoino pu kela aku waihona hoʻomaka 'ana i hoʻomaikaʻi hou kaʻina.

KaʻAnuʻu Hana 3 Preview ka ho'āla hou aʻelaʻo kela aku waihona.

KaʻAnuʻu Hana 4 Koho i ka he makemake ko henua e hoola hou ae la kela aku waihona.

Ma waho aʻeo ia kela aku ka hana hou i nā mea hana a kela aku waihona? Aiiio lako polokalamu , he mau manaʻo kōkua i e kōkua maikaʻi no ka poe ola, fixes (e loaa ai? Aiiio ino kela aku waihona).

Hihia 1. I kela aku waihona Ua hamama ho'āʻo kekahi i kekahi o ka hahai pū nō hoʻi.

1. E ho'āʻo i kaʻokoʻa kamepiula
2. E kuapo aku Auto-hoola.
3. Huli aku i ka waihona kaʻana.
4. Mai holo kela aku, mai ka floppy
5. Mālama i ka waihona e like me ka pūnaewele puni honuaʻaoʻao, a reopen ia me kela waihona.

Hihia 2. A kela aku hiki ole wehe i ka waihona, ho'āʻo kekahi o ka eia.

1. E wehe i ka mea ino waihona ma ka hana-holo. E hoʻokope i mai floppy.
2. E huli i .xlb waihona. I malama i ka papaʻa. E kāpae i .xlb. Hō'ā kela aku.
3. Open waihona ma MS hua'ōlelo a me Padfolio. Mea e e oe ola aneiʻikepili akā,ʻaʻole formatting
4. Me MS kela aku 97/2000 Mea Nānā 'oe ke' ike i nāʻikepili a me ka puka. Open AEI ka hoʻohana 'ana i kēia noa polokalamu e olaʻikepili. Kēia polokalamu, e ola formatting like hoʻi me aeea loina.
5. E ho ohana i kela aku XP. He mea maikaʻi koho no ke ola.