▲
0
0

report

Walkenbach J. - Excel 2007. Power Programming with VBA [2007, CHM, ENG] + Code

seeders: 3
leechers: 0
Download torrent
Added 16 years ago by aaillya in Books  > Non-Fiction
Download Fast Safe Anonymous
movies, software, shows...

Files

Walkenbach J. - Excel 2007. Power Programming with VBA [2007, CHM, ENG] + Code (Size: 60.04 MB)
  Excel2007PowerProgrammingWithVBA.chm 37.5 MB
  Sample Files
  Chapter 03
  array formula examples.xlsx 47.81 KB
  counting and summing examples.xlsx 10.53 KB
  extended date functions help.docx 19.64 KB
  extended date functions.xlsm 31.62 KB
  megaformula.xlsm 21.25 KB
  named formulas.xlsx 18.3 KB
  Chapter 04
  sample.xlsm 29.11 KB
  Chapter 06
  worksheet controls.xlsx 73.1 KB
  Chapter 07
  comment object.xlsm 30.45 KB
  Chapter 08
  timing test.xlsm 14.89 KB
  Chapter 09
  sheet sorter.xlsm 22.89 KB
  Chapter 10
  array argument.xlsm 12.89 KB
  commission functions.xlsm 23.58 KB
  draw.xlsm 17.31 KB
  key press.xlsm 25.88 KB
  month names.xlsm 18.27 KB
  mysum function.xlsm 22.98 KB
  no argument.xlsm 18.32 KB
  remove vowels.xlsm 16.54 KB
  upper case.xlsm 393.83 KB
  win32api.txt 683.16 KB
  windows directory.xlsm 17.03 KB
  Chapter 11
  about range selection.xlsm 21.44 KB
  batch processing.xlsm 19.38 KB
  celltype function.xlsm 18.5 KB
  copy multiple selection.xlsm 19.65 KB
  date and time.xlsm 19.97 KB
  delete empty rows.xlsm 86.68 KB
  drive information.xlsm 22.63 KB
  duplicate rows.xlsm 15.19 KB
  efficient looping.xlsm 16.76 KB
  file association.xlsm 18.7 KB
  hide rows and columns.xlsm 14.54 KB
  inputbox demo.xlsm 18.6 KB
  inrange function.xlsm 17.1 KB
  list fonts.xlsm 14.5 KB
  loop vs array fill range.xlsm 18.83 KB
  myworkbook.xlsx 9.68 KB
  next empty cell.xlsm 14.57 KB
  page count.xlsm 36.77 KB
  printer info.xlsm 19.24 KB
  prompt for a range.xlsm 13.48 KB
  range selections.xlsm 28.96 KB
  select by value.xlsm 25.32 KB
  sorting demo.xlsm 38.93 KB
  sound.wav 6.98 KB
  sound.xlsm 22.89 KB
  synchronize sheets.xlsm 17.24 KB
  text01.txt 674 B
  text02.txt 934 B
  text03.txt 1.17 KB
  value from a closed workbook.xlsm 15.98 KB
  variant transfer.xlsm 89.99 KB
  video mode.xlsm 19.49 KB
  windows registry.xlsm 23.86 KB
  worksheet functions.xlsm 40.91 KB
  Chapter 12
  VBA inputbox.xlsm 18.37 KB
  data form example.xlsm 47.95 KB
  get directory.xlsm 22.8 KB
  inputbox method.xlsm 15.22 KB
  ribbon control names.xlsx 112.46 KB
  Chapter 13
  activex worksheet controls.xlsx 73.41 KB
  all userform controls.xlsm 91.37 KB
  get name and sex.xlsm 25.42 KB
  newcontrols.pag 12.5 KB
  spinbutton and textbox.xlsm 21.1 KB
  spinbutton events.xlsm 23.91 KB
  userform events.xlsm 23.74 KB
  Chapter 14
  change userform size.xlsm 30.72 KB
  date and time picker.xlsm 17.67 KB
  fill listbox.xlsm 22.5 KB
  listbox activate sheet.xlsm 34.21 KB
  listbox item transfer.xlsm 21.47 KB
  listbox move items.xlsm 21.75 KB
  listbox multicolumn1.xlsm 16.17 KB
  listbox multicolumn2.xlsm 15.71 KB
  listbox multiple lists.xlsm 22.48 KB
  listbox select rows.xlsm 35.5 KB
  listbox selected items.xlsm 21.23 KB
  listbox unique items1.xlsm 25.62 KB
  listbox unique items2.xlsm 24.87 KB
  multipage control demo.xlsm 17.69 KB
  queryclose demo.xlsm 20.43 KB
  random number generator.xlsm 17.25 KB
  range selection demo.xlsm 25.29 KB
  splash screen.xlsm 99.52 KB
  userform menus.xlsm 22.92 KB
  zoom and scroll sheet.xlsm 307.73 KB
  zoom userform.xlsm 20.73 KB
  Chapter 15
  chart in userform.xlsm 40.96 KB
  dataform
  dataform2.txt 814 B
  dataform2.xla 165 KB
  getacolor function.xlsm 32.85 KB
  modeless userform1.xlsm 33.56 KB
  modeless userform2.xlsm 34.64 KB
  move controls.xlsm 280.61 KB
  msgbox emulation.xlsm 40.89 KB
  multiple buttons.xlsm 22.37 KB
  no title bar.xlsm 357.98 KB
  progress indicator1.xlsm 21.92 KB
  progress indicator2.xlsm 23.26 KB
  progress indicator3.xlsm 22.99 KB
  resizable userform.xlsm 23.5 KB
  simulated toolbar.xlsm 24.41 KB
  sliding tile puzzle.xlsm 27.69 KB
  splash screen2.xlsm 100.61 KB
  wizard demo.xlsm 42.53 KB
  Chapter 16
  helpsource
  readme.txt 81 B
  styles.css 5.83 KB
  texttools.chm 13.88 KB
  texttools.hhp 376 B
  texttools1.htm 1.44 KB
  texttools2.htm 1.84 KB
  texttools3.htm 3.67 KB
  simple undo demo.xlsm 26.1 KB
  text tools.xlam 35.3 KB
  texttools.chm 13.88 KB
  Chapter 17
  budget pivot table.xlsm 615.85 KB
  reverse pivot table.xlsm 34.88 KB
  simple pivot table.xlsm 16.07 KB
  survey data pivot tables.xlsm 84.27 KB
  Chapter 18
  animated charts.xlsm 61.52 KB
  chart active cell.xlsm 50.46 KB
  chart image map.xlsm 34.7 KB
  chart in userform.xlsm 27.26 KB
  climate data.xlsx 99.14 KB
  data labels.xlsm 25.88 KB
  events - chart sheet.xlsm 24.61 KB
  events - embedded chart.xlsm 26.19 KB
  export all graphics.xlsm 14.56 KB
  format a chart.xlsm 17.36 KB
  format all charts.xlsm 31.44 KB
  get series ranges.xlsm 33.98 KB
  hide and unhide series.xlsm 30.75 KB
  hypocycloid - animated.xlsm 100.59 KB
  mouseover event - chart sheet.xlsm 19.42 KB
  mouseover event - embedded.xlsm 21.08 KB
  scrolling chart.xlsm 172.32 KB
  size and align charts.xlsm 36.96 KB
  slide show.xlsm 31.88 KB
  unlinked chart.xlsm 14.63 KB
  vba clock chart.xlsm 26.38 KB
  Chapter 19
  application event tracker.xlsm 30.31 KB
  hide columns before printing.xlsm 15 KB
  log workbook open.xlsm 21.56 KB
  make formulas bold.xlsm 14.07 KB
  no shortcut menus.xlsm 13.9 KB
  onkey event demo.xlsm 18.95 KB
  ontime event demo.xlsm 14.42 KB
  shade active row and column.xlsm 17.85 KB
  validate entry1.xlsm 19.43 KB
  validate entry2.xlsm 22.41 KB
  validate entry3.xlsm 12.75 KB
  workbook_beforeclose workaround.xlsm 14 KB
  Chapter 20
  automate excel.docm 21.05 KB
  budget data.accdb 6.13 MB
  control panel dialogs.xlsm 20.19 KB
  flower.jpg?042148 55.26 KB
  make memos.xlsm 30.92 KB
  mortgagecalcs.xlsx 12.74 KB
  personalized email - OE sendkeys.xlsm 16.76 KB
  personalized email - outlook (late binding).xlsm 17.13 KB
  personalized email - outlook.xlsm 17.17 KB
  send pdf via outlook.xlsm 19.01 KB
  shellexecute examples.xlsm 16.92 KB
  simple ado example.xlsm 19.99 KB
  start calculator.xlsm 23.07 KB
  textfile.txt 47 B
  Chapter 21
  check addin.xlam 16.77 KB
  list add-in information.xlsm 15.55 KB
  text tools helpsource
  readme.txt 81 B
  styles.css 5.98 KB
  texttools.chm 14.15 KB
  texttools.hhp 376 B
  texttools1.htm 1.44 KB
  texttools2.htm 1.95 KB
  texttools3.htm 4.26 KB
  text tools.xlsm 49.02 KB
  texttools.chm 14.15 KB
  Chapter 22
  dynamicmenu.xlsm 27.57 KB
  mso image browser.xlsm 279.47 KB
  old-style toolbar.xlsm 16.2 KB
  page break display add-in.xlam 18.47 KB
  page break display.xlsm 32.75 KB
  ribbon control names.xlsx 112.43 KB
  ribbon controls demo.xlsm 69.9 KB
  ribbon modification.xlsm 13.17 KB
  Chapter 23
  add to cell shortcut.xlsm 15.02 KB
  new shortcut menu.xlsm 23.43 KB
  shortcut with submenu.xlsm 24.51 KB
  show faceids.xlsm 58.16 KB
  show shortcut menu items.xlsm 15.42 KB
  show shortcut menu names.xlsm 13.3 KB
  Chapter 24
  cell comments
  formletter.xlsm 46.02 KB
  function help
  help source files
  Table of Contents.hhc 804 B
  Topic1.htm 488 B
  Topic2.htm 459 B
  myfuncs.ali 73 B
  myfuncs.chm 10.96 KB
  myfuncs.h 63 B
  myfuncs.hhp 559 B
  topic0.htm 182 B
  myfuncs.chm 10.96 KB
  myfuncs.xlsm 19.62 KB
  html help
  formletter.chm 11.34 KB
  formletter.xlsm 41.03 KB
  help source files
  Table of Contents.hhc 1.33 KB
  Topic1.htm 269 B
  Topic2.htm 367 B
  Topic3.htm 348 B
  Topic4.htm 318 B
  Topic5.htm 367 B
  formletter.chm 11.34 KB
  formletter.hhp 809 B
  topic6.htm 348 B
  mhtml file
  formletter.xlsm 40.63 KB
  help.mht 69.05 KB
  helpsource.xlsx 14.29 KB
  textbox
  formletter.xlsm 29.08 KB
  userform1
  formletter.xlsm 49.41 KB
  userform2
  formletter.xlsm 46.36 KB
  userform3
  formletter.xlsm 47.88 KB
  web browser
  formletter.xlsm 26.37 KB
  styles.css 1.27 KB
  topic1.htm 663 B
  topic2.htm 466 B
  topic3.htm 453 B
  topic4.htm 423 B
  topic5.htm 472 B
  topic6.htm 467 B
  worksheet
  formletter.xlsm 46.94 KB
  Chapter 25
  loan amortization wizard.xlam 102.67 KB
  Chapter 26
  multilingual wizard.xlsm 46.7 KB
  Chapter 27
  create file list.xlsm 20.73 KB
  export and import csv.xlsm 27.23 KB
  export to HTML.xlsm 17.46 KB
  export to XML.xlsm 17.79 KB
  file functions.xlsm 13.24 KB
  file information.xlsm 18.49 KB
  filter text file.xlsm 21.21 KB
  recursive file list.xlsm 20.87 KB
  show drive info.xlsm 15.02 KB
  unzip a file.xlsm 14.44 KB
  zip files.xlsm 15.5 KB
  Chapter 28
  UpdateUserBook.xlsm 22.29 KB
  UserBook.xlsm 19.6 KB
  add 100 buttons.xlsm 23.26 KB
  add button and code.xlsm 24.11 KB
  create userform on the fly.xlsm 20.54 KB
  getoption function.xlsm 29.25 KB
  list VB components.xlsm 22.38 KB
  list all procedures.xlsm 17.25 KB
  Chapter 29
  csv class.xlsm 25.96 KB
  keyboard class.xlsm 29 KB
  Chapter 30
  chart colors.xlsm 22.96 KB
  chart to grayscale picture.xlsm 21.77 KB
  color conversion functions.xlsm 49.06 KB
  document theme demo.xlsx 19.2 KB
  generate theme colors.xlsm 16.07 KB
  rgb color demo.xlsm 24.99 KB
  shape object colors.xlsm 16.52 KB
  tintandshade demo.xlsm 22.83 KB
  weirddog.jpg?042148 10.15 KB
  Install.exe 7.26 MB

