They way my macro is set up now it will delete a serial_number.txt file and then create a new one with the value that was in the old file + 1 so for example if the old file said 1 the new file would say 2. I want to change this to replace text rather than delete a file each time this is ran. One problem I ran into when doing this was permission was not granted and this file will be sent to multiple computers and if one of them does not have permission then it won't work for them. Any ideas on how to replace text? I can do a find and replace method by referencing the cells for my variables. so say I had sn = range("'Config'!B6") then I could just go find sn, replace sn + 1 not sure if that helps but I will be searching some more but have not had any luck so far :/ Hope someone can help me! Thanks


SOLUTION: http://forums.devx.com/showthread.php?t=130375
I used the code posted there. code by Greg DeBacker

I believe if you open a file for write access without the Append parameter, it just overwrites the old file. In other words, there should be no reason for deleting the old file first.

I don't use read/write that often. Is the permission problem an operating system problem or is it an excel issue? If it's excel, it may be that you're opening the file for read access then trying to write to it in that mode, which won't work. If you need to open the file to find out what the serial number is, do so, then close it and open it in write mode (with no Append parameter).

Hope that helps :)