i have another question for you!
I implement a form in a dll, made with VB6, and i use the DLL in an
excel workbook, now i want to make the dll form the same as a userform,
i try with setwindowpos and setparent but it doesn't work, i have the

Suppose I have to subroutines, ProcParent and ProcChild. ProcParent calls
ProcChild. For some reasons, I don't want the control to be passed back to
ProcParent after Executing ProcChild. I have searched through the VBA help
and I found that both END statement and STOP statement ...

All = firstpart + SECONDPART + thirdpart + ".xls"
MsgBox "File about to be saved under name of C:\My Documents " + All
ActiveWorkbook.SaveAs FileName:=All, FileFormat:=xlExcel4
Using this code, a user logs into their own desktop computer and tries to

How do I simulate pressing the keys using a macro in Excel. For
example, if I want to simulate pressing the keys Alt+H+A, what should I
do in the macro?
Thanks.

The code below has a for next loop in it
how can I find out the "position" , ie is it the first time through the
loop, the last or the "n" th time through the loop.
I would be most gratefull if someone could enlighten me

I am using underneath sub to loop through files in a directory ...
I would like to run a macro on every workbook :"'Sige.xls'!Macro2"
And then save the changes on each workbook ...this last part does not
work ...

Is that possible? Please advise.
Frederick Chow
Hong Kong

I need to activate a workbook through a cell reference. the workook
name is stored in cell A1 as "pnlreport_060321.xls". This name
automatically changes daily based on the date. This is how I wrote the
code to activate the workbook:

thecells.Row will give me the current row
But, is there a name for the index in the array?
I would be most gratefull if someone could enlighten me
Thanks in advance

I'm having problems calling the Excel Price (bond) function within VBA.
I'm trying to build a manual yield function that needs to call excel'
PRICE function. But i get #VALUE
Application.Price(...) does not work.

Hi, Using a static array, with 100 values. is it possible to average
the last 20 values, and if i add another 20 values, to average agian.
In other words always averge the last 20 values.
Regards Robert

I have the following instructions to call a DLL from Visual Basic. I don't
know how to do this and wondered if someone could assist me or explain to me
in layman's terms how to accomplish it.
Thanks,

Suppose I have Range D10 as pivot. Is it possible to resize to E5:H10
The logical *Range("D10").Resize(-3,-5)* fails. Can the rowsize
columnsize arguments be made to take on negative values?
Myles

Data1 are the sheets to be copied from different files.
Combine sheet is the master sheet, where the data in data1 sheets are to be
copied.
I get an error "subscript out of range" ?? correct the following code please.

I run update macro loop to process about 50 spreadsheets, but sheets could
be used (open) by somebody. I need to skip processing of the sheet if it is
open. Something like this:
For R = 1 to 50