Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Using VBA to Create VBA Code on the fly

  1. #1
    Join Date
    4th February 2004
    Posts
    44

    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


    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    6th May 2005
    Posts
    1,036

    Re: Using VBA to Create VBA Code on the fly

    Hi

    See if This link

    will get you going.


    Tony

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    4th February 2004
    Posts
    44

    Re: Using VBA to Create VBA Code on the fly

    Thanks heaps Tony.

    THis is exactly what I was looking for.

    You Rock!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Create Macro Code With VBA Code
    By moccamixer in forum EXCEL HELP
    Replies: 3
    Last Post: February 23rd, 2008, 07:38
  2. Create Histogram Code
    By Andy Hennig in forum EXCEL HELP
    Replies: 1
    Last Post: July 11th, 2007, 11:51
  3. Create New File & Name via Macro Code
    By Red_Adam in forum EXCEL HELP
    Replies: 3
    Last Post: September 3rd, 2006, 14:53
  4. Using Code to Create the Value of the Primary Key
    By mastermind82 in forum Excel and/or Access Help
    Replies: 2
    Last Post: June 28th, 2006, 00:35
  5. Create new inputbox in my code
    By Turbothorup in forum EXCEL HELP
    Replies: 4
    Last Post: July 13th, 2004, 01:31

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
  •  
porno