I have a tab delimited text file (over 300 variables, so I can't stick it
straight into another Excel workbook) and I am trying to use ODBC to connect
to the text file and pull values into an Excel file.  The code I have so far
doesn't seem to be picking up the field headers.  ...

I have image files contained in a specific folder, for instance, C:\ABC
I have now an excel file contains all the file names in column A.  How can I
match the file names with that column and create hyperlink in each cell
containing the file names ?  I can create it one by one but ...

I would like to use a formula with variable to access worksheets
(Like the VBA Worksheets(Range("a1").Value). I do not want to use VBA
because I need the user to see the formula.
My worksheets are named 'Input','Definition' . . .

I am trying to import a worksheet that I copy and paste into a model.
I need to erase the values in a specific row, in columns B thru G if
the first 5 characters in column B contains the word "Total". I also
need to erase the values in a specific row, in columns B thru G if

I have a form that loads when a workbook is open - call it 1st Form.
1st Form compares the current user to a list in the file.
If they are not on the list, it runs the 1st line of code below which calls
up another frmNotFound (aka 2nd Form) with some messages and buttons.

I have a spreadsheet with over 1,000 range names.  90% are not valid anymore
I woul like to list all the range names thes be able to have the vba code go
through this list and delet all the ones that I tag as non needed
thanks

I have a field with values "AAAA", "0AAA", "00AA", and "000A".  I want to
remove leading zeros on the ones with leading zeros.  For example, "0AAA"
will turn into "AAA".  
Can someone help me with the formula?  I have tried using "Val" and "Str",

I am trying to do conditional formatting to change between three different
color across the rows based on a column H.
Column H has either 700, 800 or 900. If the rows has 700 in column H then
the cells across the rows are highlighted in yellow, 800 in blue and 900 in

I am working through "professional Excel development" book by Stephen
Bullen, Rob Bovey and John Green.  I am stuck on a particular part,
there is an add-in that  automatically adds a tool bar that allows the
user to "post to network".  Every time I try to use the post to

Greetings all.  I am trying to use sumif where the range and the sum range
are the same.  I want to have one cell, say H1 that displays the sum of all
values in the range H7:H10000 where the value is negative.  This is what I
have tried, but I get the error box saying there is ...

I'm writing a macro for Excel that will copy large ranges of data and paste
into a new worksheet preserving the historical data. The number of rows to
copy changes dynamically on almost a daily basis.
Is there a function that can be written into a macro to change the range

Hi I have been trying to add to a combobox column using
ComboBox1.Column(0)=.Fields(0).value
ComboBox1.Column(1)=.Fields(1).value
but I keep geting an error can someone please point in the right direction.

This is probably so basic I'll shoot myself but I can't get this simple
command to work.
Basically,
I have an empty box that the user can type a string in.

Hi All,
 I'm just getting my ankles in the water re: ws selection
change event code.
 The sub below is doing what I want, re: selection.

Refer to the post in Worksheet
Does anyone have any suggestions on how to hold Macro running until specific
file being updated?
When I run a Macro, in the middle of the process, I would like to hold Macro