Refrencing or Returning Data in a Macro From a Macro

L

lj

I've run accross a problem where I would like to be able to refrence
data i've named in a macro that i'm running within a macro either by
having the macro output into the second macro or refrence a name in a
macro, is this possible?

Sub Macro1()


book = Range("B10")
booknum = 1
Path = Range("B11")
Sheets("data").Select
If Range("A52") <> "" Then
Application.Run "JEUpload_Template.xls!CreateSheet"
Range("A1:L1") = Heading
Range("A2:L51") = Sheet02
Sheets("Sheet2").Select
Sheets("Sheet2").Move

ChDir Path
ActiveWorkbook.SaveAs Filename:= _
book & booknum, FileFormat:=xlText, _
CreateBackup:=False
ActiveWorkbook.Save
ActiveWindow.Close
booknum = booknum + 1
End If

End Sub
 
Top