Excel-VBA宏编程实例源代码-数据的导入导出-自动导入文本文件.zip

员工姓名,性别,所属部门,基本工资,业绩奖金,住房补助,应扣请假费,工资总额,应扣所得税,应扣劳保金额,实际应付工资 陈霞,女,销售部,"$4,600","$1,720",$600,$153,"$6,767",$0,$300,"$6,467" 李海,男,销售部,"$4,600","$5,600",$500,$77,"$10,623","$1,062",$300,"$9,261" 刘繁,女,销售部,"$4,800","$4,080",$500,$0,"$9,380",$0,$300,"$9,080" 袁锦辉,男,销售部,"$3,700",$0,$500,$62,"$4,138",$0,$300,"$3,838" 钟兵,男,销售部,"$3,700","$13,200",$500,$25,"$17,375","$1,738",$300,"$15,338" 丁芬,女,销售部,"$3,700","$1,200",$500,$0,"$5,400",$0,$300,"$5,100" 程静,女,销售部,"$3,900","$1,200",$400,$0,"$5,500",$0,$300,"$5,200" 刘健,男,销售部,"$3,000","$1,800",$400,$100,"$5,100",$0,$300,"$4,800" 苏江,男,销售部,"$3,000","$14,760",$400,$0,"$18,160","$1,816",$300,"$16,044" 廖嘉,女,销售部,"$3,000","$5,200",$400,$0,"$8,600",$0,$300,"$8,300" 刘佳,女,销售部,"$3,000",$880,$400,$30,"$4,250",$0,$300,"$3,950" 陈永,男,销售部,"$2,850",$0,$450,$0,"$3,300",$0,$300,"$3,000" 周繁,女,销售部,"$3,150","$6,400",$450,$42,"$9,958",$0,$300,"$9,658" 周波,女,销售部,"$3,150","$22,200",$450,$21,"$25,779","$2,578",$300,"$22,901" 熊亮,男,销售部,"$3,150","$7,200",$450,$105,"$10,695","$1,070",$300,"$9,326"