Prev: Dataform
Next: VB Code or Excel macro to run Query/Import on Access file
From: JeepNC on 14 Feb 2005 13:27
I have some VBA code that saves a worksheet as XLText in Excel 9 but it
doesn't work in Excel 10. It appears that XLText is not a valid file format.
Instead I have the option of XLTextMSDOS, XLTextWindows etc. Does anyone
know which one of these will give me the same file format as the plain XLText
did in version 9?
From: Tom Ogilvy on 14 Feb 2005 13:38
xlCSV

--
Regards,
Tom Ogilvy

"JeepNC" <JeepNC(a)discussions.microsoft.com> wrote in message
news:D51DE7E6-5EF6-4523-991A-ABF76E62A4A7(a)microsoft.com...
> I have some VBA code that saves a worksheet as XLText in Excel 9 but it
> doesn't work in Excel 10. It appears that XLText is not a valid file
format.
> Instead I have the option of XLTextMSDOS, XLTextWindows etc. Does anyone
> know which one of these will give me the same file format as the plain
XLText
> did in version 9?


 | 
Pages: 1
Prev: Dataform
Next: VB Code or Excel macro to run Query/Import on Access file