Excelguru Help Site - Publisher

Knowledge Base Articles By Category

Access - ADO (4)

Access - SQL (4)

Access - VBA Programming (10)

Downloads - Games (1)

Downloads - Learning Aids (11)

Downloads - Utilities (9)

Excel - ADO (4)

Excel - Charts and Data Visualization (1)

Excel - Formulas (8)

Excel - General Tips (36)

Excel - Interactive Pages (9)

Excel - PivotTables (12)

Excel - Power Query (3)

Excel - PowerPivot (7)

Excel - SQL (4)

Excel - UDF (7)

Excel - User Interface Customization (2)

Excel - VBA Programming (49)

Excel - WebApp (4)

Internet Explorer - VBA Programming (1)

Novell Groupwise - VBA Programming (2)

Other - General (1)

Outlook - General Tips (5)

Outlook - VBA Programming (7)

PDF Creator - VBA Programming (11)

Power BI (3)

PowerPoint - VBA Programming (7)

Publisher - VBA Programming (7)

Syndicated Articles (7)

Training Products (10)

Word - VBA Programming (8)

Publisher - VBA Programming
Easy Outlook Email Integration

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2012-01-22 04:52 AM Number of Views: 36420

Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I ended up heading off to a site to copy an example (usually from my colleague Ron de Bruin's excellent site), then customizing to make it work.

The goal of this article is to provide an even easier way to add email functionality to your Excel (or any other Office) project... something easy enough for beginner coders to use as effectively as master coders. I wanted a re-usuable chunk that I could just drop into my project with ease, and I believe I've accomplished that here.
...

Read More 3 Comments
Security In Microsoft Office

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2011-05-05 05:13 AM Number of Views: 31935

Please Note: This text is the complete reproduction of Chapter 17 - Security if Microsoft Office from my book RibbonX: Customizing the Office 2007 Ribbon, and is reproduced with permission of Wiley Publishing who retains the copyright of this work.

This chapter was obviously written for Excel 2007, and still holds true for Office 2010.

In addition, this chapter also discusses macro security applicable to Office 97 through Office 2003. Key portions to read for these versions are Security Prior to Office 2007 and Digital Certificates. While some of the screens may look a little different, they should be close enough to help you understand how to set up a SelfCert digital certificate and add it to your projects. These steps will allow you to avoid macro warnings in your programming environment, without having to sacrifice security by setting your security levels to low. ...

Read More
Controlling When Application Properties Are Toggled and Controlling Events

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-08-26 06:24 AM Number of Views: 19626

This article actually covers two topics. The first is on controlling when application properties are toggled, and the second shows how to adapt that methodology into a superior method to manage events and prevent recursive calls. The first example set is purely based on Excel, but the methodology can be easily adpated to other applications. The second example is based on an userform and is not application specific.
...

Read More
A Discussion On Early vs Late Binding

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-04-11 06:10 AM Number of Views: 33588

What is "Binding"?
"Binding" is essentially the process of connecting to the object model of an application to make use of its objects, properties and methods. There are two methods to accomplish this: Early Binding and Late Binding. ...

Read More
Examples Of Using Late Binding To Connect To Other Applications

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-01-20 06:45 AM Number of Views: 30205

Introduction:
This article contains examples of using late binding to attach to the current instance or create a new ...

Read More
Connecting To/Creating A New Application Instance Via Late Binding

by
Ken Puls

View Profile

View Forum Posts

View Blog Entries

Visit Homepage

View Articles

Published on 2006-01-16 06:36 AM Number of Views: 21194

Introduction:
There are actually two different ways to accomplish this task, depending on exactly what you want to do. You can:

Connect to an existing application (uses the GetObject method)
Create a new application with no document loaded (uses the CreateObject method)

Please note that while all of this code was written to control Microsoft Word from Excel, you can use it in any other VBA enabled application, and you can also use it to control any other VBA enabled application, simply by changing "Word" to Excel, Powerpoint, Access, etc... in the examples below.
...

Read More

Recent Forum Posts
can a pivot table show my data in the way i need it?

Welcome to the Pandora's Box that is PowerQuery!...
AliGW Today, 03:23 PM

can a pivot table show my data in the way i need it?

Thank you so much, figured out how to load into editor and added extra columns to calculate consumption and am now creating a dashboard with slicers....
rantanwang Today, 02:42 PM

can a pivot table show my data in the way i need it?

Well, of course it depends, but as your master workbook must contain TBLREADINGS, it should be as easy as creating a blank query and copying in my code....
AliGW Today, 01:38 PM

can a pivot table show my data in the way i need it?

Just on my way out, but will respond to all three questions when I get back later this afternoon. ...
AliGW Today, 11:50 AM
can a pivot table show my data in the way i need it?

AliGW thats fantastic!!

i have a couple of questions

how do i add the code to the master spreadsheet
easiest way to have blank
...
rantanwang Today, 10:27 AM

Knowledge Base Articles By Category

Publisher - VBA Programming

Recent Forum Posts