| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call Sub
I'm trying to call a sub routine in another spreadsheet but I keep getting a
compile error "sub or function not defined." I have the following code: .... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If .... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call Sub
Bishop wrote:
I'm trying to call a sub routine in another spreadsheet but I keep getting a compile error "sub or function not defined." I have the following code: ... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If ... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? Is DirectorFormat declared as Private? If so, it cannot be called from outside the module it resides in. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call Sub
If you call from a different workbook, then you have to specify the Projectt
name (Workbook in Excel) and the module where the macro resides. "Bishop" wrote in message ... I'm trying to call a sub routine in another spreadsheet but I keep getting a compile error "sub or function not defined." I have the following code: ... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If ... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call Sub
That's a good question. I forgot to check for that. However, it is not
declared as private. "smartin" wrote: Bishop wrote: I'm trying to call a sub routine in another spreadsheet but I keep getting a compile error "sub or function not defined." I have the following code: ... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If ... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? Is DirectorFormat declared as Private? If so, it cannot be called from outside the module it resides in. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call Sub
And you don't have:
Option Private Module at the top of that module, right????? Bishop wrote: That's a good question. I forgot to check for that. However, it is not declared as private. "smartin" wrote: Bishop wrote: I'm trying to call a sub routine in another spreadsheet but I keep getting a compile error "sub or function not defined." I have the following code: ... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If ... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? Is DirectorFormat declared as Private? If so, it cannot be called from outside the module it resides in. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Call Sub
I find that application.run("module") works in all cases or if you want to
pass variables sdoit = application.run("module",var1,var2 etc) "Dave Peterson" wrote: And you don't have: Option Private Module at the top of that module, right????? Bishop wrote: That's a good question. I forgot to check for that. However, it is not declared as private. "smartin" wrote: Bishop wrote: I'm trying to call a sub routine in another spreadsheet but I keep getting a compile error "sub or function not defined." I have the following code: ... If Not mybook Is Nothing Then 'Need to do the following: 'if lazy eye hasn't been run in directorcopy then run it With mybook.Worksheets("DirectorCopy") If .Cells(1, 1) = "" Then Call DirectorFormat DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row 'Determine how many rows in directorcopy Else DCLastRow = .Range("A" & Rows.Count).End(xlUp).Row End If ... Call DirectorFormat is giving me the error. I've also tried Call DirectorCopyFormat.DirectorFormat (DirectorCopyFormat is the module Directorformat sits in) but that gives me the same error. What am I doing wrong? Is DirectorFormat declared as Private? If so, it cannot be called from outside the module it resides in. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to call a vb.net dll from VBA | Excel Programming | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| call sub | Excel Programming | |||
| How do you call one Sub from another Sub ? | Excel Programming | |||
| call sub | Excel Programming | |||
Linear Mode
