txt file to hold code, that can be executed by vba? Txt file as dll kind of?

[redbull]

Hello,



I have created some class modules that basically store coordinates for different fields on a main frame emulator system. I'm wondering if its possible to store these class modules as txt or ini files and store them in a central location instead of putting them inside each terminal... If something changes on one of the screens, I would only have to change the coordinates in the text file instead of opening up dozens of separate systems to make the same change.





Class Module (txt/ini) Code Example:

Variable1 = GetDisplayText(16, 15, 1)  'This represents the coordinates I'd like the code to use to look for variable1. 
Variable2 = GetDisplayText(16, 30, 1)
Variable3 = GetDisplayText(16, 57, 3)
Variable4 = GetDisplayText(16, 72, 8)
etc, etc, etc

SO using textstream , I'm able to load the coordinates into the vba as a string, but I'm having a hell of a time figuring out how to run that in the vba itself. Normally when the vba runs

Variable2 = GetDisplayText(16, 30, 1)

Variable2 will become what ever is located at those coordinates, so far I'm only to get Variable2 to equal Variable2 = GetDisplayText(16, 30, 1)...



Any ideas? Tips?

[ranman256]

have a module that opens the txt file.

LoadTxtFile()
const kFILE as "c:\settings\coordinates.txt"
dim vLine

open kfile for input as #1
while not eof(1)
   line input #1, vLine
   'store data in table?
wend
close 1
end sub

then you only need to update the coordinates.txt file