This week's stumbling block concerns a form that I've built
programmatically. Let's say it looks like this:
Name1  |  Date 1  |         |  Comments  |
Name2  |  Date 2  |    X   |  Comments  |

Hi: Can any one please tell me how do i create a pivot table on
external data like Access table?
Thanks,

Is there a way to show tooltips for custom CommandBar menu 'items'? None
appear even though I've set the 'TooltipText' property for each item, and the
'Show ScreenTips on toolbars' option in the Customize window is checked.
Or, if this is not doable in xl2003 then is there a way ...

I've had this stupid problem that's been driving me crazy for six
months now.  I've got this important reference document that's many
pages long.  Each page is stored on a seperate xl sheet with seperate
tab.  I used to print the thing out on a double sided printer, with all

2003
Attempting to effectively use two windows currently "tiled"
Prefer a link "Sheet1"; Window("xxx:1") be followed in Window("xxx:2")
on "Sheet7"

If I wrote an Excel macro which runs and calculates until it meets a
cell, lets call it c78, and it continues running and calculating as I
wrote it to do, but I would like it to stop and wait for data to be
entered on cell c78 which  is one of the cells it passes on the run,

I have a line in a text file in wich I want to replace some text.
I read a line of the file, check if it is the line to be modified. If
it is not than I go to the next line and so on till the end of the
file.

This is my first time posting here , hope i will be able to find the
answer i am looking for. I'm very new to vba so please bear with me.
Here goes, this is the problem i'm having at the moment with my
formulas and vba and Excel formulas.

In Excel VBA, seems like all I have to do is select a row and invoke
.HPageBreaks.Add.
viz:
-----------------------------------------------------------

Anyone know how to pick out a digit in a string of characters like
this?  =---FS- 12345    I am trying to replace the first character and
my code keeps coming back with "type mismatch error 13".  My code is
simple (but wrong).  I am trying to get rid of the = character and

I have a userform (name=imagetype), that has an unbound texbox control
(name=MaxNulls).  When the userform opens, I would like to initialize
the value of MaxNulls to 3 ...is this possible?
thanks!

I have a spreadsheet that has a number of queries. The queries connect to a
SQL database via an ODBC connection. The ODBC Connection uses a common SQL
Username and Password. When I refresh the queries the ODBC connection
prompts me for the password for each query. I cannot use a ...

I have about 150 Worksheets in one Workbook. In all these sheets, I
need to delete the blank rows. I've already have a macro for that
purpose. Now I'm trying to figure out another macro for executing the
DeleteBlankRows macro on all the 150 worksheets. The code I have so far

Hello!  I have a ComboBox being populated with a named range of dates
(called date).  In another cell (named range "default") I have todays date.
How can I have the value in the combobox default to todays date, or
essentially default to the named range "default"?  Thanks in ...

On my computer I use Windows XP Pro, EXCEL 2003 and MS Visual Studio 6.  I
developed some EXCEL makros that use the Microsoft Flexgrid.  I could add
Flexgrid to the EXCEL dialogs because of the availability of Visual Studio.
Now, if my Makros are executed on other computers it ...