I have an application that generates spreadsheets. It is developed in
VB.NET 2003 and works well on XP with Excel 2003. Have tried to deploy
this on Windows Server 2000 with Excel 2000 only to get an error 'The
parameter is incorrect'.  This error occurs on the follwing line:

I need a simple macro to recalculate the worksheet  (not the entire
workbook) whenever any cell in the range B5:G5 is edited.
I'm assuming it's a simple combination of  Worksheet_Change and
ActiveSheet.Calculate

I have a macro that includes a custom sort of column A (and all of th
info in that row) in a specific (not alphabetical) order. All of th
calculations need to have the list of names in the proper order. Th
sorting works on my computer, but when I email the spreadsheet t

Does anyone have any suggestions for deleting an entire sheet in
workbook if Cell A1 in the Sheet is blank?
Thank
--

I have the following string:
"7D: test messages"
I would like to remove the value "7D: " from the string
How do I do this

does anybody know how can i convert access mdb into excel xls file
(mdb table into xls sheet)
is it possible at all?
i have almost 100 mdbs to convert (i'd like to do it in loop)

I need help with starting off a macro, and hope someone can help. I'll try
and briefly describe what I am trying to achieve. The w/s below represents a
very simple project progress track for weekly presentation purposes. Each
project will be represented by a single line entry. ...

I didnt see this post the 1st time I sent so sorry if this is a
duplicate.
I have the following string:
"7D: test comment"

I would like to copy an existing worksheet, which is hidden in an
add-in XLA and copy it to an
existing XLS file?
Can someone help?

When trying to debug some of my code in step mode I get to this particular
line and it just stops.
       ActiveWorkbook.Worksheets("StatusData").Select
       On Error Resume Next

i am missing something.  I have a function that takes in a multiselect
listbox and creates a one dimensional array populated with the indices
of the selected items.
Public function LB2Array() as integer

I have a macro which worked previously, however it seams to have som
sort of problem. but I can't figure out whats causing it.
Im getting this error: "Error 438 - Object doesn't support property o
method"

What I'm trying to do is access my outlook inbox and grab all unread
emails, received today, with subject containing "string here".
After grabbing I'm placing tab delimited data in Excel.
The above works fine almost (I'm unable to limit to just unread)

Code:
--------------------
   Private Sub CommandButton2_Click()
 Dim i As Integer

I would like to put the code below somewhere so that it will be activated
every time a worksheet is viewed or printed. I have tried putting it in a
module in my Private.xls workbook but since I don't call it in a procedure,
it doesn't work like I want. The only way it works is if I ...