Replies

It sounds as if you tried to open the file instead of installing it as an add-in.
You probably should close Excel and try the instructions below that
are in the Read Me file included with the add-in…

Installing:
Microsoft Excel 97 (or newer) is required.
Detach or copy “List Files.xla” to your hard drive

A “List Files” menu item should appear on the Tools menu (except for xl2007 users).
You could try unchecking it in Tools | Add-ins, ok your way out, then try checking it again.
What operating system/language are you using?
Jim Cone
San Francisco, USA

Not everything, but close to what you are after…
The free Excel add-in “List Files”
Also does folders.
Download from… http://www.realezsites.com/bus/primitivesoftware%5B/url%5D
No registration required.
Jim Cone
San Francisco, USA

Windows has several stashes of Icons distributed in some not very obvious locations.
In Windows|System32, check out …
moricons.dll
shell32.dll
Browse to them after pressing the “Change Icon” button.
Jim Cone
San Francisco, USA

Edited by StuartR to insert a valid link to Foxit PDF Reader instead of “http://linkurl/”

I just installed Foxit a free pdf reader after seeing a glowing review in the Washington Post.
It opens in a finger snap and is 1/10 the size of Adobe Reader 8.0.
Security issues are an unknown to me.
Jim Cone
San Francisco, USA
>http://www.realezsites.com/bus/primitivesoftware

The free “List Files” Excel add-in can make a separate list of folders
as well as list all files (with hyperlinks) in specified folders/subfolders.
Download from … http://www.realezsites.com/bus/primitivesoftware%5B/url%5D
No registration required.
Jim Cone
San Francisco, USA

The free Excel add-in “Shade Data Rows” can shade by…
cell value
every nth row
every group of rows of nth size

Download from … http://www.realezsites.com/bus/primitivesoftware%5B/url%5D
No registration required.

Jim Cone
San Francisco, USA

(Edited by HansV to make URL clickable – see Help 19)

Hans,
The Special Sort Excel add-in is no longer free I now sell it for $14.00.
A free trial is available. It has about 2 dozen sort methods
not available in Excel including a pretty good conditional color sort.
Details at my website…
http://www.realezsites.com/bus/primitivesoftware%5B/url%5D
Jim Cone
San Francisco, USA

Joe,
Attached is a workbook with a simple chart controlled by a combo box.
There are no macros. Note that the source range for the chart never changes,
but the data in the source range does.

Jim Cone
San Francisco, USA

John,
No mail from Australia has been received here in San Francisco.
Currently 8:55 pm Saturday night.
(remove XXX from email address)
Jim Cone
jim.coneXXX@rcn.comXXX

John,
You may want to try my Excel add-in “Special Sort”.
It should do what you want as it will sort “decimal” numbers into strict numerical order.
The add-in has a total of 12 different sort methods available including color, prefix/suffix, and date.
It will also sort cell borders (optional) with the data.
In my tests it did 1000 rows with decimals in about 6/10 second.
It looks and reacts similar to the existing Excel sort utility.
Comes with a Word.doc install/use file.
Available -free- upon email request. Remove XXX from my address.

Regards,
Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX

Don,

Hans gave very good advice about merged cells.
They are nothing but trouble.
However, I did revise your code and it may be worth a try…
(note: strReport was nowhere to be found?)
‘——————————-
Public Sub Replace_Formulae()
Dim mySheet As Excel.Worksheet
Dim oWkbk As Excel.Workbook
Dim objCell As Excel.Range

Set oWkbk = ThisWorkbook
For Each mySheet In Workbooks(strReport).Worksheets
If mySheet.Name “Transaction Sheet” Then
With mySheet
.Unprotect “pwd”
.UsedRange.ClearContents
‘a used range does not have to start in Range(“A1”)
Set objCell = oWkbk.Sheets(mySheet.Name).UsedRange.Cells(1, 1)
oWkbk.Sheets(mySheet.Name).UsedRange.Copy
.Range(objCell.Address).PasteSpecial xlPasteValues
.Protect “pwd”
End With
End If
Next
Set objCell = Nothing
Set mySheet = Nothing
Set oWkbk = Nothing
End Sub
‘———————-

Regards,
Jim Cone
San Francisco, USA

Take a look here…
http://support.microsoft.com/default.aspx?…kb;en-us;211922
“XL: How to Modify the Number of Undo Levels”

Jim Cone
San Francisco, USA

Take a look here…
http://support.microsoft.com/default.aspx?…kb;en-us;211922
“XL: How to Modify the Number of Undo Levels”

Jim Cone
San Francisco, USA

The Microsoft Scripting Runtime (scrrun.dll) provides scripting code in all recent windows operating systems.
It strongly resembles VBA and is rock solid dependable, straight forward and logical.
Its File System Object code is everything that VBA File Search should have been.

I’ve written an Excel add-in “List Files” using recursive MS Scripting Runtime code that…
Searches for the file type you specify or for all files.
Files and folders in the specified directory are listed.
Sub-folders also listed if specified by user
File name, size, date, type are provided
Directories/folder path is listed in one column and files in the adjacent column.
Each file is hyperlinked.
Available – free – upon direct request.
Remove xxx from my email address

Jim Cone
San Francisco, USA
jim.coneXXX@rcn.comXXX