2003 how to automatically load macro-CodePudding

How to set up open the.xls files can run macros, such as open test. XLS is executed, other XLS is best not to load the macro, baidu said item added to the load is useless, really not line, excel or WPS pro can also,

CodePudding user response:

In the test. Can be added in the XLS workbook_open,

CodePudding user response:

Whether to use the macro, it is by the user in the menu: set of tools, macro, security,
Is not controlled by the developer,

CodePudding user response:

reference 1st floor Topc008 response:

in the test. Can be added in the XLS workbook_open,

Thank you very much, this is what I need, this question has bothered me for a long time, by the way, if it is every.xls files open to perform again how to do

CodePudding user response:

The original poster is to make macro viruses?

CodePudding user response:

references a drink, 4/f, the bright moon response:

the original poster is to make macro viruses?

If I can own learning vba macro viruses, will not come here to ask

CodePudding user response:

reference 5 floor weixin_29832331 reply:

Quote: refer to 4th floor a toast to invite the bright moon response:
the original poster is to make macro viruses?

If I can own learning vba macro viruses, will not come here to ask

From your "needs", feel is obviously is a kind of "virus",
Whether this whether to ask here, self-study VBA pull not top relation,

I had about 10 years ago, I met a Excel macro viruses, should be as part of the worm,
After infection, regardless of the new form, or open a form document, it of the virus code, write a lot of garbage data,
Needless to say, the virus code, open the VBE varies can see, there is a module is the virus code inside,
Garbage data, of course, is not within the "form", but "attributes" in the file, click the "custom" TAB, you can see about 30 to 50 items data,
It can infect all new and open the document, that the new document, open the document, it can be activated,
And is "event" activated, because at that time, the company of those who are vintage computer (level is roughly 586 CPU, 16 m or 32 m memory, installation of small subsidiary),
Configuration is very low, does not feel "abnormal card", if you don't use event mechanism, it should be "runs", infected post-processing form must Calder clearly,
IT is only infections. XLS document, because my colleagues in several computer manually remove IT (corporate IT rising antivirus installed on the computer cannot detect),
And then to "defensive measures", can let the computer will not be infected and spread the macro viruses, Office97 at that time, 2000, a generation of low security,
Said the building Lord on the third floor of the "every.xls files open to perform again", this code can be done, of course, (of course have to allow macros),
This virus samples, still in my own computer,
But you also don't ask me to the sample, I don't remember clearly the code it looks now, also won't send this sample to others casually,

CodePudding user response:

refer to 6th floor a toast to invite the bright moon response:

Quote: refer to the fifth floor weixin_29832331 reply:

Quote: 4 reference building a toast to invite the bright moon response:
the original poster is to make macro viruses?

If I can own learning vba macro viruses, will not come here to ask

From your "needs", feel is obviously is a kind of "virus",
Whether this whether to ask here, self-study VBA pull not top relation,

I had about 10 years ago, I met a Excel macro viruses, should be as part of the worm,
After infection, regardless of the new form, or open a form document, it of the virus code, write a lot of garbage data,
Needless to say, the virus code, open the VBE varies can see, there is a module is the virus code inside,
Garbage data, of course, is not within the "form", but "attributes" in the file, click the "custom" TAB, you can see about 30 to 50 items data,
It can infect all new and open the document, that the new document, open the document, it can be activated,
And is "event" activated, because at that time, the company of those who are vintage computer (level is roughly 586 CPU, 16 m or 32 m memory, installation of small subsidiary),
Configuration is very low, does not feel "abnormal card", if you don't use event mechanism, it should be "runs", infected post-processing form must Calder clearly,
IT is only infections. XLS document, because my colleagues in several computer manually remove IT (corporate IT rising antivirus installed on the computer cannot detect),
And then to "defensive measures", can let the computer will not be infected and spread the macro viruses, Office97 at that time, 2000, a generation of low security,
Said the building Lord on the third floor of the "every.xls files open to perform again", this code can be done, of course, (of course have to allow macros),
This virus samples, still in my own computer,
But you also don't ask me to the sample, I don't remember clearly the code it looks now, also won't send this sample to others casually,

, of course, these are all under the condition of allowing macro, each manual add-ins more troublesome, and I can't open the excel macro execution before running the program!

CodePudding user response:

http://www.autohotkey.com

CodePudding user response:

This is not something mysterious
It is not necessary to hiding anything
I'll tell the original poster
C: \ Program Files \ Microsoft Office \ OFFICE11 \ XLSTART
Put a excel files in this folder, each time you open the excel automatically open the excel file
And then put it in a file, the file insert class module, named clsApp; And in the following code:
Public WithEvents App As Application
Private Sub app_workbookOpen (ByVal Wb As Excel. The Workbook)
'define the App for the application object, monitor worksheet open event
Call you to run the module
End Sub
Each open the XLS file can be run your macros.

CodePudding user response:

references 9 f aspower_ response:

this is not something mysterious
It is not necessary to hiding anything
I'll tell the original poster
C: \ Program Files \ Microsoft Office \ OFFICE11 \ XLSTART
Put a excel files in this folder, each time you open the excel automatically open the excel file
And then put it in a file, the file insert class module, named clsApp; And in the following code:
Public WithEvents App As Application
Private Sub app_workbookOpen (ByVal Wb As Excel. The Workbook)
'define the App for the application object, monitor worksheet open event
Call you to run the module
End Sub
Each open the.xls files can be run your macros.

Later I saw the vba tutorial is really like what you said

CodePudding user response:

references to the tenth floor weixin_29832331 response:

Quote: references 9 f aspower_ response:
this is not something mysterious
It is not necessary to hiding anything
I'll tell the original poster
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull