본문내용 바로가기
무료배송 소득공제 정가제free

해외주문 [Book] Excel 2007 VBA Programmer's Reference

Programmer to Programmer | Paperback
Green, John , Bullen, Stephen , Bovey, Rob 지음 | Wrox Press | 2007년 03월 01일
  • 정가 : 57,590원
    판매가 : 45,500 [21%↓ 12,090원 할인] 할인쿠폰 받기
  • 혜택 :
    [기본적립] 460원 적립 [1% 적립] [추가적립] 5만원 이상 구매 시 2,000원 추가적립 안내 [회원혜택] 회원 등급 별, 3만원 이상 구매 시 2~4% 추가적립 안내
  • 추가혜택 : 도서소득공제 안내 추가혜택 더보기
  • 배송비 : 무료 배송비 안내
  • [배송일정] 근무일 기준 14일 이내 출고 예정 배송일정 안내
    해외주문도서는 해외 거래처 사정에 의해 품절/지연될수 있습니다.
    스페셜오더 도서나 일서해외주문도서와 함께 주문시 배송일이 이에 맞추어 지연되오니, 이점 유의해주시기 바랍니다.

알립니다.

  • 해외주문도서는 고객님의 요청에 의해 주문하는 '개인 오더' 상품이기 때문에, 단순한 고객변심/착오로 인한 취소,반품, 교환의 경우 '해외주문 반품/취소 수수료'를 부담하셔야 합니다. 이점 유의하여 주시기 바랍니다. 반품/취소 수수료 : (1)서양도서-판매정가의 12%, (2)일본도서-판매정가의 7% (반품/취소 수수료는, 수입제반비용(FedEx수송비용, 관세사비, 보세창고료, 내륙 운송비, 통관비 등)과 재고리스크(미판매 리스크, 환차손)에 따른 비용을 포함하며, 서양도서는 판매정가의 12%, 일본도서는 판매정가의 7%가 적용됩니다.)
  • 외국도서의 경우 해외제공정보로만 서비스되어 미표기된 정보가 있을 수 있습니다. 필요한 정보가 있을경우 1:1 문의게시판 을 이용하여 주십시오.
상품상세정보
ISBN 9780470046432(0470046430)
쪽수 1143쪽
언어 English
크기 187(W) X 233(H) X 55(T) (mm)
제본형태 Paperback
총권수 1권
Textual Format Computer Applications
리딩지수 Level Scholarly/Undergraduate

책소개

이 책이 속한 분야

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.
이 책의 상품구성
* 해당 상품의 상세구성정보를 준비중입니다.

목차


