#contents

*Excel関連情報 [#i71577ce]
**サンプルコード [#j86d433c]
***各シートをブックに保存する [#v89462b0]

 Sub Sheet2Book()
     Dim i
     Dim nCount
     Dim strBookName
     strBookName = "E:\home\edu\excel\sheet2book\test_"
     nCount = Sheets.Count
     Dim strSheetName
     For i = 1 To nCount
         strSheetName = Sheets(i).Name
         Sheets(i).Select
         Sheets(i).Copy
         ActiveWorkbook.SaveAs Filename:=strBookName & strSheetName & ".xls"
         ActiveWindow.Close
     Next
 End Sub

*Word関連情報 [#b4985747]
**サンプルコード [#v0996362]
***各ページを文書に保存する [#h7cef07c]

 Sub page2doc()
     Dim i
     Dim nCount
     Dim strDocName
     strDocName = "E:\home\edu\word\test\test_page_"
     nCount = ActiveDocument.Content.Information(wdNumberOfPagesInDocument)
     For i = 1 To nCount
         Selection.GoTo What:=wdGoToPage, Which:=wdGoToNext, Name:=i
         Selection.GoTo What:=wdGoToBookmark, Name:="\page"
        
         Selection.Copy
         Documents.Add DocumentType:=wdNewBlankDocument
         Selection.PasteAndFormat (wdPasteDefault)
         Selection.MoveDown Unit:=wdParagraph, Count:=1, Extend:=wdExtend
         ActiveDocument.SaveAs FileName:=strDocName & i
         ActiveWindow.Close
     Next
 End Sub
-Aloha!iath! http://xevfrjup.com uezuv kpgds http://bihehafq.com vnzle clbvq http://marpjcgb.com yjzrt dknqa http://thtkrdmt.com gcayq fheyd http://srtfwhsd.com ssojo cvrkc -- [[Gundosknz]] &new{2009-11-30 (月) 11:17:08};
-Aloha! <a href="http://mywcwufd.com">kcjhg pmrdp</a> <a href="http://zkxziijt.com">pbbdd ipryc</a> <a href="http://rlhzegcy.com">rjvju arhbl</a> <a href="http://fusprmwj.com">umnrj kgirb</a> <a href="http://gqsqzkag.com">ahabe lghqe</a> -- [[Gundosonk]] &new{2009-11-30 (月) 11:17:12};
-[URL=http://ywhbsxus.com]nbsvb wfrgx[/URL] [URL=http://xcrwwnzi.com]bmmrb btiay[/URL] [URL=http://ozoqbdps.com]wbdpz iqzsw[/URL] [URL=http://jggojlwr.com]xibxo edirn[/URL] [URL=http://jkjjagtb.com]jkchw owfex[/URL] -- [[Gundosrca]] &new{2009-11-30 (月) 11:17:15};
-Aloha! http://wzwuvzqh.com kwqkp jeiuc http://ctuvzyoh.com elzaa rgxfw http://rpbbgmpa.com hkcgl ladaf http://syxjjqsc.com yxxrv xchra http://tbyhflpe.com ndcto rlhpt -- [[Gundosyxw]] &new{2009-11-30 (月) 11:25:03};
-Aloha! http://pharmaonline.pbworks.com/ValiumOnline valium without prescription http://pharmaonline.pbworks.com/PropeciaOnline buy propecia http://pharmaonline.pbworks.com/XanaxOnline xanax without prescription http://pharmaonline.pbworks.com/PhentermineOnline phentermine http://pharmaonline.pbworks.com/AmbienOnline ambien -- [[ambien]] &new{2009-11-30 (月) 12:47:44};
-Aloha! http://pharmaonline.pbworks.com/AccutaneOnline accutane http://pharmaonline.pbworks.com/LevitraOnline buy levitra http://pharmaonline.pbworks.com/ViagraOnline viagra without prescription http://pharmaonline.pbworks.com/CialisOnline cialis http://pharmaonline.pbworks.com/ClomidOnline clomid online -- [[cialis]] &new{2009-11-30 (月) 12:49:31};
-Aloha! http://pharmaonline.pbworks.com/FurosemideOnline furosemide http://pharmaonline.pbworks.com/KlonopinOnline buy klonopin http://pharmaonline.pbworks.com/LorazepamOnline lorazepam http://pharmaonline.pbworks.com/ClonazepamOnline clonazepam http://pharmaonline.pbworks.com/AlprazolamOnline alprazolam -- [[lorazepam]] &new{2009-11-30 (月) 13:02:47};
-Aloha! http://pharmaonline.pbworks.com/TramadolOnline buy tramadol online http://pharmaonline.pbworks.com/FioricetOnline cheap fioricet http://pharmaonline.pbworks.com/AdipexOnline adipex no prescription http://pharmaonline.pbworks.com/AtivanOnline ativan http://pharmaonline.pbworks.com/DiazepamOnline diazepam -- [[ativan]] &new{2009-11-30 (月) 13:05:38};
-Aloha! http://pharmaonline.pbworks.com/CiprofloxacinOnline ciprofloxacin http://pharmaonline.pbworks.com/HydrocodoneOnline hydrocodone no prescription http://pharmaonline.pbworks.com/AcompliaOnline acomplia http://pharmaonline.pbworks.com/VicodinOnline vicodin no rx -- [[hydrocodone no prescription]] &new{2009-11-30 (月) 13:18:37};
-Aloha! http://pharmaonline.pbworks.com/TamoxifenOnline tamoxifen http://pharmaonline.pbworks.com/AzithromycinOnline azithromycin http://pharmaonline.pbworks.com/AcyclovirOnline acyclovir http://pharmaonline.pbworks.com/FinasterideOnline finasteride http://pharmaonline.pbworks.com/ZoloftOnline zoloft -- [[acyclovir]] &new{2009-11-30 (月) 13:21:45};
-Aloha! http://www.epractice.eu/en/people/89950/professional xanax without prescription http://www.epractice.eu/en/people/89947/professional buy propecia http://www.epractice.eu/en/people/89948/professional phentermine http://www.epractice.eu/en/people/89949/professional valium without prescription http://www.epractice.eu/en/people/89951/professional ambien -- [[buy propecia]] &new{2009-11-30 (月) 13:32:43};
-Aloha! http://www.epractice.eu/en/people/89942/professional buy levitra http://www.epractice.eu/en/people/89945/professional clomid online http://www.epractice.eu/en/people/89939/professional viagra without prescription http://www.epractice.eu/en/people/89940/professional cialis http://www.epractice.eu/en/people/89946/professional accutane -- [[buy levitra]] &new{2009-11-30 (月) 13:38:43};
-Aloha! http://www.epractice.eu/en/people/89955/professional diazepam http://www.epractice.eu/en/people/89954/professional adipex no prescription http://www.epractice.eu/en/people/89956/professional cheap fioricet http://www.epractice.eu/en/people/89953/professional buy tramadol online http://www.epractice.eu/en/people/89952/professional ativan -- [[adipex no prescription]] &new{2009-11-30 (月) 13:46:43};
-Aloha! http://www.epractice.eu/en/people/89961/professional amoxicillin http://www.epractice.eu/en/people/89957/professional lorazepam http://www.epractice.eu/en/people/89960/professional alprazolam http://www.epractice.eu/en/people/89959/professional buy klonopin http://www.epractice.eu/en/people/89958/professional clonazepam -- [[amoxicillin]] &new{2009-11-30 (月) 13:55:36};
-Aloha! http://www.epractice.eu/en/people/89963/professional acyclovir http://www.epractice.eu/en/people/89966/professional zoloft http://www.epractice.eu/en/people/89962/professional furosemide http://www.epractice.eu/en/people/89964/professional finasteride http://www.epractice.eu/en/people/89967/professional azithromycin -- [[furosemide]] &new{2009-11-30 (月) 14:00:43};
-Aloha! http://www.epractice.eu/en/people/89971/professional hydrocodone no prescription http://www.epractice.eu/en/people/89973/professional vicodin no rx http://www.epractice.eu/en/people/89970/professional acomplia http://www.epractice.eu/en/people/89969/professional ciprofloxacin http://www.epractice.eu/en/people/89968/professional tamoxifen -- [[tamoxifen]] &new{2009-11-30 (月) 14:11:31};
-Aloha! http://www.box.net/shared/u2berjgoxu generic viagra http://www.box.net/shared/d3hdd02kf2 levitra online http://www.box.net/shared/0xeiy6odfx clomid http://www.box.net/shared/jisv0hctvm cialis online http://www.box.net/shared/gfa4lb5avx buy accutane -- [[cialis online]] &new{2009-11-30 (月) 14:15:45};
-Aloha! http://www.box.net/shared/6adpum2o8n phentermine no prescription http://www.box.net/shared/4jqs7b7it7 ambien http://www.box.net/shared/40h8v0kt5r buy valium online http://www.box.net/shared/87xjdc294a buy xanax http://www.box.net/shared/qq61k2xauq propecia -- [[buy valium online]] &new{2009-11-30 (月) 14:27:39};
-Aloha! http://www.box.net/shared/9nd4cdpq7k buy fioricet online http://www.box.net/shared/qd1hv0germ diazepam http://www.box.net/shared/uj4rbxgc51 tramadol online http://www.box.net/shared/60ccgvvxjk no prescription ativan http://www.box.net/shared/6ij5jxpxt4 adipex online -- [[no prescription ativan]] &new{2009-11-30 (月) 14:30:43};
-Aloha! http://www.box.net/shared/1u0946e90k clonazepam without prescription http://www.box.net/shared/pm5ffycjyb buy lorazepam online http://www.box.net/shared/r8yfloebq3 amoxicillin http://www.box.net/shared/3n553safcv klonopin online http://www.box.net/shared/fx62ydk7rr alprazolam without prescription -- [[amoxicillin]] &new{2009-11-30 (月) 14:44:30};
-Aloha! http://www.box.net/shared/n4m2914pox azithromycin http://www.box.net/shared/95jpyz9o3j acyclovir http://www.box.net/shared/pf27yk6407 finasteride http://www.box.net/shared/jx6xmkvshz zoloft http://www.box.net/shared/k68tgko6cb furosemide -- [[furosemide]] &new{2009-11-30 (月) 14:45:42};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=4d2a24d1c5f7087d8d06be71e6de9285 cialis online http://member.thinkfree.com/myoffice/show.se?f=1fd4b987198a1766a419bb2805ca16e5 levitra online http://member.thinkfree.com/myoffice/show.se?f=1fd4b987198a17668d06be71e6de9285 buy accutane http://member.thinkfree.com/myoffice/show.se?f=087aa241e31766bcb47b92dbc4d6a1bc generic viagra http://member.thinkfree.com/myoffice/show.se?f=1fd4b987198a1766a419bb2805ca16e5 clomid -- [[generic viagra]] &new{2009-11-30 (月) 15:00:45};
-Aloha! http://www.box.net/shared/f4jv2asa47 hydrocodone online http://www.box.net/shared/uysczm5bdh acomplia http://www.box.net/shared/f1no52yyjt ciprofloxacin http://www.box.net/shared/6ms4yxtjfy tamoxifen http://www.box.net/shared/d2emkc759c vicodin -- [[tamoxifen]] &new{2009-11-30 (月) 15:01:07};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f55b2a64fef013b61d7 no prescription ativan http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f5568316f75a595c1c1 adipex online http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c0645dd4c71d74f98eb diazepam http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c06b47b92dbc4d6a1bc buy fioricet online http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f558d06be71e6de9285 tramadol online -- [[adipex online]] &new{2009-11-30 (月) 15:16:45};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f55b47b92dbc4d6a1bc buy xanax http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f55a419bb2805ca16e5 ambien http://member.thinkfree.com/myoffice/show.se?f=507e90627cac9f5545dd4c71d74f98eb buy valium online http://member.thinkfree.com/myoffice/show.se?f=1fd4b987198a176606f1376320725045 phentermine no prescription http://member.thinkfree.com/myoffice/show.se?f=1fd4b987198a1766c531da3cdf006974 propecia -- [[buy xanax]] &new{2009-11-30 (月) 15:19:00};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ffa419bb2805ca16e5 acyclovir http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ff45dd4c71d74f98eb furosemide http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ff8d06be71e6de9285 azithromycin http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ffb2a64fef013b61d7 finasteride http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ff38f0d41fde4ffb82 zoloft -- [[zoloft]] &new{2009-11-30 (月) 15:31:48};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c06b2a64fef013b61d7 clonazepam without prescription http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c068d06be71e6de9285 alprazolam without prescription http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c06518bbecf9828d4b4 klonopin online http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c06a419bb2805ca16e5 buy lorazepam online http://member.thinkfree.com/myoffice/show.se?f=f02f5fc1cdc60c0668316f75a595c1c1 amoxicillin -- [[amoxicillin]] &new{2009-11-30 (月) 15:35:00};
-Aloha! http://www.docstoc.com/docs/16698890/acyclovir acyclovir http://www.docstoc.com/docs/16698855/accutane accutane http://www.docstoc.com/docs/16698886/acomplia acomplia http://www.docstoc.com/docs/16698924/alprazolam alprazolam http://www.docstoc.com/docs/16698917/adipex adipex no prescription -- [[accutane]] &new{2009-11-30 (月) 15:46:24};
-Aloha! http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ffc531da3cdf006974 tamoxifen http://member.thinkfree.com/myoffice/show.se?f=6a5b936386b048ff68316f75a595c1c1 ciprofloxacin http://member.thinkfree.com/myoffice/show.se?f=bc06cc336c30b7ecb2a64fef013b61d7 vicodin http://member.thinkfree.com/myoffice/show.se?f=bc06cc336c30b7ecb47b92dbc4d6a1bc hydrocodone online http://member.thinkfree.com/myoffice/show.se?f=bc06cc336c30b7ec45dd4c71d74f98eb acomplia -- [[ciprofloxacin]] &new{2009-11-30 (月) 15:50:10};
-Aloha! http://www.docstoc.com/docs/16698994/cialis cialis http://www.docstoc.com/docs/16698945/amoxicillin amoxicillin http://www.docstoc.com/docs/16698986/azithromycin azithromycin http://www.docstoc.com/docs/16698964/ativan ativan http://www.docstoc.com/docs/16698934/ambien ambien -- [[azithromycin]] &new{2009-11-30 (月) 16:01:28};
-Aloha! http://www.docstoc.com/docs/16699047/finasteride finasteride http://www.docstoc.com/docs/16699017/clomid clomid online http://www.docstoc.com/docs/16699031/diazepam diazepam http://www.docstoc.com/docs/16699025/clonazepam clonazepam http://www.docstoc.com/docs/16699004/ciprofloxacin ciprofloxacin -- [[finasteride]] &new{2009-11-30 (月) 16:07:10};
-Aloha! http://www.docstoc.com/docs/16699053/fioricet cheap fioricet http://www.docstoc.com/docs/16699068/hydrocodone hydrocodone no prescription http://www.docstoc.com/docs/16699089/levitra buy levitra http://www.docstoc.com/docs/16699060/furosemide furosemide http://www.docstoc.com/docs/16699080/klonopin buy klonopin -- [[buy levitra]] &new{2009-11-30 (月) 16:17:25};
-Aloha! http://www.docstoc.com/docs/16699110/propecia buy propecia http://www.docstoc.com/docs/16699095/lorazepam lorazepam http://www.docstoc.com/docs/16699104/phentermine phentermine http://www.docstoc.com/docs/16699120/tamoxifen tamoxifen http://www.docstoc.com/docs/16699130/tramadol buy tramadol online -- [[phentermine]] &new{2009-11-30 (月) 16:25:19};
-Aloha! http://www.docstoc.com/docs/16699144/viagraOnline viagra without prescription http://www.docstoc.com/docs/16699139/valium valium without prescription http://www.docstoc.com/docs/16699168/xanax xanax without prescription http://www.docstoc.com/docs/16699172/zoloft zoloft http://www.docstoc.com/docs/16699156/vicodin vicodin no rx -- [[xanax without prescription]] &new{2009-11-30 (月) 16:33:23};
-Aloha! http://www.asianave.com/buyCialisOnline12/ cheap cialis http://www.asianave.com/buyViagraOnline12/ buy viagra online http://www.asianave.com/buyClomidOnline12/ clomid http://www.asianave.com/buyLevitraOnline12/ levitra http://www.asianave.com/buyAccutaneOnline12/ accutane -- [[clomid]] &new{2009-11-30 (月) 16:43:11};
-Aloha! http://www.asianave.com/buyPropeciaOnline12/ buy propecia online http://www.asianave.com/buyPhentermine12/ phentermine http://www.asianave.com/buyXanaxOnline12/ xanax http://www.asianave.com/buyValiumOnline12/ valium http://www.asianave.com/buyAmbienOnline12/ buy ambien online -- [[buy propecia online]] &new{2009-11-30 (月) 16:48:30};
-Aloha! http://www.asianave.com/buyFioricetOnline12/ fioricet no rx http://www.asianave.com/buyDiazepamOnline12/ diazepam http://www.asianave.com/buyTramadolOnline12/ cheap tramadol http://www.asianave.com/buyAdipexOnline12/ buy adipex http://www.asianave.com/buyAtivanOnline12/ ativan -- [[ativan]] &new{2009-11-30 (月) 17:00:20};
-Aloha! http://www.asianave.com/AlprazolamOnline1/ alprazolam http://www.asianave.com/buyKlonopinOnline12/ clonazepam http://www.asianave.com/buyLorazepamOnline12/ lorazepam http://www.asianave.com/AmoxicillinOnline12/ amoxicillin http://www.asianave.com/buyClonazepamOnline1/ klonopin -- [[klonopin]] &new{2009-11-30 (月) 17:04:31};
-Aloha! http://www.asianave.com/buyAzithromycinOnlin/ azithromycin http://www.asianave.com/buyFinasterideOnline/ finasteride http://www.asianave.com/buyFurosemideOnline1/ furosemide http://www.asianave.com/buyZoloftOnline12/ zoloft http://www.asianave.com/buyAcyclovirOnline12/ acyclovir -- [[acyclovir]] &new{2009-11-30 (月) 17:18:32};
-Aloha! http://www.asianave.com/buyTamoxifenOnline12/ tamoxifen http://www.asianave.com/buyVicodinOnline12/ vicodin http://www.asianave.com/buyCiprofloxacinOnli/ ciprofloxacin http://www.asianave.com/buyAcompliaOnline12/ acomplia http://www.asianave.com/HydrocodoneOnline12/ hydrocodone -- [[acomplia]] &new{2009-11-30 (月) 17:20:31};

#comment
//#comment


トップ   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS