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”.
…
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,
…
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,
…
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.
…
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.
…
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.
…
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.
…
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.…
San Francisco, California
1-925-310-4170
tom@atlaspm.com
