Help with Calling a Module within a Module

[John]

Simple problem, but I'm confused, I'm trying to call a module "TextToData"
within the following code, but its coming up with a compile error. My code
(I thought would work) is. Info on how to fix would be great (I know the
individual parts work)

Sub GenerateReport()


Sheets("Sales Mix").Select
Cells.Select
Selection.ClearContents
Range("A1").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Range("A1").Select
Application.ScreenUpdating = False

With Application
.Calculation = xlManual
.MaxChange = 0.001
End With

Sheets("Sales Mix").Select
Range("A1").Select

TextToData

Sheets("Report").Select
Range("A1").Select

End Sub

 

[David McRitchie]

Hi John,
Subroutines are within modules so you don't call a module.
What you have is okay if the macro is in the same workbook
as you are running from; otherwise, you might take a look at
http://www.mvps.org/dmcritchie/excel/install.htm#another

Application.Run "personal.xls!TextToData"

 

[John]

Thanks David

Was still confused as the module "TextToData" was in the same workbook as
"GenerateReport" , but in a different module. So I just copied it into the
same Module as "GenerateReport" and hey presto, it worked. Maybe I just
don't have the proper lingo

Thanks