Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lloyd Alvarez   on Sep 08 In MS Office Category.

Saving a file xls as a txt format


  
Question Answered By: Blake Smith   on Sep 08

The ActiveWorkbook.name = *.xls (I believe this would supercede the
conflicting request to save as *.txt)

You want nombre to equal everything to the left of the '.xls'

So, nombre = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4)

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Saving a file xls as a txt format Or get search suggestion and latest updates.


Tagged: