External Variable Declaration
 

I have a .txt file in which I have 3 variable declarations. I want t
be able to read this file and integrate it as part of my code. Th
variables will be in the program as global variables and they ma
change (the txt file may change). How can I do this? :rolleyes:

I was trying to do it through CodeModule... but for this I was deletin
every time and I could only insert full subs, but I only want to replac
the variables that are declared with what is on the txt file

--
ehnt
-----------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...fo&userid=1586
View this thread: http://www.excelforum.com/showthread.php?threadid=27355

External Variable Declaration
 

Hi
have a look at:
http://cpearson.com/excel/vbe.htm

"ehntd" wrote:


I have a .txt file in which I have 3 variable declarations. I want to
be able to read this file and integrate it as part of my code. The
variables will be in the program as global variables and they may
change (the txt file may change). How can I do this? :rolleyes:

I was trying to do it through CodeModule... but for this I was deleting
every time and I could only insert full subs, but I only want to replace
the variables that are declared with what is on the txt file.


--
ehntd
------------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...o&userid=15865
View this thread: http://www.excelforum.com/showthread...hreadid=273553