XcelFiles Site Map

---

MAIN PAGES	SUB LINK PAGES	BRIEF DESCRIPTION
Index		Home Page
Books		Books I find useful
Whats new		What's NEW on this Site
Links		Links to useful sites
APIIndex		Index of API pages
	WhatsUpClass	Whats up - Classes & things
	API_01	API - What is it
	API_02	API - Timer
	API_03	Change File Date Time
	API_04	Extracting API Functions from DLLS, OCX
	API_05	Getting Dll versions
	API_06	Getting Excel Object handles & Class names
	API_07	Getting Dll version and File discription
	API_09	Changing the InputBox password character
	API_10	Keeping a Window OnTop
	API_11	Custom msgbox
	API_Userform_MenuMaker	API Menu maker - for Userforms
	ApplicationFilePath	Get an Applications file path
	ProgressBar	Creating progressbars
	ProgressBarXP	Create an XP style progressbar
	AVI	Create AVI Files
	AnimatedGif	Create animated gifs on a Userform WITHOUT the need to reference it from a local drive
	comdlg	Filtering Files using the comdlg32.dll
	IsFileOpen	Check to see if a file is open AND by WHO
	Shell32_00	Browse for Folder using the Shell32 Dll
	Shell32_01	Get file properties extracted from the Namespace Folder you select
	Shell32_02	Get File Info Tips
	ShellExecuteA	The API function ShellExecuteA
	ShellFileType	Get the file type info, given it's extension
	VBA_Clock	Digital Clock
Tools		Index of some of the Excel Tools I use
	GetShortCutKeys	Get a list of your Macro shortcut keys
	HexFileReader	Read ANY file and dump the hex file to this spreadsheet
	RSS	RSS Reader (Colo)
	NotePad_ONTOP	Keep your notepad ontop
	DocProp	Get Microsoft document properties
	Security	Find out if your security is set
	SeachSite	Userform search Form
	XlSearch	XcelFiles search
Our_Service
	About_Us	Who am I
	AgreedPayment	Agreed payment options for consulting
	Contact_Us	Where to contact me
	ContactForm	Consulting form
	ContactFormHelp	Consulting form help
	Donate	Making a donation & why
	Feedback_Form	provide feed back, always welcome
FormsSearch		Userforms - various userform examples
	FRX	Get image files from FRX files
	IconsEx	Create icons on a userform
	ImageToXL	Create images as pixels on a spreadsheet
	SplashScrn	Example splash screens
	TTS	Text to speech
	Userform_SystemTray	Minimise a Userform to the System Tray
	Userform_TaskBar	Minimise a Userform to the Taskbar
Down Loads	Downloads_01
	Downloads_02
	Downloads_03
	Downloads_04
	Downloads_05
	Excel00	XTreme Excel
	Excel01	Excel - Can Do
	Excel01_01	Change width of Excel's NameBox
	Excel01_02	Changing the colour of the Tab
	Excel01_03	Open Chm Files
	Excel01_J	Japanese Excel - Can Do
	Excel02	Xcel
	Excel04	Excel animation
Formulas01		Index page of formulas
	Formulas_00	Time Zone Calculations
	OrdinalNumber	Get ordinal number function
Forum
Games		Xgames, some amazing games here
Non_Excel		Non Excel
Products		Products available
Training		Training available
Translate		Translation page
USA		Images of my family in the USA
	HowTo_01	How to Register Controls,Clean VBA Projects and Why,
Email		Email Codes for Outlook & Lotus notes
	LotusNotes
	LotusNotes01
	LotusNotes02
	Outlook_01
	Outlook_02
	Outlook_Chart
	EmailImg
PrintIndex
	VBA_prt2	Print certain sheets
	VBA_prt3	Disable Printing dialog
	Prt_Tray	Changing printer tray
Tips01
	XL2000_2003C	XL2000 constants Vs XL2003 constants
	XL972000C	XL97 constants Vs XL2000 constants
	VBA_Quick1	Environmental Variables
	VBA_Quick10	Clean Cells with unprintable text characters
	VBA_Quick13	Disable Cut Copy & Paste - Disable ALL Cut Copy & Paste functionality for a workbook
	Excel03	Timed message box, via scripting OR API
VBA_Quick		VBA - Quick routines. Just some short routines
	VB_Quick14	Get screen size
	VB_Quick15	Open Windows Cab files
	VB_Quick17	VBA - Save range as image
	VBA_01	Misc VBA code
	VBA_02	VBA - Using Static variables
	VBA_InsertImgs	Inserting Images
	VBA_Quick11	Routine to Add image files to comments for a different looking comment.
	VBA_Quick12	Get Activecell alignment
	VBA_Quick16	Text case change Addin
	VBA_Quick2	Show [About] form
	VBA_Quick20	change undo history
	VBA_Quick3	GetColumn Letter Just one way to get the column letter(s)
	VBA_Quick4	Gets your processor speed and make
	VBA_Quick5	Get your computer system info eg Model, make, ram etc
	VBA_Quick6	VBA method to use AutoSum method on the Activecell, simulates pressing the Autosum button
	VBA_Quick7	Convert a selection of text to proper case
	VBA_Quick8	Commands to open and close your CD Drive door (or coffee holder !!)
	VBA_Quick9	Routine to show the Windows [Find ALL files] dialog Win9x and the [Search] for Win XP
WMI_index		Windows management Instrumentation
	WMI_OS	Get your Operating System details via WMI
	WMI_Processor	Get your processor details via WMI
	WMI_SrcForDir	Search for a folder within your system
	WMI_XLinst	Get the number of XL instances running
WebBrowserCtrl		Extreme examples of using the Webbrowser control
WebQueries		Web query details of of site via it's IP address
AmericanIdol		Screen shots of AI made via Images to Excel spreadsheet
MerilynMonroe		For Anne Troy AKA Dreamboat
Photo		Family Photos