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:===
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