Workbooks.Add Format Text

O

osxandxls2004

ow can I make the Format set to ->Text (tab)<- when suggesting the user
to give a name and save a file? This works already:

Set NewBook = Workbooks.Add
Do
fName = Application.GetSaveAsFilename

NewBook.SaveAs Filename:=fName
With Application
.SheetsInNewWorkbook = 1
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A problem with creating a workbook by VBA 3
VBA - exporting serial letters to single documents 0
Workbooks.SaveAs - How to have it saved with .xls extension? 2
Converting URLs in comments to Markdown-formatted links 2
error while running macro, but not if stepping through lines. 3
Word 2016 - Difficulties Learning Style Creation/Application 0
Word macro that can call cells out of Excel for a find and replace 0
Error Handle: File is already open. 3

Top