Acknowledgments xxi
Introduction xxiii
Primer in Excel VBA 1(62)
Using the Macro Recorder 2(15)
Recording Macros 2(4)
Running Macros 6(2)
The Visual Basic Editor 8(3)
Other Ways to Run Macros 11(6)
User-Defined Functions 17(4)
Creating a UDF 18(3)
What UDFs Cannot Do 21(1)
The Excel Object Model 21(9)
Objects 22(5)
Getting Help 27(2)
Experimenting in the Immediate Window 29(1)
The VBA Language 30(32)
Basic Input and Output 30(5)
Calling Functions and Sub Procedures 35(2)
Parentheses and Argument Lists 37(1)
Variable Declaration 38(2)
Scope and Lifetime of Variables 40(2)
Variable Type 42(3)
Object Variables 45(2)
Making Decisions 47(3)
Looping 50(5)
Arrays 55(4)
Run-Time Error-Handling 59(3)
Summary 62(1)
The Application Object 63(14)
Globals 63(1)
The Active Properties 64(1)
Display Alerts 65(1)
Screen Updating 66(1)
Evaluate 66(2)
InputBox 68(2)
StatusBar 70(1)
Send Keys 70(1)
On Time 71(1)
OnKey 72(1)
Worksheet Functions 73(1)
Caller 74(1)
Summary 75(2)
Workbooks and Worksheets 77(16)
The Workbooks Collection 77(6)
Getting a Filename from a Path 78(3)
Files in the Same Directory 81(1)
Overwriting an Existing Workbook 81(1)
Saving Changes 82(1)
The Sheets Collection 83(6)
Worksheets 83(2)
Copy and Move 85(2)
Grouping Worksheets 87(2)
The Window Object 89(2)
Synchronizing Worksheets 90(1)
Summary 91(2)
Using Ranges 93(32)
Activate and Select 93(2)
Range Property 95(7)
Shortcut Range References 96(1)
Ranges on Inactive Worksheets 96(1)
Range Property of a Range Object 97(1)
Cells Property 97(1)
Cells Used in Range 98(1)
Ranges of Inactive Worksheets 99(1)
More on the Cells Property of the Range Object 99(2)
Single-Parameter Range Reference 101(1)
Offset Property 102(1)
Resize Property 103(2)
SpecialCells Method 105(3)
Last Cell 105(2)
Deleting Numbers 107(1)
CurrentRegion Property 108(2)
End Property 110(1)
Referring to Ranges with End 110(1)
Summing a Range 111(1)
Columns and Rows Properties 112(3)
Areas 113(2)
Union and Intersect Methods 115(1)
Empty Cells 115(3)
Transferring Values between Arrays and Ranges 118(5)
Deleting Rows 121(2)
Summary 123(2)
Using Names 125(16)
Naming Ranges 127(1)
Using the Name Property of the Range Object 128(1)
Special Names 128(1)
Storing Values in Names 129(1)
Storing Arrays 130(1)
Hiding Names 131(1)
Working with Named Ranges 132(1)
Searching for a Name 133(6)
Searching for the Name of a Range 135(1)
Determining which Names Overlap a Range 136(3)
Summary 139(2)
Data Lists 141(20)
Structuring the Data 141(1)
Sorting a Range 142(2)
Older Excel Versions 144(1)
Creating a Table 144(1)
Sorting a Table 145(1)
AutoFilter 146(10)
AutoFilter Object 147(1)
Filter Object 148(1)
Date Custom Filter 148(1)
Adding Combo Boxes 149(4)
Copying the Visible Rows 153(1)
Finding the Visible Rows 154(2)
Advanced Filter 156(2)
Data Form 158(1)
Summary 159(2)
PivotTables 161(20)
Creating a PivotTable Report 162(4)
PivotCaches 165(1)
PivotTables Collection 165(1)
PivotFields 166(5)
CalculatedFields 170(1)
Pivotltems 171(6)
Grouping 171(4)
Visible Property 175(1)
Calculatedltems 176(1)
PivotCharts 177(1)
External Data Sources 178(2)
Summary 180(1)
Charts 181(18)
Chart Sheets 182(3)
The Recorded Macro 184(1)
Adding a Chart Sheet Using VBA Code 184(1)
Embedded Charts 185(2)
Using the Macro Recorder 186(1)
Adding an Embedded Chart Using VBA Code 186(1)
Editing Data Series 187(3)
Defining Chart Series with Arrays 190(3)
Converting a Chart to Use Arrays 193(1)
Determining the Ranges Used in a Chart 194(1)
Chart Labels 195(1)
Summary 196(3)
Event Procedures 199(10)
Worksheet Events 199(3)
Enable Events 200(1)
Worksheet Calculate 201(1)
Chart Events 202(3)
Before Double Click 202(3)
Workbook Events 205(2)
Save Changes 206(1)
Headers and Footers 207(1)
Summary 208(1)
Adding Controls 209(14)
Form and ActiveX Controls 209(1)
ActiveX Controls 210(4)
Scrollbar Control 211(1)
Spin Button Control 211(1)
CheckBox Control 212(1)
Option Button Controls 212(2)
Forms Controls 214(2)
Dynamic ActiveX Controls 216(4)
Controls on Charts 220(1)
Summary 221(2)
Text Files and File Dialog 223(16)
Opening Text Files 223(1)
Writing to Text Files 224(2)
Reading Text Files 226(1)
Writing to Text Files Using Print 227(6)
Reading Data Strings 229(1)
Flexible Separators and Delimiters 230(3)
FileDialog 233(5)
FileDialogFilters 235(1)
FileDialogSelectedltems 235(1)
Dialog Types 235(1)
Execute Method 235(1)
MultiSelect 236(2)
Summary 238(1)
Working with XML and the Open XML File Formats 239(34)
The Basics of Using XML Data in Excel 240(13)
XML Fundamentals 240(6)
Consuming XML Data Directly 246(3)
Creating and Managing Your Own XML Maps 249(4)
Using VBA to Program XML Processes 253(12)
Programming XML Maps 253(5)
Leveraging DOM and XPath to Manipulate XML Files 258(7)
Using VBA to Program Open XML Files 265(7)
Programming Open XML Files with VBA 266(1)
Programmatically Zipping an Excel Container 267(5)
Summary 272(1)
UserForms 273(20)
Displaying a UserForm 273(2)
Creating a UserForm 275(2)
Directly Accessing Controls in UserForms 277(4)
Stopping the Close Button 281(1)
Maintaining a Data List 282(6)
Modeless UserForms 288(3)
Progress Indicator 288(3)
Variable UserForm Name 291(1)
Summary 291(2)
RibbonX 293(26)
Overview 293(1)
Prerequisites 294(1)
Adding the Customizations 294(1)
XML Structure 295(3)
RibbonX and VBA 298(1)
Control Types 299(2)
Basic Controls 299(1)
Container Controls 300(1)
Control Attributes 301(2)
Control Callbacks 303(2)
Managing Control Images 305(2)
Other RibbonX Elements, Attributes, and Callbacks 307(7)
Sharing Controls among Multiple Workbooks 308(1)
Updating Controls at Run Time 309(2)
Hooking Built-in Controls 311(1)
RibbonX in Dictator Applications 312(1)
Customizing the Office Menu 312(1)
Customizing the QAT 313(1)
Controlling Tabs, Tab Sets, and Groups 313(1)
Dynamic Controls 314(2)
dropDown, comboBox, and gallery 315(1)
dynamicMenu 315(1)
CommandBar Extensions for the Ribbon 316(1)
RibbonX Limitations 317(1)
Summary 318(1)
Command Bars 319(36)
Toolbars, Menu Bars, and Popups 320(2)
Excel's Built-in Command Bars 322(3)
Controls at All Levels 325(5)
Facelds 328(2)
Creating New Menus 330(3)
The OnAction Macros 332(1)
Passing Parameter Values 333(1)
Deleting a Menu 334(1)
Creating a Toolbar 335(3)
Popup Menus 338(4)
Showing Popup Command Bars 342(12)
Table-Driven Command Bar Creation 344(10)
Summary 354(1)
Class Modules 355(18)
Creating Your Own Objects 356(1)
Property Procedures 357(2)
Creating Collections 359(4)
Class Module Collection 360(3)
Encapsulation 363(1)
Trapping Application Events 363(2)
Embedded Chart Events 365(3)
A Collection of UserForm Controls 368(2)
Referencing Classes Across Projects 370(1)
Summary 371(2)
Add-ins 373(10)
Hiding the Code 374(1)
Creating an Add-in 374(1)
Closing Add-ins 375(1)
Code Changes 376(1)
Saving Changes 377(1)
Interface Changes 377(2)
Installing an Add-in 379(2)
Addinlnstall Event 381(1)
Removing an Add-in from the Add-ins List 381(1)
Summary 382(1)
Automation Add-Ins and COM Add-Ins 383(28)
Automation Add-Ins 383(11)
A Simple Add-In --- Sequence 384(1)
Registering Automation Add-Ins with Excel 385(1)
Using Automation Add-Ins 386(2)
Introducing the IDTExtensibility2 Interface 388(6)
COM Add-Ins 394(15)
The IDTExtensibility2 Interface (Continued) 395(1)
Registering a COM Add-In with Excel 395(1)
The COM Add-In Designer 396(13)
Summary 409(2)
Interacting with Other Office Applications 411(20)
Establishing the Connection 411(5)
Late Binding 412(2)
Early Binding 414(2)
Opening a Document in Word 416(1)
Accessing an Active Word Document 417(1)
Creating a New Word Document 418(1)
Access and ADO 419(1)
Access, Excel, and, Outlook 420(3)
Better than Mail Merge 423(7)
Readable Document Variables 428(2)
Summary 430(1)
Data Access with ADO 431(38)
An Introduction to Structured Query Language (SQL) 431(5)
The SELECT Statement 432(2)
The INSERT Statement 434(1)
The UPDATE Statement 434(1)
The DELETE Statement 435(1)
An Overview of ADO 436(32)
The Connection Object 437(4)
The Recordset Object 441(4)
The Command Object 445(2)
Using ADO in Microsoft Excel Applications 447(1)
Using ADO with Microsoft Access 448(6)
Using ADO with Microsoft SQL Server 454(9)
Using ADO with Non-Standard Data Sources 463(5)
Summary 468(1)
Managing External Data 469(22)
The External Data User Interface 469(3)
Get External Data 470(1)
Manage Connections 471(1)
The QueryTable and ListObject 472(15)
A QueryTable from a Relational Database 472(3)
A Query Table Associated with a ListObject 475(1)
QueryTables and Parameter Queries 476(3)
QueryTables from Web Queries 479(3)
A QueryTable from a Text File 482(2)
Creating and Using Connection Files 484(3)
The WorkbookConnection Object and the Connections Collection 487(2)
External Data Security Settings 489(1)
Summary 490(1)
The Trust Center and Document Security 491(16)
The Trust Center 491(12)
Trusted Publishers 492(1)
Trusted Locations 492(2)
Add-ins 494(1)
ActiveX Settings 495(2)
Macro Settings 497(1)
Message Bar 498(1)
External Content 499(2)
Privacy Options 501(2)
Automating Document Inspection 503(3)
The RemoveDocumentlnformation Method 503(2)
The Documentinspectors Collection 505(1)
Summary 506(1)
Browsing OLAP Data Sources with Excel 507(18)
Analyzing OLAP Data via Pivot Tables 508(4)
Connecting to an OLAP Data Source 508(2)
Browsing the OLAP Data Source 510(2)
Understanding the MDX behind OLAP-based Pivot Tables 512(5)
The Basics of MDX 513(4)
Browsing OLAP Data Sources without Pivot Tables 517(4)
Using ADO to Return Flattened Recordsets 517(1)
Using ADO MD to Get Cube Schema Information 518(1)
Creating an Inventory of Dimensions, Hierarchies, and Levels 519(2)
Creating Offline Cubes 521(2)
Creating an Offline Cube Manually 521(1)
Using the CreateCubeFile Method 521(1)
Creating an Offline Cube Using ADO MD and VBA 522(1)
Summary 523(2)
Excel and the Internet 525(12)
What Can the Internet Do for You? 526(1)
Using the Internet for Storing Workbooks 526(1)
Using the Internet as a Data Source 527(4)
Opening Web Pages as Workbooks 528(1)
Using Web Queries 528(2)
Parsing Web Pages for Specific Information 530(1)
Using the Internet to Publish Results 531(2)
Setting Up a Web Server 532(1)
Saving Worksheets as Web Pages 532(1)
Creating Interactive Web Pages 533(1)
Using the Internet as a Communication Channel 533(3)
Communicating with a Web Server 534(2)
Summary 536(1)
International Issues 537(34)
Changing Windows Regional Settings and the Office 2007 UI Language 537(1)
Responding to Regional Settings and the Windows Language 538(7)
Identifying the User's Regional Settings and Windows Language 538(1)
VBA Conversion Functions from an International Perspective 539(6)
Interacting with Excel 545(4)
Sending Data to Excel 545(3)
Reading Data from Excel 548(1)
The Rules for Working with Excel 548(1)
Interacting with Users 549(3)
Paper Sizes 549(1)
Displaying Data 549(1)
Interpreting Data 550(1)
The xxxLocal Properties 550(1)
The Rules for Working with Your Users 551(1)
Excel 2007's International Options 552(2)
Features That Don't Play by the Rules 554(5)
The OpenText Function 555(1)
The SaveAs Function 556(1)
The ShowDataForm Sub Procedure 556(1)
Pasting Text 557(1)
PivotTable Calculated Fields and Items, and Conditional Format and Data Validation Formulas 557(1)
Web Queries 558(1)
=TEXT() Worksheet Function 558(1)
The Range.Value, Range.Formula, and Range.FormulaArray Properties 559(1)
The Range.AutoFilter Method 559(1)
The Range.AdvancedFilter Method 559(1)
The Application.Evaluate, Application.ConvertFormula, and Application.ExecuteExcel4Macro Functions 560(1)
Responding to Office 2007 Language Settings 560(5)
Where Does the Text Come From? 560(2)
Identifying the Office Ul Language Settings 562(1)
Creating a Multilingual Application 562(2)
Working in a Multilingual Environment 564(1)
The Rules for Developing a Multilingual Application 565(1)
Some Helpful Functions 565(3)
The bWinToNum Function 566(1)
The bWinToDate Function 566(1)
The sFormatDate Function 567(1)
The ReplaceHolders Function 568(1)
Summary 568(3)
Programming the VBE 571(30)
Identifying VBE Objects in Code 572(3)
The VBE Object 572(1)
The VBProject Object 572(1)
The VBComponent Object 573(1)
The CodeModule Object 574(1)
The CodePane Object 574(1)
The Designer Object 574(1)
Starting Up 575(1)
Adding Menu Items to the VBE 576(4)
Working with Workbooks 580(9)
Working with Code 589(5)
Working with UserForms 594(4)
Working with References 598(1)
COM Add-ins 599(1)
Summary 600(1)
Programming with the Windows API 601(34)
Anatomy of an API Call 602(1)
Interpreting C-Style Declarations 603(3)
Constants, Structures, Handles, and Classes 606(3)
What If Something Goes Wrong? 609(2)
Wrapping API Calls in Class Modules 611(5)
Some Example Classes 616(6)
A High-Resolution Timer Class 616(1)
Class Module CHighResTimer 616(2)
Freeze a UserForm 618(1)
A System Info Class 619(3)
Modifying UserForm Styles 622(3)
Window Styles 623(1)
The CFormChanger Class 624(1)
Resizable UserForms 625(9)
Absolute Changes 626(1)
Relative Changes 627(1)
The CFormResizer Class 628(6)
Summary 634(1)
Appendix A: Excel 2007 Object Model 635(336)
Appendix B: VBE Object Model 971(24)
Appendix C: Office 2007 Object Model 995(84)
Index 1079

