I have used vba code to automatically save then close an pen workbook which
has had no activity for a specified period of time. Is it at all possible to
have a countdown clock displayed is a cell in the workbook indicating to the
user how long is left before shut down?

My objective is to select the row containing the highest value in a
particular column, copy the whole row and paste it in a different WS. I am
using this to find the MAX:
       For i = 0 To varCount

I have read many threads on the subject of VBA to VB6 versus to VB.Net
and yet I am not certain of the best course to take.  If I should post
my question to a different forum could you suggest an appropriate
one ?

i want to make a library in excel from VBA i need to put 3 things
1) INSERT
2)DELETE
3)UPDATE

i have afolder with picture files xxxx.jpg where xxxx is a number 0001-9999.
i want to load this files with just one click(command button) in a worksheet  
in an exact position x,y (x stable , and y 4cm down for every picture)from
the beginning of the axis

Hi TWIMC
I want to set a Range object to the xlR1C1Address of the print area of the
active sheet
Dim rge as Range

Currently I am automating some reporting. I pull data from a linked table
into a table within Access and then do some calculations and make some
modifications to the table using vba I have written.
I then have excel vba which pulls the data from the access table I have

Need some help on how to prompt the user for the input file (a CSV
file) & the macro will copy all the data in the input file into
another excel file summary & on worksheet named raw.
The input file is a CSV file with only 1 worksheet. I do not need to

I tried to use vbCr in the caption property of commandbutton is work but it
doesn't work in putting contents in a cell, what is the code to get the
result like pressing "Alt + Enter" in a cell?
Thanks

I have a macro that relies on a worksheet being present, however if the sheet
is missing I need to reply with a message box to tell the person to copy in
the worksheet
   If Worksheet ("data") = False Then

I was wondering if there is a function that give you the mouse position
because a have this one form I want to either double click a control on a
form and to position a frame control beside the mouse?
Any Reply would be greatly appriecated.

I want to set a range in different workbook, PayRollCarryOver, from the
currently active one. PayRollCarryOver is open but not active.
What is the proper syntax for the link to another workbook?
I tried this, but got an error:

Dear Friends,
First of all I thank all of you in advance for taking time to help
other people out :)
My Macro is a complex function involving Vlookups and a lot of

If I remove a Column:
  Columns ("B:B").Delete Shift:=xlToLeft,
I find that column IV (the last column in the spreadsheet) turns up with a
formatted cell (IV3) with a Border.Linestyle.

Hi I try this Q here instead since i was recommended this:
"Hi Kjell
There used to be a way to dynamically link Excel to databases, but I think
MS had to remove it due to some kind of lawsuit. Best would be to ask this in