Assume I have two excel files. I'm having a file with the following
values in a workbook called First.xls under worksheet called 'data'. I
need to find the top 5 values and populate these values in a another
workbook(second.xls) in a worksheet called 'top 5 values'. How it can

I use VBA and excel 2003. I would like via VBA, copy the content of 1 sheet in
the file "test.xls" to a sheet in the file "filedesti.xls".
I tried :
workbook("test.xls").sheet(1).copy workbook("filedesti.xls").sheet(1)

i want to input the date only not text,time in the A1 cell.
using validation....
for example
=isdate(a1)

can any one tell me code for converting Table to Text
i have used this but its giving me error
'****************
Selection.Rows.ConvertToText Separator:=wdSeparateByParagraphs,

Hello there... i want to create a popup which will appear when i wil
open an Excel sheet and ask for user name and password. Please guid
me. Thanks in advance
--

Hi, I have a workbook that imports data from a folder containing .csv
files and puts the data from each csv file into a new sheet. What I
want to do is save the workbook and retain the sheets and the code that
fetches the external data, but not actually save the external data. Is

I have salary data in say 3 cells that I name them
(Insert->Name->Define) say CEO_Salary, VP_Salary and Manager_Salary.
Now when I sort this data the names point to different salaries. My CEO
is getting a Managers salary after the sort :-)

I have a excel problem.
I am writing a VBA macro for a generic Excel template to:
0. Upon first load up, immediately SaveAs (date-timestamp).xls to make a
copy of itself so that the generic template file can be opened by another

I was wondering if I could get a better random number generator than the one
in excel. I was also wondering if the VB generator is any better than the VBA
generator. Thanks in advance.

I have some worksheets that use a Vlookup statement to get information from
other worksheets. Right now I have the statement below repeated for 1000
rows. I'd like to remove these statement and complete the work entirely in
VBA code. One of the reasons for this is to make the ...

Moment of laziness? surely not.
Has anyone written a short proc. to convert bank entries which are text
ending with " Dr" and " Cr" into the numerical equivalent. I did do a Google
search but did not find anything useful

I'm trying to write a macro to loop through rows in a large range.
When it determines that, for example A2 <> A3 it inserts two rows.
It then counts number of records in that section SUMS all the numbers
in this section. i.e above first newly inserted row back to last blank

I found the below code (compliments of Tom Ogilvy) that works great for what
I'm trying to do.  I would just like one last step that I can't figure out.  
I want to convert all formulas to values in all sheets, which is what the
code below does.  When the code is done running, ...

I want to convert a column with "SSN" title in text but I don't know where
the column is located. The programation below gives me the first column wich
contains SSN title. Does anyone know how to find an exact match of the SSN
title ?

Hi - I'm printing a number of pages from a multi mage control on a
userform.
I need to print it landscape but don't know how to set the orientation
programatically.