Simple Questions
 

Is it possible to write a routine in certain programming language and
direct excell to run the routine and then place the result into a cell
in EXCEL?

Thanks

James

Simple Questions
 

James,

Is the routine to be in the Excel workbook. If so, it is as simple as

'your code here to calculate a variable myResult
Range("A1").Value = myResult

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"James" wrote in message
...
Is it possible to write a routine in certain programming language and
direct excell to run the routine and then place the result into a cell
in EXCEL?

Thanks

James

Simple Questions
 

Actually I


I don't have any trouble calculating single variables,

A typical routine that I write would be a loop that given 10 numbers
in sequence, if the most recent value is = 7 of the ten preceeding
numbers then the routine would return a value of 7 or if = 4 of the
preceeding numbers would return a balueb of 4 and so on.

Right now what I have to do is save a column of numbers as a text
file, then run the text file though a qbasic routine and then paste
the results back into EXCEL. This works but it is time consuming.

I have never graduated out of qbasic because it has always been
adequete for the simple things I do with it.

James

"Bob Phillips" wrote in
:

James,

Is the routine to be in the Excel workbook. If so, it is as simple
as

'your code here to calculate a variable myResult
Range("A1").Value = myResult

Simple Questions
 

You can use VBA in Excel to do this. In Excel, do Alt+F11 to get to the VBA
editor. In the Project window, make sure you workbook is selected (or
select it). then do Insert=Module

paste in code like this:

Sub Updatecount()
If Selection.Columns.Count 1 Then Exit Sub
icnt = 0
For i = 1 To Selection.Count - 1
If Selection(i) <= Selection( _
Selection.Count) Then _
icnt = icnt + 1
Next
Selection(Selection.Count, 2).Value = icnt
End Sub


Do Alt+F11 to go back to Excel.

Select 10 contiguous cells in a column with the column to the right blank.

do Tools=Macro=Macors and select Updatecount. Then hit run.

You should be able to do most things that you have done in qbasic, right in
Excel.

--
Regards,
Tom Ogilvy

James wrote in message
...
Actually I


I don't have any trouble calculating single variables,

A typical routine that I write would be a loop that given 10 numbers
in sequence, if the most recent value is = 7 of the ten preceeding
numbers then the routine would return a value of 7 or if = 4 of the
preceeding numbers would return a balueb of 4 and so on.

Right now what I have to do is save a column of numbers as a text
file, then run the text file though a qbasic routine and then paste
the results back into EXCEL. This works but it is time consuming.

I have never graduated out of qbasic because it has always been
adequete for the simple things I do with it.

James

"Bob Phillips" wrote in
:

James,

Is the routine to be in the Excel workbook. If so, it is as simple
as

'your code here to calculate a variable myResult
Range("A1").Value = myResult