What's New blog
Can Do
Thanks for visiting my site lucky visitor:
This page was last updated on: January 7, 2008
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
I have 2 workbooks in the Pipeline that I have DEDICATED TO MY WIFE, coming soon. They represent a
number of years work, due to the fact that it was done on/off. I am sure you will enjoy.
Nov 2007
Need a magnifyier in Excel, have a look here where I create the image under a cursor and display it magnified onto a Userform.
Aug 2007
Ever wanted to download Videos from YouTube ? Here is a way to do this...
Animated icon in Userform - Taskbar - System Tray
July 2007
Have a look here @ MyDearFreinds! downloads. Some good work done here.
A work book from a French forum I particpate in that shows international danger signs. I translated from French to English and made minor amendments ... by Staple1600
Danger
June 2007
Microsoft® Outlook® 2000 included an object model to support programmatic access to the features in the Microsoft Outlook View Control
May 2007
Apr 2007
Get Macro shortcut keys: An amendment made to this Addin to get your Macro shortcut keys, thanks to Don Wells
Get the name of the default emailer: A function to get a users default emailer name eg Outlook, Lotus notes
Control Panel item: Display your control panel items from Excel
Userform - display Desktop This userform displays your underlying desktop image. Move it around todisplay it.
Get Keyboard name A function to get your REAL local Keyboard name
Mar 2007
Save as EMF Here is a method to save a selection, either a range OR and object eg Picture / Graph etc as an EMF File that you can then Import into another application or Userform Picture.
Nov 2006
ImageToXcel A while ago I produced this spreadsheet to display images to Excel. TRY IT IN XL2007 !!
Nov 2006
Msgbox > 1024 characters If you have ever needed to fit more then 1024 characters into a VBA msgbox, then you have found that you cannot! Here is a way to do this (No not by using a Userform!)
Nov 2006
Change XP Start button text A question that caught my eye. How do you change the Start button text. I had done this before BUT the 2nd part was of interest..... changing the text to any character length AND adjusting the taskbars dimensions to fit!
Aug 2006
Monitor Directory Here is a method to Monitor a Directory for changes see write up @ Dicks Blog
17th July 2005
Userform Icons: Need to place an icon in a Userform caption. Here is how to do this.
21st June 2005
Here is how to do this IF you have Windows XP.
Coming soon.............. customize your WorkBook Open "Lookin" folder selection see below.
6th June 2005
ImageToXcel: A workbook produced using this program ... an example file. One of the 1st ones produced for John Walkenbach. I'm sure your'll like this one.
10th March 2005
Create your own userform menus via this Userform Menu creator just like John Walkenbacks routine.
Looking for the old whats new files ? See here
This page gives you a listing of what I have recently added or amended to the site for quicker reference, saving you some time if all you need to check out is what was recently added. If you have a routine that you think that should be of interest to others or you wish me to expand on something then drop me a line.
NOTE: I am aware that trying to copy codes from pages is hard - impossible. I am looking @ a fix for this, in the interim I will try and post code as an html link like this;
My thanks to my friend Mark O'Brien - " VbNullString "
Also when time permitting I will insert Code pages (see Example HTML below)