간단리뷰 (0)

0/1000자
컨텐츠평가
5점 만점에
0점 1점 2점 3점 4점 5점
이미지첨부
(파일용량은 1MB 이하이며, 파일형식은 jpg, jpeg 파일만 업로드 가능합니다.)

    교환/반품/품절안내

    ※ 상품 설명에 반품/교환 관련한 안내가 있는 경우 그 내용을 우선으로 합니다. (업체 사정에 따라 달라질 수 있습니다.)

    교환/반품/품절안내
    반품/교환방법 마이룸 > 주문관리 > 주문/배송내역 > 주문조회 > 반품/교환신청 ,
    [1:1상담>반품/교환/환불] 또는 고객센터 (1544-1900)

    ※ 오픈마켓, 해외배송주문, 기프트 주문시 [1:1상담>반품/교환/환불]
        또는 고객센터 (1544-1900)
    반품/교환가능 기간 변심반품의 경우 수령 후 7일 이내,
    상품의 결함 및 계약내용과 다를 경우 문제점 발견 후 30일 이내
    반품/교환비용 변심 혹은 구매착오로 인한 반품/교환은 반송료 고객 부담
    반품/교환 불가 사유
    • 소비자의 책임 있는 사유로 상품 등이 손실 또는 훼손된 경우
      (단지 확인을 위한 포장 훼손은 제외)
    • 소비자의 사용, 포장 개봉에 의해 상품 등의 가치가 현저히 감소한 경우
      예) 화장품, 식품, 가전제품(악세서리 포함) 등
    • 복제가 가능한 상품 등의 포장을 훼손한 경우
      예) 음반/DVD/비디오, 소프트웨어, 만화책, 잡지, 영상 화보집
    • 소비자의 요청에 따라 개별적으로 주문 제작되는 상품의 경우 ((1)해외주문도서)
    • 디지털 컨텐츠인 eBook, 오디오북 등을 1회 이상 다운로드를 받았을 경우
    • 시간의 경과에 의해 재판매가 곤란한 정도로 가치가 현저히 감소한 경우
    • 전자상거래 등에서의 소비자보호에 관한 법률이 정하는 소비자 청약철회 제한 내용에
      해당되는 경우
    (1) 해외주문도서 : 이용자의 요청에 의한 개인주문상품으로 단순변심 및 착오로 인한 취소/교환/반품 시 ‘해외주문 반품/취소 수수료’ 고객 부담 (해외주문 반품/취소 수수료 : ①서양도서-판매정가의 12%, ②일본도서-판매정가의 7%를 적용)
    상품 품절 공급사(출판사) 재고 사정에 의해 품절/지연될 수 있으며, 품절 시 관련 사항에 대해서는
    이메일과 문자로 안내드리겠습니다.
    소비자 피해보상
    환불지연에 따른 배상
    • 상품의 불량에 의한 교환, A/S, 환불, 품질보증 및 피해보상 등에 관한 사항은
      소비자분쟁해결 기준 (공정거래위원회 고시)에 준하여 처리됨
    • 대금 환불 및 환불지연에 따른 배상금 지급 조건, 절차 등은 전자상거래 등에서의
      소비자 보호에 관한 법률에 따라 처리함

    이 분야의 신간

    더보기+
    바로가기
    • 우측 확장형 배너 2
    • 우측 확장형 배너 2
    최근 본 상품