?
Solved

Excel Worksheets

Posted on 1998-10-03
7
Medium Priority
?
372 Views
Last Modified: 2010-04-30
I created a security system on an excel worksheet.
I protected the worksheet VBA modules with a password.
I then changed the security system.
I now have to go and update every single worksheet to work with the new system.

The security system was a macro in Excel.
Is it possible to , with VB, edit Excel Modules through a program?

eg: change the actual source code in the Excel macro through and external Visual Basic Program?
0
Comment
Question by:bobbyo
  • 4
  • 3
7 Comments
 
LVL 2

Accepted Solution

by:
PedroMVGomes earned 200 total points
ID: 1437935
Yes it is possible, in you references menu add a reference for E xcel 8 (File Excel8.Olb) and voila, you have access to do almost anything in Excel.

You get the application object, the module and colection the workbook object and colection, the worksheet object and colection and a lot more.

You can Open a existing workbook change it and then save it
0
 
LVL 1

Author Comment

by:bobbyo
ID: 1437936
It is not satisfactory, just need a little more information.

Can you change the Module code in the macros this way?
0
 
LVL 2

Expert Comment

by:PedroMVGomes
ID: 1437937
yes, the module object exposes everything you need, you can even run a macro, or change the format of a particular cell in a particular worksheet
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:bobbyo
ID: 1437938
How will I edit the code in the Excel Macro?
0
 
LVL 1

Author Comment

by:bobbyo
ID: 1437939
Sorry, how will I edit the code in the Excel Macro, through a Visual Basic Program?
0
 
LVL 2

Expert Comment

by:PedroMVGomes
ID: 1437940
Send me your e-mail and i will send you a sample project with a simple macro in a excel file.
0
 
LVL 1

Author Comment

by:bobbyo
ID: 1437941
mota@icon.co.za
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question