Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
How to call a module and sub in other file by VBA

1) As we know we can create function and sub on Excel Sheet and
Excel module from popup VBA Excel editor by Alt-11 key. The question is
what is dfferent between the code we create on the sheet and module ?
2) When I call the module named Smain in other Exce VBAl file, I can't
call it, why ? What is syntax for that.
3) OR I need to include Smain of Chart.xls as the library in myexample.xls
Please advise
Duncan
'myexample.xls
Sub main()
Workbooks.Open Filename:= _
"d:chart.xls"
Call Workbooks("chart.xls").Module1.Smain
End Sub
---------------
'Chart.xls file
Option Explicit
Public sub Smain()
'Code
End Sub
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email
Sharing is important & Sharing make the world better
and thanks all of you to reply this email