I want to run automated macro in two workbooks. I means I have two workbooks
one centain macro and another one does not for now.
For the second one, I want to write VBA to call the Macro function from the
first one. I don't know what should I start now.

I need to set up a formula that allows the following:
79 or less = 0
80=80
81=81

Can I open a spreadsheet that was saved as a 2007 excel document(xlsx)  using
excel 2003?  I did not save the document as a 2003 spreadsheet.
Thank you

I have an Excel workbook that contains about 75+ worksheets.  I need to print
each worksheet in the entire workbook, but each worksheet does not have the
same print area for the data we need to print - and due to the nature of the
data, we CANNOT change it so that the data will ...

Dave can you check my last post.  I checked through all the posts and it is
still not answered.  thanks,

I used the suggested function =IF(ISNA(C81),"0",C81) which worked fine.  
However, the following formulas resulted in an answer of "0" which was
incorrect.  The last formula did not recognize that a value was greater than
zero.

I am inserting check boxes on a form that I have created. Only problem is
that they are a bit small. Any suggestions on how to make the check box
larger. I've tried in the properties and it doesn't work.

I thought Excel 2007 had 1 Million row capacity.  but I can only import 65K.  
Does anyone know why the difference?

Excel cut and paste row takes a long time. Lots of formulas across many
columns. Auto Calculation turned off. Even a blank row insert takes forever
(15 seconds or more).
Any idea how I can speed this up?

I'm trying to open a worksheet depending on the month that the data is for.  
For example, If I am looking at Jan Balance sheet on my first tab, I'd like
to pull the Jan Trial balance from a file.  I have written a VLookup so that
the proper path/filename is displayed.  How do I ...

Please can you tell me (in simple format) how you capitalize multiple cells?
Cheers

I have the first row of a spreadsheet 'Conditionally Formatted' just the way
I want it.  Cells A1 through N1 are highlighted when I enter a date greater
than 01/01/2007 in the M5 cell.  I entered '=$M$5>01/01/2007' for the
'Formula Is' window and it works fine for that row.

Would like to have statement read, Expenses are [A]% of total income. [A] is
calculated in formula as follows: ="Expenses are "
&(ROUND((N253*100)/N65,2))---How do I complete this to include "% of total
income" Appreciate the help. Thanks! CJ

I get an error message 438 if I use the 2nd intLastRow line, I get a type
mismatch 13 if I use the 1st intLastJRow line.   In either case it doesnt'
compile.  I was thinking it was something wrong with the setting of the ws
variable but I dont' know which intlastrow it should be. ...

Can anyone recommend an ocr program to convert a scanned image with columns
of number to excel?  I downloaded a trial copy of Iris but the results were
not good.  Would I perhaps be better off going to text and then importing
into excel?  Scanned image can be either pdf or tiff.