Here is the problem that I am having with an Excel spreadsheet
application – While attempting to import text files into an
Access .MDB database through the procedure I have listed below:
This is the calling function:

I need to know if there is any way of copying formulars down the colums but
I dont want the entire formular to change with the repositioning of the cell
WOW that was a mouth full lol
here an example :

I have workbook#1 which contains rows of information which I need to
copy into workbook#2. This is simple the 1st time but the data in
workbook#1 does change and therefore periodically I need to update
workbook#2 with the new data.

A1 contains the column heading "NAME"
A2 thru A700000 contain names (each name can occur 1 thru 25 times).
B1 contains the column heading "AMOUNT"
B2 thru B700000 contain amounts

I save all my files as either .xlsx or .csv. Usually I need to save
the same file as both - once to preserve features such as charts and
once in .csv for import into another application.
Is there a way to add a format to the "save as" window? That is, I

On sheet1 the data is oriented vertically as
A1
A2
A3

Save Excel file to HTML.
Which way would you save an Excel file to HTML ?  Office 2007, Web
Expressions and FrontPage.
I first Saved.AS to CSV then to Html.

I have a page in spreadsheet
Lets say columns a to z
A and B are for stock figures and also M and N are for stock figures
Is there a way to print the sheet A to Z but not have columns A,B,M,N on the

I have a form in excel which contains 8 values, and I would like for those values to be transferred to a different sheet once a specific button is pushed for uploading purposes. Is this even possible?

Is it possible to use hours and minutes (hh:mm) as the parameters in an IF
statement.
Regarding the formula below;
=IF(ISBLANK(E20),"",IF(E13<9,"Rest",IF(E13<11,1,"OK")))

This is Excel 2000. Cell C2 in a worksheet called 'NOTES'
contains '34 West Street, somewhere-in-England'
=UPPER ( NOTES!C2 )
is supposed to produce ' 34 WEST STREET, SOMEWHERE-IN-ENGLAND'

Is there a way to prevent the R1C1 Style Reference from activating?
I have some users that use that format and when I open up their document, it
changes my settings to that format.
I don't want that format to change.  Is there a way to prevent this?

When I select multiple sheets in Group mode, I am having trouble seeing which
ones are selected and which ones are not.  I changed the tab color, but this
doesn't seem to do too much (just a small colored line under the text of the
tab). Any ideas on how to make it easier to tell ...

I have posted my issue before but a colleague has the same issue. We have
macros which run some code including a refreshall. The refeshall does not
complete before the macro goes to the next step and this causes it to crash
or not work correctly.

I frequently need to make a change to hundreds of excel files. The
change is sometimes as simple as renaming a column name or inserting
some text. Does anyone know of a tool that can help me accomplish this
without having to manually open each excel file?