Calling all Excel programming brains,
I am trying to move and rename a file but don't know where to start,
can anybody help?
Thanks,

Hi Friends,
    I am making a C# application that will create reports in Excel from a
database. My report involves creating many worksheets. Is there any
limitation for maximum worksheets in a workbook. As per Microsoft the number

I haven't a bit of problem displaying a blank cell in D15 as empty when
the others cells are empty. The value that display is ######.
Anyone there that can help me!
Here is the formula: -

I have a line on the screen (shape).  I would like to select it and get the
starting and ending  coordinates of the line.  TIA, James

When this code is in the worksheet change event, it restricts the
function of other code in worksheet change. Why?  Is it about the
placement of the Exit Sub?  All this code does is carries formulas in
columns 3 and 10 down to new rows when inserted manually.

Can anyone tell me how to change the value of a cell in say column "B" based
on the value in a cell in column "A" when the value in column "A" is
alphanumeric? I am already able to make this code work when the value in
column "A" is numeric only, but the code does not have any ...

This will be easy for you experts out there.
On a UserForm  I have a Check Box that when I click on it I want it to add a
value of £1 to a Cell on a particular worksheet see code below.
Private Sub Add2_Click()

I have made some code that can take som data from a .NET dataset and put it
into an excell sheet. This works perfectly when i have e.g. 1000 rows of
information. My problem is that based on som meta data, i create a four
column and 24000+ row data for an excel range. when i try ...

I'm using the following code for updating a chart on an existing
worksheet.  The chart contains data covering a period of 13 months
(Jan-Jan) and the code prior to this adds an extra month's worth of
data to the source.  What I need is for the update process to drop one

I am working with large sets of data there are extracted and created by
SAS. Is it possible to call the sas-procedure directly from VBA? If so,
a few hints would be appreciated very much.
Thank you in advance.

To Whomever Knows the Answer:
I wrote a small program that goes out to the internet and looks up the
historical prices over a 10 year period from Yahoo! Finance
(www.finance.yahoo.com).  The data can be found on the following URL:

Using Excel 2000, I am building a UserForm with several textbox where
the user needs to input some data.
Basically, I want to prompt the user using MsgBox on invalid inputs and
put the focus back to the textbox.

I code to an FDF file and then when i try and print/open that using the
path including the .fdf file, it just hangs.  However, when i just go
manually through and open the fdf file and then print, it works fine
Any suggestions?

I am trying to use Excel to open a PDF, add an annotation ("Stamp") and save
the document. I am not sure how to use PDPage and Addanot. Please help.
Thanks.

Below is my constant and the code that uses it.  This works great as it is.
Const ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\Projects\MyDatabase.mdb;Persist Security Info=False"
Dim Recordset As ADODB.Recordset