Description




Книги и журналы » Компьютерная литература » Программы от Microsoft

Excel 2007 Power Programming with VBA + ПРИМЕРЫ

Год выпуска: 2007
Автор: John Walkenbach / Джон Уокенбах
Жанр: Практическое пособие
Издательство: Wiley Publishing, Inc.
Серия: Учебная
Язык: Английский
ISBN: 978-0-470-04401-8
Формат: CHM
Качество: eBook (изначально компьютерное)
Количество страниц: 1099
Описание: This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it will show you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.
Эта книга посвящена языку программирования Visual Basic for Applications (VBA), встроенному в Excel (и другие приложения Microsoft Office). Она научит вас, писать программы, которые автоматизируют решение различных задач: от записи простого макроопределения до создания солидных приложений и утилит.
Доп. информация: Примеры в папке [Sample Files]
[spoiler="Скриншоты:"]

[/spoiler]

Related Torrents

torrent name size uploader age seed leech
Walkenbach J. - Office 2010 Bible‎ [2010, PDF, ENG] Posted by Danilov in Books  > Non-Fiction
19.07 MB Danilov 15 years 3 0
Alexander M., Walkenbach J. - Excel Dashboards and Reports [2010, PDF, ENG] Posted by Danilov in Books  > Non-Fiction
14.47 MB Danilov 15 years 4 0
Walkenbach J. - Favorite Excel 2010. Tips and Tricks [2010, PDF, ENG] Posted by aaillya in Books  > Non-Fiction
13.03 MB aaillya 15 years 3 0
Walkenbach J. - Excel VBA Programming For Dummies, 2nd Edition [2010, PDF, ENG] Posted by aaillya in Books  > Non-Fiction
6.54 MB aaillya 15 years 4 0
Walkenbach J., Banfield C. - Microsoft Excel 2007 For Dummies. Quick Reference [2007, PDF, ENG] Posted by aaillya in Books  > Non-Fiction
5.99 MB aaillya 16 years 6 0