TorBT - Torrents and Magnet Links Search Engine
M.Alexander - Excel 2016 Power Programming with VBA - 2016
- Date: 2023-10-13
- Size: 63 MB
- Files: 268
File Name
Size
M.Alexander - Excel 2016 Power Programming with VBA - 2016.pdf
24 MB
Snippets/Chapter01/worksheet controls.xlsx
69 kB
Snippets/Chapter02/Chapter 2 Sample.xlsm
11 kB
Snippets/Chapter03/timing test.xlsm
20 kB
Snippets/Chapter04/sheet sorter.xlsm
16 kB
Snippets/Chapter05/array argument.xlsm
13 kB
Snippets/Chapter05/commission functions.xlsm
19 kB
Snippets/Chapter05/draw.xlsm
16 kB
Snippets/Chapter05/extended date functions help.pdf
254 kB
Snippets/Chapter05/extended date functions.xlsm
33 kB
Snippets/Chapter05/key press.xlsm
21 kB
Snippets/Chapter05/month names.xlsm
14 kB
Snippets/Chapter05/mysum function.xlsm
21 kB
Snippets/Chapter05/no argument.xlsm
18 kB
Snippets/Chapter05/remove vowels.xlsm
20 kB
Snippets/Chapter05/upper case.xlsm
398 kB
Snippets/Chapter05/windows directory.xlsm
14 kB
Snippets/Chapter06/ApplicationEventTracker.xlsm
38 kB
Snippets/Chapter06/hide columns before printing.xlsm
17 kB
Snippets/Chapter06/log workbook open.xlsm
18 kB
Snippets/Chapter06/make formulas bold.xlsm
15 kB
Snippets/Chapter06/no shortcut menus.xlsm
14 kB
Snippets/Chapter06/onkey event demo.xlsm
16 kB
Snippets/Chapter06/ontime event demo.xlsm
17 kB
Snippets/Chapter06/shade active row and column.xlsm
18 kB
Snippets/Chapter06/validate entry1.xlsm
16 kB
Snippets/Chapter06/validate entry2.xlsm
18 kB
Snippets/Chapter06/validate entry3.xlsm
15 kB
Snippets/Chapter06/workbook_beforeclose workaround.xlsm
16 kB
Snippets/Chapter07/about range selection.xlsm
19 kB
Snippets/Chapter07/batch processing/batch processing.xlsm
18 kB
Snippets/Chapter07/batch processing/text01.txt
674 B
Snippets/Chapter07/batch processing/text02.txt
934 B
Snippets/Chapter07/batch processing/text03.txt
1.2 kB
Snippets/Chapter07/celltype function.xlsm
18 kB
Snippets/Chapter07/copy multiple selection.xlsm
22 kB
Snippets/Chapter07/create hyperlinks.xlsm
26 kB
Snippets/Chapter07/date and time.xlsm
16 kB
Snippets/Chapter07/delete empty rows.xlsm
85 kB
Snippets/Chapter07/drive information.xlsm
24 kB
Snippets/Chapter07/duplicate rows.xlsm
17 kB
Snippets/Chapter07/efficient looping.xlsm
20 kB
Snippets/Chapter07/file association.xlsm
17 kB
Snippets/Chapter07/friendly time.xlsm
22 kB
Snippets/Chapter07/hide rows and columns.xlsm
16 kB
Snippets/Chapter07/inputbox demo.xlsm
18 kB
Snippets/Chapter07/inrange function.xlsm
16 kB
Snippets/Chapter07/list fonts.xlsm
16 kB
Snippets/Chapter07/loop vs array fill range.xlsm
20 kB
Snippets/Chapter07/next empty cell.xlsm
17 kB
Snippets/Chapter07/printer info.xlsm
17 kB
Snippets/Chapter07/prompt for a range.xlsm
16 kB
Snippets/Chapter07/range selections.xlsm
25 kB
Snippets/Chapter07/select by value.xlsm
28 kB
Snippets/Chapter07/sorting demo.xlsm
30 kB
Snippets/Chapter07/spelldollars function.xlsm
19 kB
Snippets/Chapter07/synchronize sheets.xlsm
18 kB
Snippets/Chapter07/value from closed workbook/myworkbook.xlsx
10 kB
Snippets/Chapter07/value from closed workbook/value from a closed workbook.xlsm
17 kB
Snippets/Chapter07/variant transfer.xlsm
92 kB
Snippets/Chapter07/vba utility functions.xlsm
14 kB
Snippets/Chapter07/video mode.xlsm
18 kB
Snippets/Chapter07/windows registry.xlsm
21 kB
Snippets/Chapter07/worksheet functions.xlsm
43 kB
Snippets/Chapter08/budget pivot table.xlsm
631 kB
Snippets/Chapter08/normalized data.xlsx
18 kB
Snippets/Chapter08/reverse pivot table.xlsm
31 kB
Snippets/Chapter08/simple pivot table.xlsm
21 kB
Snippets/Chapter08/survey data pivot tables.xlsm
39 kB
Snippets/Chapter09/chart active cell.xlsm
52 kB
Snippets/Chapter09/chart image map.xlsm
41 kB
Snippets/Chapter09/chart in userform.xlsm
28 kB
Snippets/Chapter09/data labels.xlsm
23 kB
Snippets/Chapter09/events - chart sheet.xlsm
24 kB
Snippets/Chapter09/events - embedded chart.xlsm
25 kB
Snippets/Chapter09/export all graphics.xlsm
14 kB
Snippets/Chapter09/format all charts.xlsm
36 kB
Snippets/Chapter09/get series ranges.xlsm
32 kB
Snippets/Chapter09/mouseover event - chart sheet.xlsm
23 kB
Snippets/Chapter09/mouseover event - embedded.xlsm
27 kB
Snippets/Chapter09/scrolling chart.xlsm
179 kB
Snippets/Chapter09/size and align charts.xlsm
46 kB
Snippets/Chapter09/sparkline report.xlsm
22 kB
Snippets/Chapter09/unlinked chart.xlsm
40 kB
Snippets/Chapter10/control panel dialogs.xlsm
21 kB
Snippets/Chapter10/Convert a Workbook into a PowerPoint Presentation.xlsm
42 kB
Snippets/Chapter10/Mailing a Single Sheet as an Attachment.xlsm
21 kB
Snippets/Chapter10/Mailing a Specific Range as Attachment.xlsm
18 kB
Snippets/Chapter10/Mailing All Email Addresses in Your Contact List.xlsm
20 kB
Snippets/Chapter10/Mailing the Active Workbook as Attachment.xlsm
16 kB
Snippets/Chapter10/MailMerge.docx
15 kB
Snippets/Chapter10/make memos.xlsm
25 kB
Snippets/Chapter10/PasteTable.docx
18 kB
Snippets/Chapter10/Running an Access Macro from Excel.xlsm
15 kB
Snippets/Chapter10/Running an Access Query from Excel.xlsm
14 kB
Snippets/Chapter10/Sending All Excel Charts to a PowerPoint Presentation.xlsm
30 kB
Snippets/Chapter10/Sending Excel Data to a PowerPoint Presentation.xlsm
30 kB
Snippets/Chapter10/Sending Excel Data to a Word Document.xlsm
20 kB
Snippets/Chapter10/shellexecute/clawhammeruke.mp3
729 kB
Snippets/Chapter10/shellexecute/flower.jpg
55 kB
Snippets/Chapter10/shellexecute/shellexecute examples.xlsm
22 kB
Snippets/Chapter10/shellexecute/textfile.txt
47 B
Snippets/Chapter10/Simulating Mail Merge with a Word Document.xlsm
23 kB
Snippets/Chapter10/start calculator.xlsm
20 kB
Snippets/Chapter11/create file list.xlsm
22 kB
Snippets/Chapter11/DynamicDataConnection.xlsm
264 kB
Snippets/Chapter11/excel usage log.xlsm
15 kB
Snippets/Chapter11/export and import csv.xlsm
25 kB
Snippets/Chapter11/Facility Services.accdb
13 MB
Snippets/Chapter11/file functions.xlsm
14 kB
Snippets/Chapter11/filter text file/filter text file.xlsm
21 kB
Snippets/Chapter11/filter text file/infile.txt
7.0 kB
Snippets/Chapter11/QueryDataFromExcel.xlsm
730 kB
Snippets/Chapter11/recursive file list.xlsm
20 kB
Snippets/Chapter11/show drive info.xlsm
18 kB
Snippets/Chapter11/unzip a file.xlsm
18 kB
Snippets/Chapter11/zip files.xlsm
20 kB
Snippets/Chapter12/data form example.xlsm
49 kB
Snippets/Chapter12/inputbox method.xlsm
23 kB
Snippets/Chapter12/message box examples.xlsm
22 kB
Snippets/Chapter12/prompt for file.xlsm
21 kB
Snippets/Chapter12/VBA inputbox.xlsm
26 kB
Snippets/Chapter13/activex worksheet controls.xlsx
68 kB
Snippets/Chapter13/all userform controls.xlsm
95 kB
Snippets/Chapter13/get name and sex.xlsm
25 kB
Snippets/Chapter13/newcontrols.pag
18 kB
Snippets/Chapter13/spinbutton and textbox.xlsm
18 kB
Snippets/Chapter13/spinbutton events.xlsm
28 kB
Snippets/Chapter13/userform events.xlsm
22 kB
Snippets/Chapter14/change userform size.xlsm
32 kB
Snippets/Chapter14/listbox activate sheet.xlsm
42 kB
Snippets/Chapter14/listbox fill.xlsm
21 kB
Snippets/Chapter14/listbox filter.xlsm
53 kB
Snippets/Chapter14/listbox item transfer.xlsm
23 kB
Snippets/Chapter14/listbox move items.xlsm
24 kB
Snippets/Chapter14/listbox multicolumn1.xlsm
24 kB
Snippets/Chapter14/listbox multicolumn2.xlsm
21 kB
Snippets/Chapter14/listbox multiple lists.xlsm
20 kB
Snippets/Chapter14/listbox select rows.xlsm
35 kB
Snippets/Chapter14/listbox selected items.xlsm
22 kB
Snippets/Chapter14/listbox unique items1.xlsm
32 kB
Snippets/Chapter14/listbox unique items2.xlsm
23 kB
Snippets/Chapter14/mediaplayer/applause.mp3
354 kB
Snippets/Chapter14/mediaplayer/beeping.mp3
90 kB
Snippets/Chapter14/mediaplayer/carstart.mp3
120 kB
Snippets/Chapter14/mediaplayer/dialup.mp3
617 kB
Snippets/Chapter14/mediaplayer/dry and dusty.mp3
1.9 MB
Snippets/Chapter14/mediaplayer/gong.mp3
2.0 MB
Snippets/Chapter14/mediaplayer/horses.mp3
326 kB
Snippets/Chapter14/mediaplayer/mediaplayer.xlsm
22 kB
Snippets/Chapter14/mediaplayer/pump.mp3
498 kB
Snippets/Chapter14/mediaplayer/rain.mp3
89 kB
Snippets/Chapter14/mediaplayer/shoes and stockings.mp3
4.2 MB
Snippets/Chapter14/mediaplayer/siren.mp3
460 kB
Snippets/Chapter14/mediaplayer/thunder.mp3
48 kB
Snippets/Chapter14/mediaplayer/toilet.mp3
186 kB
Snippets/Chapter14/multipage control demo.xlsm
23 kB
Snippets/Chapter14/queryclose demo.xlsm
19 kB
Snippets/Chapter14/random number generator.xlsm
23 kB
Snippets/Chapter14/range selection demo.xlsm
25 kB
Snippets/Chapter14/splash screen.xlsm
55 kB
Snippets/Chapter14/userform menus.xlsm
24 kB
Snippets/Chapter14/zoom and scroll sheet.xlsm
291 kB
Snippets/Chapter15/chart in userform.xlsm
44 kB
Snippets/Chapter15/emulate task pane.xlsm
88 kB
Snippets/Chapter15/excel light-box.xlsm
79 kB
Snippets/Chapter15/getacolor function.xlsm
28 kB
Snippets/Chapter15/modeless SDI.xlsm
23 kB
Snippets/Chapter15/modeless userform1.xlsm
30 kB
Snippets/Chapter15/modeless userform2.xlsm
47 kB
Snippets/Chapter15/move controls.xlsm
281 kB
Snippets/Chapter15/msgbox emulation.xlsm
51 kB
Snippets/Chapter15/multiple buttons.xlsm
22 kB
Snippets/Chapter15/no title bar.xlsm
360 kB
Snippets/Chapter15/progress indicator1.xlsm
24 kB
Snippets/Chapter15/progress indicator2.xlsm
60 kB
Snippets/Chapter15/progress indicator3.xlsm
21 kB
Snippets/Chapter15/resizable userform.xlsm
24 kB
Snippets/Chapter15/semitransparent userform.xlsm
26 kB
Snippets/Chapter15/simulated toolbar.xlsm
36 kB
Snippets/Chapter15/sliding tile puzzle.xlsm
26 kB
Snippets/Chapter15/splash screen2.xlsm
55 kB
Snippets/Chapter15/video poker.xlsm
116 kB
Snippets/Chapter15/wizard demo.xlsm
66 kB
Snippets/Chapter16/Book6.xlsx
33 kB
Snippets/Chapter16/check addin.xlam
16 kB
Snippets/Chapter16/export charts helpsource/export charts.hhp
416 B
Snippets/Chapter16/export charts helpsource/exportcharts1.htm
1.7 kB
Snippets/Chapter16/export charts helpsource/exportcharts2.htm
2.1 kB
Snippets/Chapter16/export charts helpsource/exportcharts3.htm
2.0 kB
Snippets/Chapter16/export charts helpsource/readme.txt
84 B
Snippets/Chapter16/export charts helpsource/styles.css
5.8 kB
Snippets/Chapter16/export charts.chm
14 kB
Snippets/Chapter16/export charts.xlsm
51 kB
Snippets/Chapter16/list add-in information.xlsm
17 kB
Snippets/Chapter17/Custom Ribbon And QAT.xlsm
13 kB
Snippets/Chapter17/demopics/Chrysanthemum.jpg
859 kB
Snippets/Chapter17/demopics/Desert.jpg
826 kB
Snippets/Chapter17/demopics/Hydrangeas.jpg
581 kB
Snippets/Chapter17/demopics/Jellyfish.jpg
758 kB
Snippets/Chapter17/demopics/Koala.jpg
762 kB
Snippets/Chapter17/demopics/Lighthouse.jpg
548 kB
Snippets/Chapter17/demopics/Penguins.jpg
760 kB
Snippets/Chapter17/demopics/Tulips.jpg
606 kB
Snippets/Chapter17/dynamicmenu.xlsm
28 kB
Snippets/Chapter17/ExcelControls.txt
120 kB
Snippets/Chapter17/mso image browser.xlsm
184 kB
Snippets/Chapter17/old-style toolbar.xlsm
17 kB
Snippets/Chapter17/page break display add-in.xlam
19 kB
Snippets/Chapter17/page break display.xlsm
34 kB
Snippets/Chapter17/ribbon control names.xlsx
274 kB
Snippets/Chapter17/ribbon controls demo.xlsm
23 kB
Snippets/Chapter17/ribbon controls demo.xml
3.7 kB
Snippets/Chapter17/ribbon controls demo_old.xlsm
70 kB
Snippets/Chapter17/ribbon modification.xlsm
13 kB
Snippets/Chapter17/ribbon modification_old.xlsm
13 kB
Snippets/Chapter18/add to cell shortcut.xlsm
21 kB
Snippets/Chapter18/context-sensitive shortcut menu.xlsm
18 kB
Snippets/Chapter18/make xl 2003 menus.xlsm
21 kB
Snippets/Chapter18/reset all shortcut menus.xlsm
16 kB
Snippets/Chapter18/RibbonX.xlsm
13 kB
Snippets/Chapter18/shortcut with submenu.xlsm
21 kB
Snippets/Chapter18/show faceids.xlsm
200 kB
Snippets/Chapter18/show shortcut menu items.xlsm
19 kB
Snippets/Chapter18/show shortcut menu names.xlsm
16 kB
Snippets/Chapter19/cell comments/formletter.xlsm
38 kB
Snippets/Chapter19/function help/help source files/myfuncs.ali
73 B
Snippets/Chapter19/function help/help source files/myfuncs.chm
11 kB
Snippets/Chapter19/function help/help source files/myfuncs.h
63 B
Snippets/Chapter19/function help/help source files/myfuncs.hhp
559 B
Snippets/Chapter19/function help/help source files/Table of Contents.hhc
804 B
Snippets/Chapter19/function help/help source files/topic0.htm
182 B
Snippets/Chapter19/function help/help source files/Topic1.htm
488 B
Snippets/Chapter19/function help/help source files/Topic2.htm
459 B
Snippets/Chapter19/function help/myfuncs.chm
11 kB
Snippets/Chapter19/function help/myfuncs.xlsm
18 kB
Snippets/Chapter19/html help/formletter.chm
11 kB
Snippets/Chapter19/html help/formletter.xlsm
34 kB
Snippets/Chapter19/html help/help source files/formletter.chm
11 kB
Snippets/Chapter19/html help/help source files/formletter.hhp
809 B
Snippets/Chapter19/html help/help source files/Table of Contents.hhc
1.3 kB
Snippets/Chapter19/html help/help source files/Topic1.htm
269 B
Snippets/Chapter19/html help/help source files/Topic2.htm
367 B
Snippets/Chapter19/html help/help source files/Topic3.htm
348 B
Snippets/Chapter19/html help/help source files/Topic4.htm
318 B
Snippets/Chapter19/html help/help source files/Topic5.htm
367 B
Snippets/Chapter19/html help/help source files/topic6.htm
361 B
Snippets/Chapter19/mhtml_file/formletter.xlsm
35 kB
Snippets/Chapter19/mhtml_file/help.mht
64 kB
Snippets/Chapter19/mhtml_file/helpsource.xlsx
19 kB
Snippets/Chapter19/textbox/formletter.xlsm
34 kB
Snippets/Chapter19/userform1/formletter.xlsm
42 kB
Snippets/Chapter19/userform2/formletter.xlsm
40 kB
Snippets/Chapter19/userform3/formletter.xlsm
43 kB
Snippets/Chapter19/web browser/formletter.xlsm
31 kB
Snippets/Chapter19/web browser/styles.css
1.3 kB
Snippets/Chapter19/web browser/topic1.htm
663 B
Snippets/Chapter19/web browser/topic2.htm
466 B
Snippets/Chapter19/web browser/topic3.htm
453 B
Snippets/Chapter19/web browser/topic4.htm
423 B
Snippets/Chapter19/web browser/topic5.htm
472 B
Snippets/Chapter19/web browser/topic6.htm
467 B
Snippets/Chapter19/worksheet/formletter.xlsm
41 kB
Snippets/Chapter20/commission calc.xlsm
28 kB
Snippets/Chapter20/keyboard class.xlsm
23 kB
Snippets/Chapter20/query table events complete.xlsm
19 kB
Snippets/Chapter20/query table events.xlsm
11 kB
Snippets/Chapter21/multilingual wizard.xlsm
73 kB