How to Attach Module with Excel
Closed
Soail_3236
-
16 Apr 2010 à 03:37
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 16 Apr 2010 à 06:10
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 16 Apr 2010 à 06:10
Related:
- How to Attach Module with Excel
- Excel mod apk for pc - Download - Spreadsheets
- Gmail cannot attach files - Guide
- Excel vba send email with attachment - Guide
- How to change date format in excel - Guide
- How to copy data from one excel sheet to another - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
16 Apr 2010 à 06:10
16 Apr 2010 à 06:10
I think you cannot activate a"module" ony activate one or more macros in the module
if you want to activate a module when you open the workbook
open vb editor (alt+F11)
hit control+R
on the left side the project window opens
go to your file whose name is there
in the list of projects under your file there is a term "thisworkbook"
right click this term and click view code
right hand side blank window opens
in this window there are two small windows on left and right
on the left side click that small arrow and choose "workbook"
automatically these statements will appear
the macro need not be in this window but should be available in the module of that particular file.
so when you open the file automatically that macro will run.
if you want to activate a module when you open the workbook
open vb editor (alt+F11)
hit control+R
on the left side the project window opens
go to your file whose name is there
in the list of projects under your file there is a term "thisworkbook"
right click this term and click view code
right hand side blank window opens
in this window there are two small windows on left and right
on the left side click that small arrow and choose "workbook"
automatically these statements will appear
Private Sub Workbook_Open() <here type the name of the macro> End Sub
the macro need not be in this window but should be available in the module of that particular file.
so when you open the file automatically that macro will run.
