Does anyone know which key in the Registry key holds the references for
DLL's and TLB's?
I'm still trying to repair a broken Reference and cannot get rid of it. It
will not accept a "Check" and gives "Error in loading  DLL" message.

in excel 2007 if macro name contains number (e.g. "sub gel06(value)") macro
does not work, why.
And in Text to Colums decimal and thousands seperator isn't converted to
excel seperators altough needed adjustments is made, why.

As a total noob, working from MS Access VBA,
I find myself doing a lot of this:
-------------------------------------------
2010 With theWS

I'm fairly new to this so please go easy :-)
I've created a report using excel pivot tables which connect to a CSV
file, I have automated the updating of the tables via VBA and
everything works as expected here in the UK.  I transfered this report

with following code i'm splitting up text into rows.
The textpassages aren't longer than ColWidth.
'-------------------------------------------------------
Sub Tool_Hyphenation(TextSplit As String, EndRange As Range, ColWidth As

What I found so far did not answer my question.
On 2 pc's with "similar" regional setting (we tried to get), a query return
only one column or all
depending if the delimiter is a comma (,) or semi-colon(;)

I have recently begun learning programming in Excel after coming from a
Matlab background. I find myself constantly running into syntax errors
and other 'Bill Gates effects'. For example I use the macro recorder to
produce the following simple proceedure...

Can Excel count the number of times a file has been opened and place
the count in cell A1?  I thought I had a solution when someone
suggested the following response, but I couldn't get it to execute.
Does anyone else have any suggestions?  Thanks.  Michael

I have a VBA in Excel. It runs successfully on a stand alone PC,
reading files, directories, etc on the network.
We recently put it on the webserver, and created a link on a webpage.
The .xls file loads and the program runs fine (it does start slow). I

I want to print  a serial number on previously printed gift cards. The gift
cards are printed 2-up on 8.5x11 stock. I thought I could create a 50 sheet
workbook and print 100 cards at a time by printing the workbook, using my
card stock in my printer tray. Am wondering if there ...

I have an existing Excel spreadsheet that has a calculation I need to
replicate in javascript. I am having problems figuring out how to
replicate the results returned by the PMT calculation. I have the
following on the first line of a spreadsheet...

I create a Excel workbook from a c# application and insert a handful
of images on different worksheets.
 When I open the file in Excel I can't select/move the images.
 What's a bit odd is that I've saved many spreadsheets during

Rather than cut and paste rows, if there a way to select a range of
cells and just move them up or down a set number of rows? (I say a
range of cells, because on some sheets each record may contain more
than one row of data) The Pseudo code below gives an idea of the

~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Private Sub ComboBox1_Change()
End Sub
Private Sub CommandButton1_Click()

I have a sheet(1 )on which I want to check the postal code as soon as
the user enters the code. then on sheet(4) I have several formulas in
several cells to remove space and "-" and so on (last check is in A4)
then I have another formula in B5 to check if A4 is correct (returns