Top products from r/vba

For Excel, I started with this book (technically, the '97' version but the same author) : http://www.amazon.com/Sams-Teach-Yourself-Excel-Programming/dp/0672315432

I used a similar book to this for Access: http://www.amazon.com/Sams-Teach-Yourself-Microsoft-Access/dp/0672321033/ref=sr_1_2?s=books&ie=UTF8&qid=1342728350&sr=1-2&keywords=access+programming+21+days

Not too long after that I started programming MS Office for a living. 15 years later, I now program .NET, SQL, and WEB for a living, all from starting with Excel VBA.

Best of luck.

I learned using VBA for the absolute beginner. Just doing the examples in the book helps a lot. Also anything by John Walkenbach, is good too. Good luck, have fun.

I think this thread is more of a discussion than a regular question and I'm changing the flair accordingly.

I fully agree with /u/chrispsn_ok's comment both on bytecomb (which is linked to on our resources page) and his advice that the best way to expand your "mastery" is to incorporate knowledge and best practices from other languages.

In a similar vein there is a lot to be gained from researching language agnostic concepts such as knowledge of common paradigms(functional, OO, procedural, etc), data structures, design patterns, etc. Check out Uncle Bob or books like "Code Complete".

edit: as far as VBA specific books go, I only have Excel 2002 VBA: Programmers Reference which is excellent but the latest revision only seems to go up to 2007. It might be worth buying one of the more recent books by John Walkenbach such as the "Power Programming with VBA" series.

I personally used John Walkenbach's books on VBA to learn over 10 years ago. They were tremendously helpful and good for the intermediate to advance VBA programmer so I'd recommend his VBA books (he also writes general books on advanced Excel techniques but for purposes of this discussion, I'd opt for his books that relate to solely VBA).

Knowing SQL also helps when pulling raw data from databases for use in custom reports and models. I used this to help me out with SQL, http://www.amazon.com/Learning-SQL-Alan-Beaulieu/dp/0596520832/ref=sr_1_3?s=books&ie=UTF8&qid=1426696057&sr=1-3&keywords=SQL

Hope this helps.

For your own work, I suggest Code Complete.

As for getting your co-worker to change, don't bother wasting your time, as life is too valuable to deal with stuff like that.

Just do your own work to the best of your abilities and let that speak for you.

If you want tips for style-guides on implementing in excel and some vba best practices, I'd also suggest

https://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793

But that's more for "here is how you make your work look top notch and be easy to maintain for 5+ years".

Honestly this whole process that you're going with is odd, but I like the idea of using HTTP.ResponseText, though admittedly I only use that with JSON requests.

That said .innerHTML is also a String, so I can't imagine dimming obj_tbl as an Object and then setting it would work.

Also not sure about this even working. I use my webscraping classes:

Selenide.open "https://www.amazon.com/gp/offer-listing/B01F2Y0F94/ref=dp_olp_new_mbc?ie=UTF8&condition=new"

Debug.Print By.classCollection("a-row a-spacing-mini olpOffer")(0).innerHTML

And it returns a whole bunch of crap that more than fills the immediate window, with most of it being javascript.

----------------------------------------------------------


this.done = true;
return;
}

var remainMins = Math.floor(remainSeconds / 60);
var mins = remainMins % 60;
var hours = Math.floor(remainMins / 60);

var countdownText = getPrimeCountdownText( hours, mins );

for ( var i = 0; i < this.counterIDs.length; i++ ) {
var counterNode = document.getElementById(this.counterIDs[i]);
if (counterNode) {
counterNode.innerHTML = countdownText;
}
}
}

function attachSuppressedDeliveryMessages() {
var suppressedImages = document.getElementsByName('suppressedIndividualDeliveryOption');
for ( var i = 0; i < suppressedImages.length; i++ ) {
attachSuppressedDeliveryMsgTrigger(suppressedImages[i].id);
}
}

function attachSuppressedDeliveryMsgTrigger(button) {
var imgId = "#" + button;
P.when('A', 'a-popover', 'ready').execute(function(A, popover) {
var $ = A.$;
popover.create($(imgId), {
'activate': 'onmouseover',
'closeButton': false,
'name': imgId + 'Msg'
});
});
}

function getPrimeCountdownText( hours, minutes ) {
var spaces = document.getElementsByName('prime_stripe_countdown_space');
var hours_strings = document.getElementsByName('prime_stripe_countdown_hours');
var minutes_strings = document.getElementsByName('prime_stripe_countdown_minutes');

if( spaces.length == 0 || hours_strings.length == 0 || minutes_strings.length == 0 ) {
stopTimer();
return;
}

var space = spaces[0].value;
var hours_string = hours_strings[0].value;
var minutes_string = minutes_strings[0].value;

var countdownText = hours + space + hours_string + ' ' + minutes + space + minutes_string;
return countdownText;
}
-->
</script>







<input name="prime_stripe_countdown_space" type="hidden" value=""><input name="prime_stripe_countdown_hours" type="hidden" value="hr"><input name="prime_stripe_countdown_minutes" type="hidden" value="min"><input name="prime_stripe_seconds_left" type="hidden" value="169122"><input name="prime_stripe_messageID" type="hidden" value="primeFRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag3D3DsecondDeliveryOptionSpan,primeFRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag3D3DsecondCountdownMessage0,primeFRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag3D3DsecondCountdownMessage0,primeFRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag3D3DsecondCountdownMessage0"><div id="prime_stripe_countdown_action_1" style="display: none;">Free Two-day S
hipping,clear[promiseBullets],show[promiseReloadMessage],please click refresh for updated delivery options</div><input name="prime_stripe_counterID" type="hidden" value="primeFRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag3D3DsecondCountdownCounter0">

