Using Windows XP, EXCEL Office 2003.
Each time I open an EXCEL workbook, I get the MICROSOFT VISUAL BASIC system
error '&H80004005 (-2147467259) unspecified error' message. I click on OK
about 17 times and then get another error message 'Compile error in hidden

I am having a problem with the display of control check boxes and option
buttons reflecting the value of their linked cells.  
I have a VB macro that goes in and changes the value of the cells that
controls are linked to.  When the value has been changed, some controls

How do I limit the number of characters in a textbox on a userform?
Thanks

I've created a function that formats my date filed to mmddyy so that all I
see is a six digit number for example from 04/21/08 to 042108. I do this
because I'm creating an upload file that requires a prn extension with the
date field formated as 6 digits and number only. This ...

In my Excel app, I load and save data to/from Access, using VBA/ADO code. Loading dates from Access is problematic. I get 39448 rather than 2008-01-01. I can change it manually with Format Cells and pick the short date format, but how would you do that in VBA? Do I have to set ...

I am having a web query in sheet1 (A1:E30) and it is based on a macro which
runs worksheet_change event.I am trying to add another 2 web querys to my
sheet from f1:k25,these are not based on macros.Whenever I am trying to
refresh these querys all are vanishing from my sheet and ...

Without looping, in VBA, how would I take each numeric value in column
A and change it's value to get only the right-most digit?
Thanks,
Sheldon

I've got the following code which exports all sheets containing charts to a
new workbook.  Each sheet name is also copied across, as well as all summary
information.
I've now added 8 logo's onto each source sheet, therefore in the process of

I'm using a worksheet that list my data like so:
      C           D
5   AHU         Air Handling Unit
6   DKFTN     Drinking Fountain

What is the vba code for expanding and collapsing a range of columns or rows?
I want my program to expand a group of columns, print a named range, and
then collapse it once again.
Any suggetions would be greatly appreciated.

I suppose the Subject sounds a bit contradictory, but there is a
method to the madness ....
What I'd like to do is set up a simple auditing tool to select
(mostly) random entries to be audited.  Here's the setup:

What are the codes to copy a text file from the internet location
"http://www.myweb.com/myfolder/TheTextFile.txt" to my local C drive as
"C:\TheTextFile.txt"?
I tried FileCopy but to no avail.

I have two (related issues). Firstly that I have 12 user forms, each
with upwards of 600 text boxes (yes i'm creating a calendar!). Each of
these needs the control source setting. This is issue 1!
To solve this I figured the easiest way was to name these textboxes in

I have to do different things ([BLOCK 1] and [BLOCK 2]) if Z is a
"Single" (a number or a Range of 1x1) or if Z is a Range (a genuine, not
1x1). My workaround is like
If TypeOf Z Is Range Then

I have a sheet full of names, dates and particulars.  Over a period of time
some parts of the sheet is copied and dragged down,  some cells erased  etc
using 'clear contents' in VB .
Invariably some of the cell loses its format and few will be aligned center