Blog Archives

Tom’s Tutorials For Excel: Running a PowerPoint Presentation From Excel

Tom’s Tutorials For Excel: Running a PowerPoint Presentation From Excel

Download this Excel workbook that runs a PowerPoint presentation.
Download this accompanying PowerPoint presentation.

Here is how you can run a PowerPoint presentation from Excel, with the below macro named “PowerPointSlideshow”.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut

Tom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut

Here’s a shortcut to manually import an Access database table into your spreadsheet. It’ll come with the alternating shaded rows and field header drop-down arrows, but it’s fast and easy. The first picture shows an access table just for example,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: ,

Tom’s Tutorials For Excel: Inserting a Word Document Onto Your Spreadsheet

Tom’s Tutorials For Excel: Inserting a Word Document Onto Your Spreadsheet

Here are the simple steps for inserting a Word document directly onto your worksheet.

Step 1
From the Ribbon, click the Insert tab and then click the Object icon.

If you are using Excel’s version 2003 or before,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Delete a Table in Access From Excel

Tom’s Tutorials For Excel: Delete a Table in Access From Excel

Sometimes you use Excel to manipulate other Office applications such as Word, PowerPoint, and Access. This macro shows how to connect to an Access database and delete a particular table.

A reference to the Microsoft ActiveX Data Objects 2.8 Library is required for the code to run.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Export Word To Excel

Tom’s Tutorials For Excel: Export Word To Excel

For importing part of a Word document into your Excel workbook, here is a macro that imports the second paragraph from a Word doc.

Sub ExportWordToExcel()
‘Declare object variables.
Dim WdApp As Object, wddoc As Object
‘Open Word
Set WdApp = CreateObject(“Word.Application”)
‘Open the Word document
Set wddoc = WdApp.Documents.Open(Filename:=”C:\Your\File\Path\myWordDoc.docx”)
‘Copy paragraph 2
wddoc.Paragraphs(2).Range.Copy
‘Activate your workbook and go to the paste destination of Sheet1 cell A1.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Attach Workbook in Outlook Email to Multiple Recipients

Tom’s Tutorials for Excel: Attach Workbook in Outlook Email to Multiple Recipients

With a macro from Excel, you can create an email in Outlook that will attach your active workbook and fill in the To field with a list of multiple recipients. Suppose you have a workbook that you email to the same people on a regular basis.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Export Excel Spreadsheet Into Access Database Table

Tom’s Tutorials For Excel: Export Excel Spreadsheet Into Access Database Table

Here’s the latest of the Tom’s Tutorials for Excel series in which Tom Urtis walks you through a solution step-by-step. If you have any questions please ask them here in comments. Tom takes the time to be sure readers of every level of expertise feel confident using Excel.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Print a Word document from Excel

Tom’s Tips for Excel: Print a Word document from Excel

Here is the Tuesday blog length post from Tom Urtis. This one is so handy!

Sub PrintWordDoc()
‘Declare object variables.
Dim WdApp As Object, wddoc As Object
‘Open Word
Set WdApp = CreateObject(“Word.Application”)
‘Open the Word document to be printed.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,