• ## Ken Puls

### Connecting To/Creating A New Application Instance Via Late Binding

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

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.
...

### User Defined Function To Show Formulas In A Cell

by Published on 2006-01-11 09:28 AM     Number of Views: 17613

Macro Purpose:
• Function to show the formula in another cell as text.
...

### User Defined Function To Sum And Round To Two Decimal Places

by Published on 2006-01-10 09:20 AM     Number of Views: 33689

Macro Purpose:
• To round a Sum formula to two decimal places
...

### Five Very Useful Functions For Working With Text

by Published on 2006-01-10 08:08 AM     Number of Views: 38930

This page is dedicated to explaining how to use what I believe are the five most valuable formulas for working with text in Excel. They are useful on their own many times, but can become immensely powerful when nested (combined) with other formulas later as well. Mastering these five formulas will open up the door to many things that you may have never thought possible. All of these formulas can be used by putting actual text in the "text" area, but their true power is unlocked when using them on cell references as the data can then be dynamic.
...

### Office VBA Macros You Can Use Today

by Published on 2006-01-02 07:15 AM     Number of Views: 1742

Originally Posted by MrExcel.com
You might be comfortable writing code for Excel in VBA. You realize how cool VBA is for Excel and you wonder, "is it possible to automate the creation of PowerPoint slides?" I will admit that once I step outside of the realm of Excel VBA, I am completely lost trying to automate Word or PowerPoint or Outlook.
...

### Quickly Eliminate Duplicate Records From A Specific Column

by Published on 2005-10-08 06:17 AM     Number of Views: 17808

Macro Purpose:
• Function to quickly remove all duplicates from a specified column in Excel using VBA.

Examples ...

### Extract Novell Groupwise Attachments And Save To A Directory

by Published on 2005-04-20 06:25 AM     Number of Views: 13275

Macro Purpose:
Scan a user specified Novell Groupwise folder, and save all files of a specific type to the directory specified in the code.

Examples of where this function shines:
Assume that you have emailed out 600 surveys in a word document, and you want to save them all to a folder for further processing. Rather than have you save each file to the folder manually, this code will extract them all at one time.

This code can be very easily adapted to work with any type of file, since it examines the last three letters (the extension) of each attachment to an email. This means that you do not need a program capable of opening the file on your hard drive to run this code. ...

### Function to Return Various Environment Names

by Published on 2005-01-04 08:32 AM     Number of Views: 16352

Function Purpose:
This function can be used to retrieve one of three types of usernames, and can be used in a worksheet cell or in VBA.

The usernames that it can return are:
• Microsoft Office username (default) as defined in Tools|Options|General
• Microsoft Windows logon name
• Computer name (as defined in your system properties)

...

### Export A Range Of Excel Data To A Database

by Published on 2004-12-20 07:09 AM     Number of Views: 52186

Macro Purpose:
• Exports a table of data from Excel into a database, using an ADO connection to pass SQL strings.

...
Page 6 of 6 First ... 4 5 6
• ### Recent Forum Posts

#### Copy paste into dynamic column

Code:
```Columns("K:K").Insert
With Intersect(Columns("C:C"), ActiveSheet.UsedRange)
.Offset(, 8).Value = .Value
End With```
...

p45cal Yesterday, 11:57 PM

#### Copy paste into dynamic column

Sorry for posting prematurely, but I solved it.
Probably far from the best solution, but it does the trick for me:

Code:
`        Columns("K:K").Select`
...

Lolbert Yesterday, 07:09 PM

#### Copy paste into dynamic column

Hi

I have this simple VBA code where I run a macro to copy a selection and paste it on a new selection.
What I need is for the code...

Lolbert Yesterday, 06:53 PM

#### Find % change from last month automatically updated

Hi Bob, thanks for helping me. I have had to move on to other more pressing tasks. Will get back to you when I come back to this....

GraemeSS Yesterday, 03:42 AM

#### Find % change from last month automatically updated

Try

=(OFFSET(\$B6,0,COUNTIF(\$B6:\$AF6,">0")-1)-OFFSET(\$B6,0,COUNTIF(\$B6:\$AF6,">0")))/OFFSET(\$B6,0,COUNTIF(\$B6:\$AF6,">0")-1)...

Bob Phillips 2020-04-07, 07:11 PM