Results 1 to 2 of 2

Thread: Recompile VBA

  1. #1
    Join Date
    Nov 2004
    Posts
    1

    Unanswered: Recompile VBA

    I am having a problem with an application that I developed in Excel. I find that to fix the problem with the application, I need to recompile the VBA on a case by case basis. My questions is, does anyone know how to use vba code to force the application to recompile everytime it is opened?

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    This is possibly doable but there are a couple of things id like to ask,
    Whats your code doing (is it possible to post some up so we can have a look at it) we might be able to come up with a better way of solving your problem, i.e. error handling OOP etc
    What is difference between the cases that you need to recompile, this doesn't sound like a good idea

Posting Permissions

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