View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Köster Daniel Köster is offline
external usenet poster
 
Posts: 4
Default Read variables from external file

Hello again averyone,

How do I kame a macro read some of its variables from an external file? The
thing is that I need the user to be able to change some basic values in the
macro, like pathnames and stuff.

I would like to have a txt file with the contents:
variable1 = "c:\work\myfile.xls"
variable2 ="yes"
variable3 = "1978"
and then let the macro get the varibles and there value from that file.

I know how to do it in Macromedia flash.. :-)

--
--------------------------------------------------------
Daniel Köster
TEKNOTRANS AB
Redegatan 13
426 77 Västra Frölunda
Sweden
Tel: +46 31 69 47 60
Fax: +46 31 69 47 65
E-mail:
http://www.teknotrans.com