Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run it
in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help

Public Sub dothehokiepokie()
Dim wb As Workbook
Dim ws1 As Worksheet
Dim ws2 As Worksheet

Set wb = ThisWorkbook
Set ws1 = wb.Sheets("Sheet1")
Set ws2 = wb.Sheets("Sheet2")

ws1.Cells(1, 1).Value = "Test123"
ws2.Cells(1, 1).Value = "Test123"
End Sub



"zoot" schreef in bericht
news:fZ8vg.208562$Mn5.66816@pd7tw3no...
Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run it
in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help

Thank you!! but how would you call a procedure from that workbook?

"moon" wrote in message
. ..

Public Sub dothehokiepokie()
Dim wb As Workbook
Dim ws1 As Worksheet
Dim ws2 As Worksheet

Set wb = ThisWorkbook
Set ws1 = wb.Sheets("Sheet1")
Set ws2 = wb.Sheets("Sheet2")

ws1.Cells(1, 1).Value = "Test123"
ws2.Cells(1, 1).Value = "Test123"
End Sub



"zoot" schreef in bericht
news:fZ8vg.208562$Mn5.66816@pd7tw3no...
Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run
it in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help

If the macro MyMacro is in Module1 of a workbook named Book1.xls then from
another workbook you could do

Application.Run "Book1.xls!MyMacro"

someone else showed you how to reference cells in the other workbook.

--
Regards,
Tom Ogilvy


"zoot" wrote:

Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run it
in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help

Thank you!!!!!

"Tom Ogilvy" wrote in message
...
If the macro MyMacro is in Module1 of a workbook named Book1.xls then from
another workbook you could do

Application.Run "Book1.xls!MyMacro"

someone else showed you how to reference cells in the other workbook.

--
Regards,
Tom Ogilvy


"zoot" wrote:

Can anyone tell me if this is possible and if so the procedure to code.

I have 2 workbooks. I want to call a procedure from workbook 1 and run
it
in workbook 2.

As well I want to make reference to certain cells in the 1st workbook is
this possible?

thanks for your help