Nov 8 2016

Do You Want To Be A Microsoft Excel MVP

The 2016 Microsoft MVP Summit

snag_program-0108

 

It is that time of year again when Microsoft Excel MVP’s from around the world travel to Washington to spend a week with other Excel MVP’s and to attend closed door workshops and discussions on various aspects of Microsoft Excel with those from the Microsoft corporation.  It is quite the event, Microsoft throws several dinner parties for the MVP’s and their guests and even provides food, drink and lodging, all free.

To put things into perspective, there are usually around 130 Excel MVP’s in the world.  Jacob, the owner of this site and of Vbaexpress.Com is a Microsoft Excel MVP.

You don’t know what A Microsoft Excel MVP is, then click here.

Please note, the summit is not just for Excel experts but rather for MVP’s in every application Microsoft produces, even for X-Box.

How to become an Excel MVP

Becoming an MVP is not that hard if you are a strong intermediate user of Excel.  You do not need to be an expert in all aspects of the application.  Being an expert in functions and formulas, or vba is enough.

Want to learn more, visit our site or our LinkedIn post.

Oct 31 2016

More Than Just Great Blog Posts, Hire Us

 

If your organization needs help with Microsoft Excel or Access, be it consulting, programming or training, our team of Microsoft Excel and Access experts can help you, today.

hire-our-excel-consultants-blog

Click Here To Contact Us
click-here-to-contact-us

 

 

Oct 30 2016

History of Microsoft Excel

 

microsoft-excel-spreadsheet-history

Recently I was reading what must be my favorite blog on Microsoft Excel, Contextures by Debra Dalgleish and I stumbled on a post she wrote a little over a year ago, covering the 30th anniversary of Microsoft Excel. So this got me thinking, what is the number of people who have worked in Microsoft Excel at the intermediate level or higher and for ten years or less?  Of those, how much of the history of Excel do they know?

I ask this because I am often surprised of just how little they know.  For instance, what year was Excel released and for which operating system.

 

Here are a few of the more important bits of history:

  • Original release date, 1985
  • First edition was for the Apple Macintosh
  • Personally I first used Excel on my Macintosh in my first year of college
  • Excel 2004 for Apple had VBA, 2008 did not, 2011 did, 2016 reduced functionality
  • Microsoft first announced Office 365 in October 2010
  • On July 8, 2013, Microsoft unveiled Power BI
  • Microsoft released two versions of Excel under the name 2016, one for Windows (22 September 2015) and one for Apple (9 July 2015 ).

 

History of the spreadsheet (The Early Years):

    1. 1985 – Excel (Apple Macintosh)
    2. 1987 – Excel 2.0
    3. 1990 – Excel 3.0
    4. 1992 – Excel 4.0
    5. 1993 – Excel w/VBA 5.0
    6. 1995 – Excel 95
    7. 1997 – Excel 97

 

This is just an Excel Hint, Click Here To See The Full Post

 

 

 

ggggg

May 22 2016

v2.0 – Excel Hint, how to use Excel VBA to send a copy of your Microsoft Excel workbook via email – 2nd in the series

Last week we did our first post in a series, on how to send a Microsoft Excel workbook, via Microsoft Outlook email, by clicking a command button in Excel.  This is the second post in the series, taking it up a level.  So if you have not looked at post one, the most basic method, please do so. And look for the third in this series next week.

This post contains the actual code that will work immediately after dropping it into your file, use this link to download the zipped file.

will work as well.  Below are a few print screens, and a short video showing the file in action.

 

If you have not already done so, please take the time to visit our new website, ExcelConsultant.Net which has a great new blog.

 

excelconsultantnet5

 

 

 

Image 1 (Below) - Microsoft Excel file immediately after opening. This file contains the data needed to populate the email when the macro is sent (Name – column A, Email Address – column B). The graphic in column D, that looks like an email, is the button you click to initiate the macro. Finally, you will notice the column C, the SendTime is blank.  When the code runs, it will populate this field.

 

email-code-v2-before-code-1

 

 

 

Image 2 – The green arrow is pointing to the button you need to click to run macro/code/vba. When you click this button, if your workbook is macro enabled, this will run the code to send the emails.

 

email-code-v2-before-code-2

 

 

 

Image 3 – This is what the workbook will look like once the code has finished running you will see that the three cells in column C have been populated with the long date.

 

email-excel-image-2

 

 

Image 4 – This is what you will see in Microsoft Outlook, a new email, the email address, subject and body populated, with the workbook to be sent attached. Our code has this set as ‘Display’, if you wanted the email to send, without your need to click the send/receive button, change the code to “Send”.

 

email-code-v2-email-recepient

 

 

Image 5 – Here is what the code looks like in the VBE. This vba was written by Microsoft Excel MVP, Jacob Hilderbrand, owner of this site and of vbaexpress.com. This code works, Jacob’s comments help you to find the sections of code you may want to expand on or alter.

 

