Write data to a file

I would like to be able to enter data to a counter in a VB macro so that every time I run the macro it updates the counter. This is useful for changing the background color each time the macro runs to distinguish data. I know it can be done by enter a value in the excel spreadsheet, but I'd like to somehow pass this data to a file that could be accessed by any of my macros. I've searched Excel and VB help about how to write data to files, but can't make sense of their code examples. Please advise. Thanks.

Writing to a file is a somewhat easy task the fun part is reading from it. That stuff is a mess. If all the macros are in the same workbook you could simply Dim a variable as public/global and it would retain it's value after the code in the module ran. it would also make it accessable to everything in your VBA projects for the workbook. Unfortunetly it would lose it's value once you closed the book.

Example of a Public Dim statement (it is outside all subs and functions):
Public Features_On_Select As String

For Reading a file you can use a function like this. I didn't write it i got it from somewhere months ago.

Please Login or Register  to view this content.

example for writing to a file (see same comment as above):

Please Login or Register  to view this content.

Here is my function Path() so that you know what it is doing:

Please Login or Register  to view this content.

thanks for Replying.