View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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?

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