Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Eventbrite makes it happen

Create an event and sell tickets online through Eventbrite. It's simple! Sign up and get started today.
From our sponsors
txt匯入指定的工作表格
Sep 7th 2013, 22:51

知識問題|

發問者: 紹琦 ( 初學者 5 級)
發問時間: 2013-09-08 06:51:47 ( 還有 9 天發問到期 )
解答贈點: 15 ( 共有 0 人贊助 )
回答: 0 0

我有一個txt檔資料如下
a1 2733560.900 326488.000
a2 2733700.499 326970.000
a3 2738900.400 326700.400
a4 2738234.560 326455.879
a5 2739008.765 327400.569
依次類推
a1 匯入execl B4欄,2733560.900 匯入execl C5欄(註:C與D為一欄)
326488.000匯入execl C6欄(註:C與D為一欄)
a2 匯入execl F4欄,2733700.499 匯入execl G5欄(註:G與H為一欄)
326970.000匯入execl G6欄(註:C與D為一欄)
a3 匯入execl B23欄,2738900.400 匯入execl C24欄(註:G與H為一欄)
326700.400匯入execl C25欄(註:G與H為一欄)
a3 匯入execl F23欄,2738234.560 匯入execl G24欄(註:G與H為一欄)
326455.879匯入execl G25欄(註:G與H為一欄)
A5 匯入execl B46欄2739008.765匯入execl C47欄(註:C與D為一欄)
327400.569匯入execl c47欄(註:C與D為一欄)
依次類推下去
,假設依資料的多寡匯入表格,用execl vba編程式.......謝謝

馬上按讚  加入 Yahoo! 奇摩 知識+  粉絲團

最新VisualBasic

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers. Five Filters recommends:

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 sdfgdf2 的頭像
    sdfgdf2

    中文名字日文翻譯, 中文翻譯日文名字, 名字日文翻譯, 日文翻譯名字, 日文翻譯字典發音, 日文翻譯網 漢字,

    sdfgdf2 發表在 痞客邦 留言(0) 人氣()