求助大神 VB大神安在？？？

jiason_zhu 2011-07-05 11:46:06

临近期末老师要让交作业啊
由于自己学期基本在外面跑没怎么好好上课
烦请诸位大神帮助
第一把txt里面的信息转到exl里面
第二怎么样在exl里面把一些单元格的文件提取出来
本来是一些书目就是要包这些书目精简一下
通过vb来实现
下面是文件格式红色部分是书目的各项名称
黑色部分是内容总共有500条吧后面要提取的内容有 PT AU TI SO LA DE AB FU CR TC PU CN DI PY SC
PT AU BA ED GP AF CA TI SO SE LA DT CT CY CL SP HO DE ID AB C1 RP EM FU FX CR NR TC PU PI PA SN BN DI J9 JI PD PY VL IS PN SU SI BP EP AR DI PG SC GA UT
J "Li, KJ; Xu, JC; Liu, XH; Gao, PX; Zhan, LS" "Li, K. J.; Xu, J. C.; Liu, X. H.; Gao, P. X.; Zhan, L. S." Periodicity of Total Solar Irradiance SOLAR PHYSICS English Article Solar irradiance; Solar cycle; Observations MAUNDER MINIMUM; MAGNETIC-FIELD; CYCLES 21-23; CLIMATE; VARIABILITY; TREND; RECONSTRUCTION; LUMINOSITY "We investigate the periodicity in the PMOD composite of the daily total solar irradiance (TSI) from 21 September 1978 to 9 June 2009. Besides the Schwabe cycle period (10.32 years), the quasi-rotation period is found to be statistically significant in TSI, whose value is about 32 days, longer than that in sunspot activity (27 days), and it intermittently appears around the sunspot maximum times. The quasi-rotation period in TSI is inferred to be mainly caused by sunspot activity, but to be modulated by bright features as well. It was previously found that variations of TSI over a Schwabe solar cycle mainly come from the combination of the sunspots' blocking and the intensification due to bright faculae, plages, and network elements, with a slight dominance of the bright-feature effect during the maximum of the Schwabe cycle. For the sunspot-blocking and the bright-feature effect to contribute to TSI over a Schwabe solar cycle, the former is inferred to lead the latter by 29 days at least." "[Li, K. J.; Xu, J. C.; Gao, P. X.] CAS, Yunnan Observ, Natl Astron Observ, Kunming 650011, Peoples R China; [Li, K. J.] Chinese Acad Sci, Key Lab Solar Act, Natl Astron Observ, Beijing 100012, Peoples R China; [Xu, J. C.; Gao, P. X.] CAS, Grad Sch, Beijing 100863, Peoples R China; [Liu, X. H.] Jiaozuo Adv Normal Coll, Dept Phys, Jiaozuo 454107, Peoples R China; [Zhan, L. S.] Jingdezhen Ceram Inst, Jingdezhen 333001, Jiangxi, Peoples R China" "Li, KJ, CAS, Yunnan Observ, Natl Astron Observ, Kunming 650011, Peoples R China" lkj@mail.ynao.ac.cn; gpx@mail.ynao.ac.cn "Natural Science Funds of China [10873032, 10921303, 40636031, 11073010]; 973 project [2006CB806300]; Chinese Academy of Sciences " "We thank the anonymous referees for their careful reading of the manuscript and constructive comments which improved the original version of the manuscript. The authors thank PMOD/WRC, Davos, Switzerland, for making available the data set of total solar irradiance measurements (version d41-62-0906), comprising composite irradiance values since 1978, which includes unpublished data from the VIRGO Experiment on the cooperative ESA/NASA SOHO Mission. This work is supported by the Natural Science Funds of China (10873032, 10921303, 40636031, and 11073010), the 973 project (2006CB806300), and the Chinese Academy of Sciences." "BOND G, 2001, SCIENCE, V294, P2130; CHAPMAN GA, 1987, ANNU REV ASTRON ASTR, V25, P633; COUGHLIN K, 2004, J GEOPHYS RES-ATMOS, V109, ARTN D21105; DAMERIS M, 2006, GEOPHYS RES LETT, V33, ARTN L03806; DEWITTE S, 2004, SOL PHYS, V224, P209, DOI 10.1007/s11207-005-5698-7; DOMINGO V, 2009, SPACE SCI REV, V145, P337, DOI 10.1007/s11214-009-9562-1; EDDY JA, 1976, SCIENCE, V192, P1189; EGOROVA T, 2005, ADV SPACE RES, V35, P451, DOI 10.1016/j.asr.2005.01.048; FONTENLA J, 1999, ASTROPHYS J 1, V518, P480; FROHLICH C, 1998, GEOPHYS RES LETT, V25, P4377; FROHLICH C, 2000, SPACE SCI REV, V94, P15; FROHLICH C, 2003, METROLOGIA, V40, S60; FROHLICH C, 2006, SPACE SCI REV, V125, P53, DOI 10.1007/s11214-006-9046-5; FROHLICH C, 2009, ASTRON ASTROPHYS, V501, L27, DOI 10.1051/0004-6361/200912318; HAIGH JD, 1996, SCIENCE, V272, P981; HAIGH JD, 2001, SCIENCE, V294, P2109; HUDSON HS, 1982, SOL PHYS, V76, P211; KRIVOVA NA, 2007, ASTRON ASTROPHYS, V467, P335, DOI 10.1051/0004-6361:20066725; KRIVOVA NA, 2008, J ASTROPHYS ASTRON, V29, P151; KURODA Y, 2005, GEOPHYS RES LETT, V32, ARTN L13802; LEE RB, 1995, J GEOPHYS RES, V100, P1667; LOCKWOOD M, 1999, NATURE, V399, P437; LOCKWOOD M, 2005, SAAS FEE ADV COURSE, V34, P109; MEKAOUI S, 2008, SOL PHYS, V247, P203, DOI 10.1007/s11207-007-9070-y; MENDOZA B, 2005, ADV SPACE RES, V35, P882, DOI 10.1016/j.asr.2004.10.011; PAP J, 1990, SOL PHYS, V129, P165; REID GC, 1987, NATURE, V329, P142; RIND D, 2002, SCIENCE, V296, P673; SOLANKI SK, 2000, NATURE, V408, P445; SOLANKI SK, 2003, ESA SP PUBL, V535, P285; SOLANKI SK, 2004, SOL PHYS, V224, P197, DOI 10.1007/s11207-005-6499-8; TORRENCE C, 1998, B AM METEOROL SOC, V79, P61; VAZQUEZ RH, 2006, ESA, P69; WENZLER T, 2006, ASTRON ASTROPHYS, V460, P583, DOI 10.1051/0004-6361:20065752; WILLSON RC, 1988, NATURE, V332, P810; WILLSON RC, 1991, NATURE, V351, P42; WILLSON RC, 1997, SCIENCE, V277, P1963; WILLSON RC, 2003, GEOPHYS RES LETT, V30, ARTN 1199; WOLFF CL, 1987, SOL PHYS, V109, P1" 39 0 SPRINGER DORDRECHT "VAN GODEWIJCKSTRAAT 30, 3311 GZ DORDRECHT, NETHERLANDS" 0038-0938 10.1007/s11207-010-9655-8 SOL PHYS Sol. Phys. DEC 2010 267 2 295 303 9 Astronomy & Astrophysics 687ID ISI:000284771300006

...全文