Does anyone know of a good crystal reports newsgroup? I tried Google and did
not find anything.
Thanks!

I have a problem and it is based on not udnerstanding why a Combobox_change
event fires when a workbooks is saved.
I have activex combobox on a sheet, when this box changes other actions fire
based on the selection from the control.  One of these is to clear ranges in

I thought Excel 2007 had built-in access to work with SQL Server and to write
C# code, but I guess not.
I'm trying to send data from my Excel 2007 worksheet to SQL Server 2000 or
2005 and I'm not able to get it to work correctly.

I have the following macro set up to take data from a large worksheet, and
copy the data to a smaller worksheet "template".  The first column of the
large worksheet is employee number; all rows with the same employee number
are copied to the template, then the template is resaved ...

There are two issues I am facing in my code
Issue 1.
The scenario is
From C# code I am opening excel 2007 workbook as database.

I have a simple worksheet with only two columns like this:
 A         B
1970   125
1971   136

Is it possible?
For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron
Ohio 21657."  Now if I begin typing "ABC" in Sheet 2

Good day, thanks for your comments and replies!
I've created a large-scale application with Excel VBA and I would like
to keep track of who uses the program. Because there is always the
possibility that someone made a copy of the file and is working off of

I have created an excell sheet and included all my report done in 2006 and
2007. Each project have their own hyperlink.
The problem I have now is that I burn this excell sheet on my CD. To make my
hyperlink work I needed to change the hyperlink.

Is there a way to protect view code (I mean users cannot right click and view
code?)

Oh Wise Ones,
                         I jump back in forth between several workbooks
throughout the day. Almost all of them I need the Enter key to move to the
right when pressed. I know how to manually set the direction, but for the few

I'm trying to get the complete path to the .XLS my VBA code is running
in.
Actually, I just need the directory.... but either would do.
So far, all I'm able to get is the application's directory (where

First, I apologize if this is the wrong group, but it seemed "close".  NB
I'm calling this code from VBA in access, but you'll note there are no
access components (directly) involved, which leads me to believe it's more
likely an excel (or maybe VBA) "problem".

Running XP pro & Excel 2007
I was running this bit of code this morning to launch a shortcut on
the desktop, and everything was working fine.  While experimenting
with variations things went into "lala land", and now I can't get it

Novice
Excel 2003
My additions to a "ImportBigFile" macro by C. Pearson is working nicely
thanks to several here - thanks.  Found I have a wee bit of a problem though