Hi,
What I am currently using is a sheet in each of my workbooks with about 500 rows, each a different field which has certain information about my customers. The problem is these files are becoming rather large. I have seen the suggestion of storing the data in a text file, then retrieving it... My question is, does anyone have some sample code i could start with? I have no idea how i would write this information to the file, then retrieve it everytime i need it. Would i be able to retreive only certain fields or do i need to import the WHOLE text file everytime i need a piece of information (ie: is there a way to define a "field" using a text file?)
Thanks
What I am currently using is a sheet in each of my workbooks with about 500 rows, each a different field which has certain information about my customers. The problem is these files are becoming rather large. I have seen the suggestion of storing the data in a text file, then retrieving it... My question is, does anyone have some sample code i could start with? I have no idea how i would write this information to the file, then retrieve it everytime i need it. Would i be able to retreive only certain fields or do i need to import the WHOLE text file everytime i need a piece of information (ie: is there a way to define a "field" using a text file?)
Thanks