Thread: Simple use of Len?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ray at[_2_] Ray at[_2_] is offline
external usenet poster
  
Posts: 13
Default Simple use of Len?
filename = Replace(filename, ".doc", ".xls")

Ray at home


"Stuart" wrote in message
...
vFileName holds the full path and filename of a Word
document opened via Excel VBA.

A new workbook is created, and data is imported from
the Word document.

Before I save the new workbook, how can I use LEN
to simply change vFileName to end as *.xls, rather
than its' current *.doc, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.536 / Virus Database: 331 - Release Date: 03/11/2003




Reply With QuoteReply With Quote