Announcement

Collapse
No announcement yet.

Using VBA to Create VBA Code on the fly

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Using VBA to Create VBA Code on the fly

    Hi ,

    I've seen this method used but I'm not sure of how to go about it.

    I have a vba module that reads a value from a txt file and saves that value in a variable called "iniInfo". I want to permanently assign that value programatically by using VBA code to create a Public variable e.g. "PUBLIC CONST conFIg = iniInfo" in my modGlobalVar Module.

    (Of course, this would only create the code if the "conFig" variable doesn't already exist.)


    Any help appreciated



  • #2
    Re: Using VBA to Create VBA Code on the fly

    Hi

    See if This link

    will get you going.


    Tony

    Comment


    • #3
      Re: Using VBA to Create VBA Code on the fly

      Thanks heaps Tony.

      THis is exactly what I was looking for.

      You Rock!

      Comment

      Working...
      X