Thanks for your replies.I have to develop an application which will
read a .DAT file.There are several hundred records in this file.Also I
get another excel file with adds and deletes.
There are records in this Excel file with matches in the DAT

I have an EXcel VBA app and want to limit what the user can see on each
worksheet. The user needs to able able to scroll a certain amount to view
only the work area, but any ideas how I can limit the viewable area to no
more than that. I assume to somehow limit the extent of ...

I would like to find a way to reduce the amount of time it takes to export
all the VBA source code from a spreadsheet to a text file in Excel 2007.  
Currently, I click on each module in turn, then go to File, Export, etc.

i would like to use an index of customers and be able to be able to link from
the index to customer information on a seperate folder (or simular) to enable
me to access detailed information easily

Been messing around with very basic controls but frustratingly unable to find
a post showing how to update a value initially displayed in a Control box.
I have about 12 items of standing data, held in variables, with values which
will not often be changed.

I used some very simple vba codes to automatically save a file to several new
locations on a server after editing as a private sub in WorkBook_BeforeClose
event.  It works ok but the vba codes were also saved in the final output
workbooks.  Is there anyway I can disable the codes ...

I would like to organize my tasks so as to be more effective in my daily
obligations.
I want the list to be ckecked after completion of every task.
I want to learn.

How can I initiate a Macro when I change a selection from a DV
Dropdown list?
I have a DV Drop down that selects a week, I then have to run a macro
that clears data. Could I in effect join the two together, if so how?

Brand new to programming in VBA, I am looking for a code where the vba will
look or a particular words and replace in another column;
e.g.
Column A   Column B

i forgot the password of excel file, then how to open that particular file?

Dear Excel Gurus,
After adding several features, my worksheet running Excel VBA has become
very slow. I am thinking of migrating the VBA application to Visual Basic
.Net

Hi team from chilly autumn London
Does anyone have any backup routines they regularly build into their
sheets?
I've replaced a few paper processes at work with excel sheets and

Excel is a tremendously powerful application. Why the miserly, or at least
seemingly arbitrary, restriction to three (magic number?) conditional formats
for a given cell or series of cells?
I am a university lecturer/administrator at the Université de Nancy 2 in

Can anyone help me understand why this does not work if there are no
pivots on the current sheet. this code is supposed to either use the
pivot the user selected or the 1st pivot on the active sheet and then
update the source data. It works perfectly except when a work sheet

Hi! I have a loop that sometimes opens o workbook. when the loop is finished
I want to close that worksbook, if it is open. However I get Err 13 when
trying to close the workbook (which is not a problem here but I becaomes a
problem later so I must solve this). I have checked all ...