email-code-v2-code-1

 

 

The image below is a split-screen, the left side is Microsoft Excel and the right side is the VBE.  If you watch it closely you will see the macro being stepped through (F8), line by line, the yellow row being the currently active line.  You will then see the workbook on the left being populated as the code moves through each line.

 

code-v2-1-2

 

 

So that is it for now.  Take the code below and drop it into your workbook, or download the file from this site, and run it as is.  Then play with it, change a line of code, one at a time, and see what you can do with it.  We have done the hard part, the easy part is for you to take these lessons we are posting, and take an hour to plat with it.  That is all the time you need.

 

Here is the code, paste this into your Excel workbook:

 

Option Explicit

Sub EmailWorkbook()

Dim i                   As Long
Dim LastRow             As Long
Dim AppOL               As Object
Dim EmailItem           As Object

Const olMailItem    As Long = 0

‘Initialze Objects
Set AppOL = CreateObject(“Outlook.Application”)

‘Save Workbook
ActiveWorkbook.Save

‘Get Last Row
LastRow = Range(“A” & Rows.Count).End(xlUp).Row

‘Process Each Row
For i = 2 To LastRow
‘Create Email
Set EmailItem = AppOL.CreateItem(olMailItem)

‘Format Email
With EmailItem
.Subject = “Insert Subject Here”
.Body = “Dear ” & Range(“A” & i).Value
.to = Range(“B” & i).Value
.Attachments.Add ActiveWorkbook.FullName
.Display
End With
Next i

ExitSub:

‘Release Object Variables
Set EmailItem = Nothing
Set AppOL = Nothing

End Sub

 

If you have questions pertaining to this code, visit our site, VBAExpress.Com Excel forums, go to the forum, if you are not a member please join.  Post your questions and they will be answered but some of the brightest, most passionate Excel experts out there, from Microsoft Excel MVP’s, Microsoft Certified Partners, Microsoft Vendors, Microsoft employees, and die hard in the trenches tried and true mavericks.

If you want to hire a team to assist you, we do that as well.  For more info on the team and what we can do, please visit our main site, ExcelConsultant.Net.  Jacob is the top VBA developer and programmer on the site, you can work with him, just shoot us an email, use the contact form, the chat window, or dial 844-VBA-Help and Jacob and I will help you.

 

Finally, please look for the third in this series of posts in about a week or two, taking it to an ever deeper level.

Thank you, Christopher

 

TAGS:
May 13 2016

v1.0 – Excel Hint, how to use Excel VBA to send a copy of your Microsoft Excel workbook via email

Excel Hint, how to send a copy of your Microsoft Excel workbook to one or more users as an attachment to a Microsoft Outlook email, and how to do so programmatically by adding VBA code to your Excel workbook.

It is actually pretty easy to do, and there are plenty of different ways to do it, some simple, as below, and some more advanced, coming shortly. For over the next several weeks we will post a few of those methods, so check back frequently to see how those would work.

The code below was written by Microsoft Excel MVP,  Jacob Hilderbrand.

 

If you have any questions about the code below, please post your question(s) on our Excel forums at vbaexpress.com.

 

Follow these steps to test the code on your computer (Or download the fully functional workbook at the end of this post)

  1. Create a new Excel workbook.
  2. Create a new procedure and name it ‘EmailWorkbook’.
  3. Create an Active X Command button on the worksheet.
  4. Drop the code below into the ‘EmailWorkbook’ procedure.
  5. Call the ‘EmailWorkbook’ in the command button module.
  6. From the Excel worksheet, click the Command button.
  7. Review the Outlook email that is created.
    1. This will show you just one of the many options available to you, based on the code added to the workbook.

 

Past the code below into your Visual Basic Editor

Option Explicit

Sub EmailWorkbook()

Dim AppOL               As Object

Dim EmailItem           As Object

Const olMailItem    As Long = 0

 

‘Initialze Objects

Set AppOL = CreateObject(“Outlook.Application”)

Set EmailItem = AppOL.CreateItem(olMailItem)

‘Save Workbook

ActiveWorkbook.Save

 

‘Create Email

With EmailItem

.Subject = “Insert Subject Here”

.Body = “Insert message here”

.To = “User@Domain.Com

.Attachments.Add ActiveWorkbook.FullName

.Display

End With

ExitSub:

 

‘Release Object Variables

Set EmailItem = Nothing

Set AppOL = Nothing

End Sub

 

Visit our sister site, VBAExpress.Com, you can reach us live at 1-844-VBA-Help, or you can email info@vbaexpress.com

 

Click Here to Download The Workbook: vba-code-to-send-email-from-excel-version-1-by-jacob-hilderbrand-at-excelandaccessllc

 

 

Page 1 of 23123451020...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives