Could you please let me know how to increase the number precision in Excel
workbook. I'm aware that the limit is 15,but unfortunately I have more than
16 number to type in a cell.
for eg: 1234567891234565 this number will turnout to be 1234567891234560

I get an excel file that may have more than the 65k line max in Excel03.
I was wondering if there was a utility or plugin that would allow me to
bring it into an array through vba so I can do all the calculations because
the finished file would fall within the limit.

Is it possible for a pivot table to e linked to two worksheets with
similar data in them.
Sheet length is 65536 till last cell. Is there a way to pick 65537th
record from next sheet in same pivot table? To be exact, first row of

Is it possible to have in one chart a stacked column and right next to it a
solid column?

I have a range withing a list, i wish to loop throught the range
without activating the cells and in each blank cell put todays date
in. I am using a do loop but I am struggling, possible need a for loop
but I am not to good on these, any advice much grateful

I have written a macro that opens IE to the following web page
http://adds.aviationweather.gov/metars/
I am able to select certain options and values using the "set ipf"
method.  However, I am unable to programmatically select either the

Greetings,
I have a function which returns an array of strings, I wish to fill my
combobox with this array by doing something like the following
cmbBoxList.addItem manager.GetStringArray

I can't find such an event (Office 2003). Is it possible with VBA to detect that
Excel is going to be closed?
My goal:
I want to prevent a workbook from being closed by the user as long as Excel is

I've been given some data that looks like this:
Name    Docs
Name1    doc1
Name1    doc3

I have the following scenario.  used to calculate the progress of a server
project.
Column C is the Division owning the hardware, several unique values repeated
as appropriate.  i.e. ABC, or XYZ

As we know, we can protect the whole VBA project. but if i want to protect
one or two modules in a VBA project. How to do so?
thanks!

i got a code from rons site to email a workbook as a attachment.  to mail it
the workbook got "send" to a temp file and then there is a kill comand
for one or other reason the sheet got cleared(got the code to do that) but
it did not email the workbook.   is there a way to "find" ...

I've written a function in an XLL which uses xlfGetFormula to return a cell's
formula. It's similar to the XLM =GET.FORMULA(), but works as an array
formula and can be called from the worksheet. My two key requirements are
that the function must be able to be used in an array ...

I am using macro code to generate multiple workbooks from data in one large
workbook.  After the individual workbooks are generated, they are each saved
with a unique file name.  
How can I change the code to have it save in .htm format?  The code I'm

WANT TO CONVERT A EXCEL FILE TO DBF FORMAT AND USE IT IN VISUAL FOXPRO. IN
OFFICE 2003 THEIR IS AN OPTION IN SAVE AS (*.dbf) but in office 2007 i cant
find it out. pls help.