Archive of What's New blog
Can Do
Thanks for visiting my site lucky visitor:
This page was last updated on: September 14, 2007
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
5th Feb 2005
Thanks to some great info from Chip pearson I have made this Addin that gets your Office applications Constants and the group they belong to.
5th Feb 2005
A must view for the examples it gives you. Have a look @ what you can accomplish via this control. I have given examples of different things.
10th Jan 2005 (Comming soon)
Userform Menus: Creating Userform Menus using pure API's as opposed to commandbars which I used a while ago for this The NotePad type form
2nd Jan 2005
Get Ordinal number: Here is a UDF that gives you a numbers ordinal
2nd Jan 2005
NotePad ONTOP: As part of the Tools collection a routine that instantiates NotePad BUT keeps it ONTOP of all other windows. I have found this handy for when I need to copy & paste from multiple applications certain data and place it in one place ready for pasting into Excel.
2nd Jan 2005
Hex File Reader: Part of the Tools collection that I have used for some things such as Gif animation
1st Jan 2005
Tools: Here is a page that lists some of the Tools I use within Excel.
27th Dec 2004
Using the WebBrowser control (Examples - comming SOON!)
A must view for the examples it gives you. Have a look @ what you can accomplish via this control. I have given examples of different things.
19th Dec 2004
See here to use an animated gif on a Userform. This routine DOES NOT require that you reference the gif from your local drive, so you DON'T need to include the gif file if you ever need to give your files to someone else.
12th December 2004
Executables path: Here is a routine that will get ANY exercutable programe path, given it's file extension or path to a file or document. Very handy when you need to know where the executable program is.
26th Nov 2004
Another use for this dll - animation on a userform. Many people want to use an animated gif to show on a userform. Here is an alternate way to animate on a userform.
7th Nov 2004
eg extension := .xls Type = Microsoft Excel worksheet.
20th Sep 2004
Here is a routine that uses WebQueries to get Domain Names Of IP Addresses from ARIN
19th Sep 2004
Frx Files: Sorry about delay see here about FRX Files and what they are. So what can we use this frx Userform for. I recently used it to get some old icons I had forgotten about and lost from an old Userform I made some years ago. You can also get images, icons from VB frx files that you see off the net.
11 Sep 2004: (Coming soon)
Userform Menus: Creating userform Menus using VBA and Pure API's (2 methods) A must view!
5th Sep 2004
Progress Bar Use this dll to get the progress bar and place it any where you like. I have done this for Userforms, other applications and Excels Statusbar. This particular example is placed on the Statusbar area.
22nd Aug 2004:
FRX Files: While I'm on imaging, do you know what an FRX File is? Well if you have Exported Userforms then you may have come to realise that these files are created along with the .frm file. Read here about what they are and how I have deciphered them to get there contents (Images).
21st Aug 2004
RSS Reader: If you read blogs, and I am beginning to read a lot more now, then check out my friend in Japans (Masaru Kaji aka Colo) RSS Reader addin. Colo has allowed me to host his Addin (A great addition) Thanks Colo.
13th Aug 2004
Userform search utility: A search form Addin like no other. Yes I have being promising this one for over a year now. While not totally finished you will like all the functionality that this offers. Search using MOST major search sites. Use the built in note pad to either copy notes or make notes. You can even copy the sites html coding/links etc OR just get the text and save it right within Excel. Userform includes keep on top, fading in and out and many more features too numerous to list here. (for Excel2000+)
28th July 2004
Userforms: Here is one I did a while ago to Minimize your Userform to the TaskBar. I was actually prompted for this when I saw my good friend in Japan (Colo MS MVP) post his code here. His technique is a little different in that you will need to Hide the Excel Application. My technique doesn't require this.
I Will also include a technique to Minimize a Userform to the System Tray! (Keeps the clutter out of your Taskbar)
11th July 2004
Painting in Excel? Have a look @ these images.....NO they are NOT inserted Images they were created in Excel using the cells as pixels, similar to what you see with news paper images. Want to know how to do this, then have a look here........ You can even sign your images.
18th June 2004
Splash screens (Userforms) Want to add that finishing touch to your project. Then look here for examples of Splash screens via Userforms. Routine includes taking care of Disabling macros.
13th June 2004
Security settings: Security settings for versions of Excel > 2000 need to be considered when programing to the VBA Project. See here for a routine that takes care of this setting.
27th April 2004
Office Document properties. This Addin allows you to get MS Office document properties and change them. Also of note is the Property .Hasmacro i.e you can determine weather the document has macros. It was adapted from VB code and is very useful for updating document properties WITHOUT opening the document. You can even add you own custom properties.
16th April 2004
Shell32 - Info ToolTips. Have you ever noticed that when you hover your cursor over a File while being viewed in Explorer, that the OS displays a kind of Tool Tip? What you see displayed varies from File description to Zip contents. Here is a way to get this info using the powerful Shell32.dll.
13th April 2004
Forum Logon here to one of the largest forums with hundreds of technical support forums and mutual help system for computer professionals. Selling and recruiting forbidden.
9th April 2004
Email a selection as an inserted Image Email a selected range as an Image. Using this routine, you can email a snapshot of your range selection from an Excel sheet INCLUDING graphics, charts, buttons or any object. Simulates inserting an image within your mail.
16th March 2004
Xl2000 Vs Xl2003 Constant comparison of these constants shows you what is new with Xl2003.
8th Feb 2004
Get a list of ALL your Macro shortcut keys using this Addin. A must have if you have ever lost a list of all those
short cut keys for your macros, OR you need to list them automatically.
1st Jan 2004
You DON'T need Excel XP to do speech within Excel. Have a look @ this page, that shows you how to do
speech with a couple of lines of code! Download an example workbook.
7th Dec 2003
Need to save a range selection as an image file.....then look here
29th Nov 2003
Change Microsoft Excel's Undo History using Windows scripting
2nd Oct 2003
Typical functions to check if a file is open really only check to see if is open in the current Open application.
Here are 2 examples (API & VBA - related!) that will check if a file is open by any one. You can use this to
check if ANY File is open.
27th Sep 2003
WMI link FINALLY updated.....
A useful list of VBA Constant comparisons between XL97 and XL2000, 120 differences.
9th July 2003
Rather then do examples of standard userforms, and keeping within my Xtreme theme I am putting together
some projects that use Forms with different shapes eg, Triangles, Circles, forms with holes, diamonds AND
infact ANY Shape eg have a look @ this userform shape. These projects involve searching the Internet via Google, MrExcel, Microsoft News groups etc. Forms use transparency so you can see through them.
9th June 2003
Word has the ability to change text to Upper, lower, Sentence and Title case via buttons, BUT Excel doesn't. here's a routine that does this for you....change it to an addin if you find this useful. This file code was made into an Addin, and now thanks to Mike Leslie, it has been amended to include a smallcaps option...see write-up.
8th June 2003
An example of using the Shell32.dll to Browse for a Directory and get file info eg. Name, Size,Type,Date Modified
Date Created, Date Accessed,Attributes,Status,Owner,Author,Title,Subject,Category,Pages & Comments.
The example workbook is just one part of using the Core Windows dlls....more to come.
12th May 2003
Routine that inserts ALL image files from a user selected Directory and places them in a worksheet with it's name, size and file date.
11th may 2003
The DumpBin Workbook allows you to extract the functions from the DLLs and place the list in an Excel sheet (See above example). Very useful when trying to workout which functions belong to which DLL..
See code for Credits = Dan Appleman.
8th May 2003
A BB was added, thanks to my very good friend Colo. Use the BBS to leave messages, Code snippets OR anything you like.....
27th April 2003
Word has the ability to change text to Upper, lower, Sentence and Title case via buttons, BUT Excel doesn't. here's a routine that does this for you....change it to an addin if you find this useful.
23rd April 2003
Ever needed to keep a Window on top. Here is some code to do this using APIs. Example WorkBook uses the Calculator Applet and forces it to stay on Top when it looses focus. This can be handy when ever you need to continue using / viewing a Window while working within Excel. Apply this technique to any Windows eg Userform or Notepad or system timer etc....the possibilities are limitless...
6th April 2003
If you have ever used the InputBox for verifying a user password then you would have realized that the Input typed in does NOT offer a password character ie. Typing shows your password. You may have resorted to a Userform with a textbox control which offers this property. Here is a method that does this for you. See write up.
Amended to work in Xl97.
3rd April 2003
If you ever wanted to email a chart image automatically from within Excel, then here is how to do this. I initially thought this would be easy....BUT.....a problem arises in that an Html image needs a URL and NOT a URL reference to your html chart image on your hard drive. Here is a work around for Outlooks apparent lack of programmable objects.
1st April 2003
Amended code for the clock below to work in Xl97, thanks to Sameer Bhide for suggesting this.
Code uses the work around for the Addressof operator by Ken Getz and Michael Kaplan.
30th March 2003
A digital Alarm clock - uses API Timer. The difference with this method as opposed to some others is the fact that the clock will continually up date even in "Edit" mode or using the cursor to update cells eg Fill etc.
In some cases editing a cell will halt the macro that updates the clock (Doevents coding) and
with Ontime the timer will halt until editing is finished and restart. This Timer will Activate the Alarm even IF Excel isn't Active.
NB: Works on Excel2000+
Using the API Timer, the updates will happen seamlessly.
11th March 2003
A routine to zip a user selected workbook and email it using Outlook. The routine uses an API to monitor the zip process and continue with the routine AFTER the zip operation.
Routine has been amended to zip multiple file selections of ant type.
7th March 2003
- Routine to get your screen size, with the option of changing it via the Std. windows control set-up.
- Routine to open Windows Cabinet files.
5th March 2003
The above pages shows how to get DLL versions and file descriptions.
1st March 2003
Shows how to get Excel object Window handles and Class names. This was used to get the Windows class names for the NameBox drop list so that we could increase it's width. You can also use this to get other running application handles and there class names.
15th Feb 2003
Time zone calculations using UTC (GMT) given your current time or a user selected time. Returns the times relative to your time and the UTC difference. You have a selection of 540 Cities to choose from.
14th Feb 2003
Amended current code to take into consideration the international language issues that some functions do not translate or intemperate some keys words eg TRUE as used in VBA conditional formatting code. My thanks to Juan Pablo G
9th Feb 2003
added Html site insert to Kouichi Tanis' Xcelent games web site. He is in my opinion one of the great Excel games programmers, you have to see his games !!
Added more pictures
Fixing clipboard formats in java scripts for inframe html.
This will allow you to copy the codes via the press of a button (See below)
8th Feb 2003
- Added Andy Popes belt to the growing list of Cell Masters. Read all about it here
- Amended current code page for Comdlg32 with inserted html page for easier copying.
- Amended code page for Using the default Mailer with inserted html for easier copying.
Added 7th Feb 2003
Added pictures to this page dedicated to my brother, sister and there families in the USA.
Added 5th Feb 2003
Rather then recreate the wheel I Added references to the MrExcel site page for Tips from the big 3, John Walkenbach, Chip Pearson, MrExcel. I will eventually add some of my own tips that I have found useful when I get the time.
Added 4th Feb 2003
Using the Comdlg32.Dll to show the Open File dialog.
The advantage of using this dll is that you can do File Filtering not available via the ApplicationGetopenFileName function. eg. filter for files with "help" anywhere in it's name > *Help*.xls
Added 4th Feb 2003
Excel guru John Walkenbach gives us his script on how he got started on the road to the cell masters here
Added 2nd Feb 2003
Down loads added:
- Timer mm Secs Displays time in mm secs on a Sheet
- Userform Timer Displays time on a Userform in mm secs
- Animated gif using OCXAnimate a Gif file using this OCX control
- Splash screen using Flash A Userform Splash screen using Flash by my Friend Scott Pierson
- Animated Prank One of the 1st animated ones I did in excel, this was just for a Prank
- it simulates your Disk being formatted.
- File date/time changer Changes ANY files Date & Time via API calls
Added 2nd Jan 2003
Some Lotus notes code from my friends in Sweden & Columbia.
