Alexander Excel 2016 Power Programming with VBA 2016 | 648F8311224BBCA1C1D688444AA8B8022D3A50B3

Alexander Excel 2016 Power Programming with VBA 2016

Name	M.Alexander - Excel 2016 Power Programming with VBA - 2016	DOWNLOAD Copy Link
Total Size	65.7 MB
Total Files	268
Hash	648F8311224BBCA1C1D688444AA8B8022D3A50B3

/
M.Alexander - Excel 2016 Power Programming with VBA - 2016.pdf	24.8 MB
/Snippets/Chapter01/
worksheet controls.xlsx	70.2 KB
/Snippets/Chapter02/
Chapter 2 Sample.xlsm	10.9 KB
/Snippets/Chapter03/
timing test.xlsm	20.8 KB
/Snippets/Chapter04/
sheet sorter.xlsm	16.8 KB
/Snippets/Chapter05/
array argument.xlsm	13.6 KB
commission functions.xlsm	19.6 KB
draw.xlsm	15.9 KB
extended date functions help.pdf	260.0 KB
extended date functions.xlsm	34.2 KB
key press.xlsm	21.6 KB
month names.xlsm	14.8 KB
mysum function.xlsm	21.1 KB
no argument.xlsm	18.8 KB
remove vowels.xlsm	20.5 KB
upper case.xlsm	407.6 KB
windows directory.xlsm	14.1 KB
/Snippets/Chapter06/
ApplicationEventTracker.xlsm	38.6 KB
hide columns before printing.xlsm	17.1 KB
log workbook open.xlsm	18.9 KB
make formulas bold.xlsm	15.1 KB
no shortcut menus.xlsm	14.7 KB
onkey event demo.xlsm	16.6 KB
ontime event demo.xlsm	17.3 KB
shade active row and column.xlsm	18.8 KB
validate entry1.xlsm	16.7 KB
validate entry2.xlsm	18.5 KB
validate entry3.xlsm	15.3 KB
workbook_beforeclose workaround.xlsm	16.6 KB
/Snippets/Chapter07/
about range selection.xlsm	19.2 KB
celltype function.xlsm	18.1 KB
copy multiple selection.xlsm	22.2 KB
create hyperlinks.xlsm	26.3 KB
date and time.xlsm	16.5 KB
delete empty rows.xlsm	87.3 KB
drive information.xlsm	24.5 KB
duplicate rows.xlsm	17.6 KB
efficient looping.xlsm	20.1 KB
file association.xlsm	17.7 KB
friendly time.xlsm	22.1 KB
hide rows and columns.xlsm	15.9 KB
inputbox demo.xlsm	17.9 KB
inrange function.xlsm	16.0 KB
list fonts.xlsm	16.4 KB
loop vs array fill range.xlsm	20.2 KB
next empty cell.xlsm	17.0 KB
printer info.xlsm	17.6 KB
prompt for a range.xlsm	15.9 KB
range selections.xlsm	25.6 KB
select by value.xlsm	28.4 KB
sorting demo.xlsm	31.2 KB
spelldollars function.xlsm	19.3 KB
synchronize sheets.xlsm	18.6 KB
variant transfer.xlsm	94.7 KB
vba utility functions.xlsm	14.5 KB
video mode.xlsm	18.3 KB
windows registry.xlsm	21.9 KB
worksheet functions.xlsm	43.6 KB
/Snippets/Chapter07/batch processing/
batch processing.xlsm	18.9 KB
text01.txt	0.7 KB
text02.txt	0.9 KB
text03.txt	1.2 KB
/.../value from closed workbook/
myworkbook.xlsx	10.7 KB
value from a closed workbook.xlsm	17.6 KB
/Snippets/Chapter08/
budget pivot table.xlsm	645.7 KB
normalized data.xlsx	18.5 KB
reverse pivot table.xlsm	32.2 KB
simple pivot table.xlsm	21.5 KB
survey data pivot tables.xlsm	39.5 KB
/Snippets/Chapter09/
chart active cell.xlsm	53.8 KB
chart image map.xlsm	42.0 KB
chart in userform.xlsm	28.6 KB
data labels.xlsm	23.4 KB
events - chart sheet.xlsm	24.0 KB
events - embedded chart.xlsm	25.6 KB
export all graphics.xlsm	14.2 KB
format all charts.xlsm	36.5 KB
get series ranges.xlsm	32.7 KB
mouseover event - chart sheet.xlsm	23.4 KB
mouseover event - embedded.xlsm	27.4 KB
scrolling chart.xlsm	183.4 KB
size and align charts.xlsm	46.8 KB
sparkline report.xlsm	23.0 KB
unlinked chart.xlsm	40.9 KB
/Snippets/Chapter10/
control panel dialogs.xlsm	21.3 KB
Convert a Workbook into a PowerPoint Presentation.xlsm	43.3 KB
Mailing a Single Sheet as an Attachment.xlsm	21.2 KB
Mailing a Specific Range as Attachment.xlsm	18.3 KB
Mailing All Email Addresses in Your Contact List.xlsm	20.0 KB
Mailing the Active Workbook as Attachment.xlsm	15.9 KB
MailMerge.docx	15.0 KB
make memos.xlsm	25.5 KB
PasteTable.docx	17.9 KB
Running an Access Macro from Excel.xlsm	15.5 KB
Running an Access Query from Excel.xlsm	13.9 KB
Sending All Excel Charts to a PowerPoint Presentation.xlsm	31.2 KB
Sending Excel Data to a PowerPoint Presentation.xlsm	30.3 KB
Sending Excel Data to a Word Document.xlsm	20.7 KB
Simulating Mail Merge with a Word Document.xlsm	23.9 KB
start calculator.xlsm	20.7 KB
/Snippets/Chapter10/shellexecute/
clawhammeruke.mp3	746.1 KB
flower.jpg	56.6 KB
shellexecute examples.xlsm	22.7 KB
textfile.txt	0.0 KB
/Snippets/Chapter11/
create file list.xlsm	22.7 KB
DynamicDataConnection.xlsm	270.7 KB
excel usage log.xlsm	15.2 KB
export and import csv.xlsm	25.4 KB
Facility Services.accdb	13.2 MB
file functions.xlsm	14.8 KB
QueryDataFromExcel.xlsm	748.0 KB
recursive file list.xlsm	20.9 KB
show drive info.xlsm	18.9 KB
unzip a file.xlsm	18.7 KB
zip files.xlsm	20.0 KB
/.../filter text file/
filter text file.xlsm	21.1 KB
infile.txt	7.1 KB
/Snippets/Chapter12/
data form example.xlsm	50.1 KB
inputbox method.xlsm	23.3 KB
message box examples.xlsm	22.8 KB
prompt for file.xlsm	21.8 KB
VBA inputbox.xlsm	27.2 KB
/Snippets/Chapter13/
activex worksheet controls.xlsx	69.9 KB
all userform controls.xlsm	97.3 KB
get name and sex.xlsm	25.7 KB
newcontrols.pag	18.9 KB
spinbutton and textbox.xlsm	18.8 KB
spinbutton events.xlsm	29.2 KB
userform events.xlsm	22.8 KB
/Snippets/Chapter14/
change userform size.xlsm	32.6 KB
listbox activate sheet.xlsm	43.0 KB
listbox fill.xlsm	21.1 KB
listbox filter.xlsm	54.3 KB
listbox item transfer.xlsm	23.5 KB
listbox move items.xlsm	24.8 KB
listbox multicolumn1.xlsm	24.1 KB
listbox multicolumn2.xlsm	21.1 KB
listbox multiple lists.xlsm	20.4 KB
listbox select rows.xlsm	36.0 KB
listbox selected items.xlsm	22.7 KB
listbox unique items1.xlsm	32.9 KB
listbox unique items2.xlsm	23.1 KB
multipage control demo.xlsm	24.0 KB
queryclose demo.xlsm	19.3 KB
random number generator.xlsm	23.3 KB
range selection demo.xlsm	25.2 KB
splash screen.xlsm	56.7 KB
userform menus.xlsm	24.8 KB
zoom and scroll sheet.xlsm	297.7 KB
/Snippets/Chapter14/mediaplayer/
applause.mp3	362.5 KB
beeping.mp3	92.0 KB
carstart.mp3	122.5 KB
dialup.mp3	632.0 KB
dry and dusty.mp3	2.0 MB
gong.mp3	2.1 MB
horses.mp3	334.0 KB
mediaplayer.xlsm	23.0 KB
pump.mp3	510.0 KB
rain.mp3	91.4 KB
shoes and stockings.mp3	4.5 MB
siren.mp3	471.5 KB
thunder.mp3	48.7 KB
toilet.mp3	190.2 KB
/Snippets/Chapter15/
chart in userform.xlsm	45.1 KB
emulate task pane.xlsm	89.7 KB
excel light-box.xlsm	81.2 KB
getacolor function.xlsm	29.1 KB
modeless SDI.xlsm	23.8 KB
modeless userform1.xlsm	30.8 KB
modeless userform2.xlsm	48.2 KB
move controls.xlsm	287.6 KB
msgbox emulation.xlsm	51.9 KB
multiple buttons.xlsm	22.0 KB
no title bar.xlsm	368.7 KB
progress indicator1.xlsm	25.0 KB
progress indicator2.xlsm	61.6 KB
progress indicator3.xlsm	21.5 KB
resizable userform.xlsm	24.8 KB
semitransparent userform.xlsm	26.1 KB
simulated toolbar.xlsm	37.2 KB
sliding tile puzzle.xlsm	26.4 KB
splash screen2.xlsm	56.6 KB
video poker.xlsm	118.3 KB
wizard demo.xlsm	67.1 KB
/Snippets/Chapter16/
Book6.xlsx	34.1 KB
check addin.xlam	16.3 KB
export charts.chm	14.2 KB
export charts.xlsm	52.6 KB
list add-in information.xlsm	17.3 KB
/.../export charts helpsource/
export charts.hhp	0.4 KB
exportcharts1.htm	1.8 KB
exportcharts2.htm	2.2 KB
exportcharts3.htm	2.1 KB
readme.txt	0.1 KB
styles.css	6.0 KB
/Snippets/Chapter17/
Custom Ribbon And QAT.xlsm	13.1 KB
dynamicmenu.xlsm	29.0 KB
ExcelControls.txt	122.5 KB
mso image browser.xlsm	187.9 KB
old-style toolbar.xlsm	17.5 KB
page break display add-in.xlam	19.1 KB
page break display.xlsm	34.4 KB
ribbon control names.xlsx	280.8 KB
ribbon controls demo.xlsm	23.3 KB
ribbon controls demo.xml	3.8 KB
ribbon controls demo_old.xlsm	71.2 KB
ribbon modification.xlsm	13.5 KB
ribbon modification_old.xlsm	13.5 KB
/Snippets/Chapter17/demopics/
Chrysanthemum.jpg	879.4 KB
Desert.jpg	845.9 KB
Hydrangeas.jpg	595.3 KB
Jellyfish.jpg	775.7 KB
Koala.jpg	780.8 KB
Lighthouse.jpg	561.3 KB
Penguins.jpg	777.8 KB
Tulips.jpg	620.9 KB
/Snippets/Chapter18/
add to cell shortcut.xlsm	21.8 KB
context-sensitive shortcut menu.xlsm	18.2 KB
make xl 2003 menus.xlsm	21.7 KB
reset all shortcut menus.xlsm	15.8 KB
RibbonX.xlsm	12.9 KB
shortcut with submenu.xlsm	21.6 KB
show faceids.xlsm	205.3 KB
show shortcut menu items.xlsm	19.4 KB
show shortcut menu names.xlsm	16.8 KB
/Snippets/Chapter19/cell comments/
formletter.xlsm	39.0 KB
/.../help source files/
myfuncs.ali	0.1 KB
myfuncs.chm	11.2 KB
myfuncs.h	0.1 KB
myfuncs.hhp	0.6 KB
Table of Contents.hhc	0.8 KB
topic0.htm	0.2 KB
Topic1.htm	0.5 KB
Topic2.htm	0.5 KB
/Snippets/Chapter19/function help/
myfuncs.chm	11.2 KB
myfuncs.xlsm	18.5 KB
/Snippets/Chapter19/html help/
formletter.chm	11.6 KB
formletter.xlsm	35.0 KB
/.../help source files/
formletter.chm	11.6 KB
formletter.hhp	0.8 KB
Table of Contents.hhc	1.4 KB
Topic1.htm	0.3 KB
Topic2.htm	0.4 KB
Topic3.htm	0.3 KB
Topic4.htm	0.3 KB
Topic5.htm	0.4 KB
topic6.htm	0.4 KB
/Snippets/Chapter19/mhtml_file/
formletter.xlsm	36.3 KB
help.mht	65.3 KB
helpsource.xlsx	19.4 KB
/Snippets/Chapter19/textbox/
formletter.xlsm	35.3 KB
/Snippets/Chapter19/userform1/
formletter.xlsm	42.9 KB
/Snippets/Chapter19/userform2/
formletter.xlsm	40.4 KB
/Snippets/Chapter19/userform3/
formletter.xlsm	43.7 KB
/Snippets/Chapter19/web browser/
formletter.xlsm	32.1 KB
styles.css	1.3 KB
topic1.htm	0.7 KB
topic2.htm	0.5 KB
topic3.htm	0.5 KB
topic4.htm	0.4 KB
topic5.htm	0.5 KB
topic6.htm	0.5 KB
/Snippets/Chapter19/worksheet/
formletter.xlsm	42.1 KB
/Snippets/Chapter20/
commission calc.xlsm	28.6 KB
keyboard class.xlsm	23.1 KB
query table events complete.xlsm	19.9 KB
query table events.xlsm	11.2 KB
/Snippets/Chapter21/
multilingual wizard.xlsm	74.8 KB
Total files 268