'TransferText'ing a .DAT file

[pnadella]

I looked up the support site here
http://support.microsoft.com/default.aspx?scid=kb;en-us;304206 and made
changes to the registry to include .DAT as a valid file type extension.
The TransferText still does not work and it still gives me the same '
Can't update.Database or object read only.' error.

Is there a way that I can change this in code - can I change the file
extension in TransferText to .TXT and then change it back to .DAT . I
need to keep the file type as .DAT because there is a vendor package
that looks for a .DAT file.Thanks !

 

[Ken Snell \(MVP\)]

Check out the Name statement in VBA Help file. It will let you do what you
seek to do.

Name "PathAndFileName_Old" As "PathAndFileName_New"