I wrote some Excel VBA code some time ago for a particular department within
my organisation. I always use VBA editor passwords that are somewhat related
to the particular department concerned - and to what application related
(i.e. Excel, Access or Word). However, this Excel ...

Hi...
Big problem here so any help appreciated.
I have 4000 files all randomly saved with any name you wish to name, all in
the same folder. The only thing the 4000 files have in common is that each

I have the following formula, which calls a function in order to get the
windows user name, and then offers them a greeting.  What I'm trying to
do is take the user name and turn it into thier real name.  I only have
about 5 people that use this workbook.  So I'd like jdoe1 to be ...

While running:
Sub rename_it()
ThisWorkbook.VBProject.VBComponents("Module1").Name = "new_check"
End Sub

I had a question about validation lists which hide previous selections. I
read the torturial on: http://www.contextures.com/xlDataVal03.html. I tried
it and it worked but i would like to add choises to the list which cant
dissappear if previous selected.

Has anyone tried to link two workbooks running on different machines??
I found an interesting article on how this can be done --
http://support.microsoft.com/default...b;en-us;128491
This is exactly what I want to do -- only problem I can't get it to

Is there a way I can apply a different default 'summarize by' value for my
pivot table fields?  as of now, it defaults to 'count' and i need it to be
'count nums'.  thanks

how to drag and drop from a listbox to activecell with vba ?
Thanks,

i am finding it difficult to change the number in excel to indian
standard.
when i give input as 123456789 it is giving 123,456,789.00
but i need the number to be as 12,34,56,789.00

I'm attempting to set up a spreadsheet that keeps track of pending cases
where a RECEIVED DATE is posted causing a DUE DATE to automatically propagate.
I have no problem setting up the pending formula (something like "A1 + 30")
but rather in the conditional formatting: I want the ...

I have a database in which I am storing information and assigning a ID
number to each entry.  From those entries, a report is generated and
saved to a designated directory on my server.  I would like to somehow
automatically assign a hyperlink to that forms ID number in the

I am hoping that someone could assist me in a problem I have.
I have a database consisting of three worksheets. The main worksheet i
"Database" which records the history of items pricing and repai
information, which change over time.

I have this code in VBA that calls a query table from a certain csv file.
However, the name of this csv file is not constant.
Therefore I would rather like VBA to open a browser screen that shows all
csv files in a specific folder, where the user can just double click the

I have a problem
The "A3" cell 's formula contain "A1" and "A2"
I want to do this work " when the value of cell "A1" change, excel
automatically GoalSeek cell "A3" to the goal:=100 by changing cell "A2"

I need a macro that will search for all occurances of the word "tool" in
col B of a spreadsheet and then copy the entire row of each occurance
and paste the rows in another worksheet within the same spreadsheet