![Goto Guest book sign in page [Home]](files/guestbook.gif)
| VBA - Quick routines Pg 2 | ||||
| What | Description | Link view | ||
| Screen size | Routine using Shell and an API to get your screen resolution, with the option of changing it. | < View this | ||
| Cab files view | Opens Windows Cabinet files | < View this | ||
| Text case change | Word has this BUT Excel doesn't, ie A Text change button to change text case to Upper, Lower, Sentence or Titles. Here is a short routine to do this… | < View this | ||
| Is File Already Open | One way test to see if a File is already Open - NOTE: Return value of Function is a string! | < View this | ||
| Move File | Moves a File to another Directory | < View this | ||
| Search for Folder | Search for Folder by name using WMI. Finds All instances or the 1st instance | < View this | ||
| Undo | Change Xl's Undo history -default undo history is 16 | < View this | ||
