Read variables from external file

[Daniel Köster]

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: (e-mail address removed)
http://www.teknotrans.com

 

[Tom Ogilvy]

Basically you question is how do I read a textfile. There is no built in
support for writing variable values to a text file, but you can write
information to a text file, then read it in an assign the values to
variables.

http://support.microsoft.com/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications

 

[Daniel Köster]

Hi Tom, Thanks for the reply!

I´ll try that, should work fine!

Best Regards
Daniel