<script language="Javascript1.2" type="text/javascript">
<!--
P.when('jQuery', 'ready').execute(function($) {
updateCountdownMessage( 0 );
});
-->
</script>
.</span>
</li>


</ul>
</div>

</form>

<div id="promiseReloadMessage" style="display: none;">

<br>
</div>




<li><span class="a-list-item">
<a href="/gp/aag/details/ref=olp_merch_ship_1/151-2159443-6821549?ie=UTF8&asin=B01F2Y0F94&seller=ATVPDKIKX0DER&sshmPath=shipping-rates#aag_shipping">Shipping rates</a>
and <a href="/gp/aag/details/ref=olp_merch_return_1/151-2159443-6821549?ie=UTF8&asin=B01F2Y0F94&seller=ATVPDKIKX0DER&sshmPath=returns#aag_returns">return policy</a>.
</span></li>
</ul>




<p></p>








</div>
<div class="a-column a-span2 olpSellerColumn" role="gridcell">
















<h3 class="a-spacing-none olpSellerName">
<img width="90" height="17" alt="Amazon.com" src="https://images-na.ssl-images-amazon.com/images/I/01dXM-J1oeL.gif">


</h3>
















</div>
<div class="a-column a-span2 olpBuyColumn a-span-last" role="gridcell">















<div class="a-button-stack">

<form class="a-spacing-none" action="/gp/item-dispatch/ref=olp_atc_new_1/151-2159443-6821549" method="post">
<input name="session-id" type="hidden" value="151-2159443-6821549">
<input name="qid" type="hidden">
<input name="sr" type="hidden">
<input name="signInToHUC" id="signInToHUC" type="hidden" value="0">
<input name="metric-asin.B01F2Y0F94" type="hidden" value="1">
<input name="registryItemID.1" type="hidden">
<input name="registryID.1" type="hidden">
<input name="itemCount" type="hidden" value="1">
<input name="offeringID.1" type="hidden" value="FRZ8BOzUT62qoOyQHsHfxJgGjmZVtj6BzCkRKex3CkTfGzqD1vkTulT8m9lMEcQOCyKd9d63ycTEn53bPkkmb5gNqRg7mJ9Tt032Smp8aQfLfE6HTvA5ag%3D%3D">
<input name="isAddon" type="hidden" value="0">

<span class="a-declarative" data-action="olp-click-log" data-olp-click-log='{"subtype":"main","type":"addToCart"}'>
<span class="a-button a-button-normal a-spacing-micro a-button-primary a-button-icon" id="a-autoid-0"><span class="a-button-inner"><i class="a-icon a-icon-cart"></i><input name="submit.addToCart" class="a-button-input" aria-labelledby="a-autoid-0-announce" type="submit" value="Add to cart"><span class="a-button-text" id="a-autoid-0-announce" aria-hidden="true">
Add to cart
</span></span></span>
</span>
</form>


<div class="a-section a-spacing-micro a-text-center">
or
</div>
<p class="a-spacing-none a-text-center olpSignIn">

<a href="/gp/product/utility/edit-one-click-pref.html/ref=olpofferlisting/151-2159443-6821549?ie=UTF8&returnPath=%2Fgp%2Foffer-listing%2FB01F2Y0F94">Turn on 1-Click</a> to use your Amazon Prime benefits.
</p>
</div>

</div>

Do you have any basic programming background? If not, then you might really want to start off with Excel first. I'm a big fan of Bill Jelen, and you should definately start with this book

https://www.amazon.com/dp/1119514924/ref=cm_sw_r_cp_awdb_t1_TUriDb8ZQMH18

I just bought this book for the same reason, and I have found it tremendously helpful. I am reading it cover to cover. It’s like 750 pages.

Professional Excel Development really showed me the limits of what can be done with Office.

https://www.amazon.com/Professional-Excel-Development-Definitive-Applications/dp/0321508793

Excel specific: https://www.amazon.co.uk/Excel-Programming-Dummies-John-Walkenbach/dp/1119077397/ref=asap_bc?ie=UTF8

As others have said, if you have 2013 it is not worth buying 2016.

However the book: Excel 2016 VBA and Macros has some very useful material and is quite different than the dummy books.

If we're going with Amazon, might as well add this to the mix: VBA for Dummies

I would recommend this book. Pick it up used under $10. http://www.amazon.com/gp/product/1555583466

The two I keep on my desk:

Excel 2013 Power Programming with VBA by John Walkenbach

Professional Excel Development by Rob Bovey

The second one is more advanced, but indispensable if you want professional quality applications in VBA.

Link to Amazon.co.uk. I cannot remember the edition I have (it's in the garage somewhere) but that seems to be the most recent.

Start right here:

http://www.cpearson.com/excel/topic.aspx

And buy this book:

https://www.amazon.com/Excel-Power-Programming-Spreadsheets-Bookshelf/dp/1119067723