If I know my data won't exceed 7 or 8 thousand rows, should I use
this?
iEnd = ws.Cells(10000, 9).End(xlUp).Row
Rather than this?

How to preset password for editing for new files generated in excel

I have no experience in Excel VBA (except for modifying a few recorded
macros), but am faced with a very complicated data clean-up project
which will take forever unless I can automate it.
My original data looks like this:

Does anyone know which statement to use for changing a range of
positive numbers (say range("A1:A10") into negative?
Thanks again!
Rgds,

I have a list of hyperlinks  - to an unusual filetype. When the user clicks
on a link, a message box appears stating "unable to open file".
I want to set it up so that excel asks the user where to save the file,
rather than try to open it.

I'm somewhat new to VBA.  I currently have to loop through a sql
recordset, which I already am able to do.  I then do a search on
another workbook, looking through a sheet there to find certain things
that match my values from my recordset.

Newbie question:  I have a list of hours (see below) and want to round them
up to the nearest halftime in 15 minutes section.  Example:  12h37 would be
rounded to 12h30, 12h46 would be 13h00, 13h05 would be 13h00, 13h17 would be3
13h30 and so on...

Does anyone know of a quick way of working out how much data a row
contains?
I was hoping to be able to make an estimate of how big a workbook
could get.

this might be a stupid q to ask but...
I have created 6 macros that I run one after another to perform my task.
Istead of running them one after another I'd like a sub that calls one by one
(in the right order), insted of doing it myself. What would the code be?

I'd be most grateful for pointers in the right direction, on how to optimise
my Excel VBA program, that goes back and forth to an Access DB. At the
moment, I don't feel I've done enough with the instantiating and/or closing
of objects - particularly Connection, Catalog and ...

Is it possible to launch non-office applications such as IE or Windows
explorer through VBA, which has a similar effect as, running these
applications from the RUN prompt giving arguments such as URL or windows path
respectively.

I have a custom add in for work that adds another menu at the top of my
excel.  I want to write a macro that includes calling an item in that menu.  
When I record a macro and go to the item i need, it functions properly
(resets a bunch of dde links) but it doesn't record the code ...

I've been working with some database data which stores the date as an
integer (a different integer to that which Excel uses). To calculate the day,
month and year I do the following calculations:
   y = Fix(ActiveCell / 65536)

How to export data from SAP to Excel ?
OLE ? ABAK ?
VBA ?
others ?

Have to determine the number of days between two dates
exmple:  1/1/98   and   3/31/98 = #days
Thanks