Visual Basic

The on error resume should avoid but doesnt. The error is that it is finsindg an existing file of the same name and then falls over when you click no or cancel as oppsed to yes because the function is saveas hence the saveas has failed. SO how to get around the failure of the function????

I had a similar problem with this Temp directory in Win 2000 -- it's a hidden directory. I had to go into the folder options in Windows Explorer and choose to view all folders -- hope this solves your problem.:)

Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long) :-D

You can record a macro bu trouble is when recording a macro you cant use the cut and paste functions properly. I know that I want to do: siv = ActiveSheet.Cells(6, 2).Value ActiveWorkbook.SaveAs Filename:="C:\My Documents\"&siv".xls", FileFormat:= xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False but of course it doesnt like me stuffing the siv variable in like that so I am snookered. There is the save method NewBook.SaveAs Filename:=fName so I can swap fname for siv, but this doesnt let me state where it has to be saved :eek:

There are performance counters that shows that... - Anders Money talks, but all mine ever says is "Goodbye!"

Just think about what a transaction is designed to do. eternal student Give a man a fish and you feed him for a day; teach him to use the 'net and he won't bother you for weeks.

10 It's a little cheaper to buy a 20 proper basic interpreterr 25 eg. BBC micro. 30 END eternal student Give a man a fish and you feed him for a day; teach him to use the 'net and he won't bother you for weeks.

yes, use the MCI sendstring to send strings and control the pitch, later i might post code if i get a chance VB 6.0 Guru, learning VC++ 6.0 MY MP3 Player

I would use the split command to find the text that you are trying to replace. I'm sorry, but if I could see a few of your lines from the file I think that I could start the function for you. I hope that you have found away to do this by now.