Me pēhea te ki te Tapia Kōnae Excel Kāore e taea te kitea Hapa kaupapa whare pukapuka ranei

A, no te whakamahi i tuhinga MS Excel MS Access ranei e whakawhenumi mahi pātene ranei e hiahia VBA (tono Basic Visual) mo te Tonotono ki te mahi i etahi mahi i faataahia, kia whiwhi i te kaiwhakamahi te hapa kohinga "Kāore e taea te kitea kaupapa whare pukapuka ranei" .

• Part 1: He aha te mea te take o tenei Hapa?
• Wāhanga 2: Me pēhea te ki te Tapia Kōnae pirau Excel
• Part 3: Kōnae Tapi MS Excel ki Tool Tapia Excel

Part 1: He aha te mea te take o tenei Hapa?

• Kei te nuinga o tenei hapa meinga e hōtaka MS Access MS Excel ranei o te kaiwhakamahi. Ko te take, ko e kua te hōtaka he tohutoro ki te ahanoa momo o te whare pukapuka e ngaro nei, me te i konei e kore e kitea e te hōtaka ranei. Fakatatau ki ai, e kore e taea e te hōtaka te whakamahi i ngā mahi VB Micro ranei hāngai pātene ranei. Na reira ka unga he karere hapa te.
• I te tahi taime e toggled te whare pukapuka kia ki runga ki toggled atu ai i te hononga ngaro i waenganui i te whare pukapuka, me te waehere hōtaka ranei. Heoi puta te hapa kohinga te.
• Mai i reira he whare pukapuka paerewa pera te tangi whare pukapuka ngaro i te wahi o te tupono iti rawa. Ko te tahi atu take ka taea, i roto i taua take, ko e puna ma'iri-kēmu ko te take o te hapa. Hei tauira, kia whai i te whare pukapuka te kaiwhakamahi (noho Outlook) putanga o 2007 ko te tohutoro i roto i te waehere e rapu ai mo 2010 putanga o taua whare pukapuka motuhake. Na kore te hōtaka ki te kitea te whare pukapuka hāngai te kupu tuku tenei hapa kohinga.
• Tētahi atu tauira e mo te karere hapa taua kei te mo te whakamahi o Microsoft XP i ngā te tohutoro ki te ratonga tukutuku i roto i te kaupapa VBA. A, no te rere koe i tenei kaupapa i roto i MS Office 2003, puta hapa kohinga taua. Ko te take i taua ahanoa arā te ngaro momo o te whare pukapuka (ranei e kore e kitea) ranei.

Wāhanga 2: Me pēhea te ki te Tapia Kōnae pirau Excel

Hoki ngā āhuatanga rerekē ki te tahi mau rongoā whakatikatika i te raruraru ki te ranei hanga kino kōnae Excel kei reira tonu. Ka rite ki te kimi i te whare pukapuka ngaro te take o te ōrite ranei, ki te vai te reira. Kei te ka tāpiri te whare pukapuka i ētahi wā kia takitaki anō ai te waehere ki hono ki te whare pukapuka e tika ana ranei.

Me pehea e taea ai e meatia?

I muri i te kaupae:

Hipanga 1. Whakatūwhera te kōnae MS Excel, hoatu he karere hapa.

Hipanga 2. Me whakarite e tīpakohia te whārangi e whai mahi tautuhi pātene ranei te.

Hipanga 3. Press "ALT me F11 taviri", no te Editor VB i roto i te matapihi hou (rite raro).

Hipanga 4. Pāwhiritia i runga i te tahua Utauta, me te ka tīpako References i unuhia iho tahua, pera whakaaturia

Hipanga 5. I muri pouaka kōrero ka whakaatu 'E ngaro ana te whare pukapuka ahanoa momo ranei' e tohua, e whakaaturia i raro nei

Hipanga 6. I roto i te whakaaturanga i runga ki te vai tohu taki ki whare pukapuka ngaro, wetetaki reira, ka pāwhiri i te ĀE

Hipanga 7. Waiho, me te whakaora i te kōnae Excel taketake.

Na tirohia ki te whakarite kei te mahi tika mahi mahi.

Part 3: Kōnae Tapi MS Excel ki Tool Tapia Excel

Kei reira tuatoru-rōpū Excel pūmanawa kōnae hanga ki te whakatau take pērā katoa hohoro a tika. Ko tētahi o te pūmanawa Tapia kōnae Best Excel , ki hanga me te ora pakaru / kōnae Excel kino whakaahuatia te raro nei.

Tenei pūmanawa kōnae hanga Excel he wātea ana mō te kotahi me te pūnaha maha. E tautoko ana te whakatikatika taputapu kōnae putanga katoa o matapihi, me te tautoko Excel 2011 mo Mac. Faati'a tēnei hanga kino kōnae Excel (.xls me .xlsx), ka whakahoki nga raraunga katoa i kino ki te kōnae Excel hou.

Hipanga 1 Tīpakohia kino kōnae Excel i puku, me te rapu.

Hipanga 2 Chooes tetahi ranei kino tīmatanga kōnae Excel katoa ki te whakatika tukanga.

Hipanga 3 Arokite te kōnae Excel hanga ko.

Hipanga 4 Tīpakohia te wāhi pai ki te whakaora e hanga ana kōnae Excel.

I tua atu ki te Tool Tapia Excel ranei pūmanawa kōnae Excel hanga , kia āwhina mō whakatikanga tere (ki te ora ranei kua kino hanga kōnae Excel) he torutoru tohutohu.

Case 1. A, no te he tuwhera kōnae Excel tamata tetahi tetahi o nei ai.

1. Whakamātauria i runga i te rorohiko rerekē
2. Whakawhitia atu aunoa whakaora-.
3. Tahuri atu te tiri kōnae.
4. Kaua e rere Excel i te pīngore
5. Whakaorangia te kōnae rite te whārangi tukutuku, ka tūwhera anō te reira rite kōnae Excel.

Case 2. A, no te kore e taea e Excel whakatuwhera te kōnae, ngana tetahi o te whai ake.

1. Whakatūwhera te kōnae kino i runga i pakeke-puku. Tārua i pīngore.
2. Kimihia kōnae .xlb. pupuri hoki i te tārua. Mukua .xlb. Tīmata Excel.
3. Whakatūwhera kōnae i roto i te kupu MS Notepad ranei. E ka tukua koutou ora raraunga engari e kore e hōputu
4. Ki te MS Excel 97/2000 pūtirotiro taea e koe te tiro i te raraunga, me te tā. Whakatūwhera kōnae te whakamahi i tenei hōtaka noa ki te ora raraunga. Ka ora tenei hōtaka hōputu me te uara pūtau.
5. Whakamahi XP Excel. He kōwhiringa pai mo te whakaora tenei.