visual basic
Results 1 to 3 of 3

Thread: visual basic

  1. June 22nd, 2001, 08:51 AM #1
    Arthur Keith
    Arthur Keith is offline
    Junior Member
    Join Date
    Jun 2001
    Location
    El Monte, CA
    Posts
    2

    Question visual basic

    How does a macro created in visual basic , become part of spreadsheet in xls? And, what process is used to remove it ? I have this problem when opening 1 excel work book there is a macro that has attached it-self to the work book , I click enable or disable and same result IPF in module Excel.Exe ...Help [email protected]
    Reply With Quote Reply With Quote
  2. June 22nd, 2001, 08:59 AM #2
    antonye
    antonye is offline
    Registered User
    Join Date
    Jan 1999
    Location
    London, Great Britain
    Posts
    300

    Lightbulb

    The Microsoft Office suit (Word/Excel etc) use VBA (Visual Basic for Add-ins) which is a macro-programming language rather than the full blown VB language.

    To add/edit/remove the macros in Excel, you simply need to go to Tools -> Macro -> Visual Basic Editor or press ALT+F11.

    If you're having problems with a spreadsheet not opening, it sounds like that particular sheet is corrupt, rather than it being a problem with the VBA macros.

    Try a different Excel file that has a macro in it or try creating/recording a macro yourself and saving it to prove if you can open other files with macros.
    I'd rather die peacefully in my sleep like my Grandfather,
    than screaming in terror like his passengers.     Jim Harkins
    <a href="http://www.Horrible.Demon.co.uk/" target="_blank">http://www.Horrible.Demon.co.uk/</a>
    Reply With Quote Reply With Quote
  3. June 22nd, 2001, 09:03 AM #3
    Arthur Keith
    Arthur Keith is offline
    Junior Member
    Join Date
    Jun 2001
    Location
    El Monte, CA
    Posts
    2

    Post

    Thanx , on my way to try it now! I really want to get good at this programming stuff, and excel, and etc... But thanx .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules