WebGuy
07-17-2006, 02:30 AM
Hi !
I am trying to save a copy of my workbook main page as a textfile, but i do not want the original workbook ("Main") to change its name to "hwspec.txt". I have checked for previous posts, but i cant seem to find an answer .
the code i am using to save is :
SaveTXT = MsgBox(Prompt:="Save hardware specs as a textfile ?", Buttons:=vbYesNo + vbQuestion)
If SaveTXT = vbYes Then
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\STLARSHE\Desktop\Excel\Logbok\HWSpecl.txt", _
FileFormat:=xlText, CreateBackup:=False
End If
Thank you !
I am trying to save a copy of my workbook main page as a textfile, but i do not want the original workbook ("Main") to change its name to "hwspec.txt". I have checked for previous posts, but i cant seem to find an answer .
the code i am using to save is :
SaveTXT = MsgBox(Prompt:="Save hardware specs as a textfile ?", Buttons:=vbYesNo + vbQuestion)
If SaveTXT = vbYes Then
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\STLARSHE\Desktop\Excel\Logbok\HWSpecl.txt", _
FileFormat:=xlText, CreateBackup:=False
End If
Thank you !