Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Glenn Duncan on Aug 25 In MS Office Category.

setting the name in a workbook

Question Answered By: Geneva Morris on Aug 25

Looks like the "New" threw you. It is not a keyword, but part of the name.

The code should be

newWB.Title = "Yield Curves"

newWB.Subject = "Yield Curve"

Call newWB.SaveAS(Filename:="c:\foo.xls")

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

Didn't find what you were looking for? Find more on setting the name in a workbook Or get search suggestion and latest updates.

Related Topics:

Change Workbook's Name
Making a Workbook as an Active Workbook without opening it
Prob running workbook activate code when workbook is opened by anot
Run Macor in a closed workbook and refer to the closed workbook
Next Workbook or Previous Workbook
Activate a worksheet or workbook with a variable name
macro to get info from workbook thats name changes
GETTING CUSTOMER NAME FROM ANOTHER WORKBOOK THRU PUBLIC FUNCTION
Opening a workbook, and setting it as a variable
Can't get local yp domain: Local domain name not set
Stopping users from "x-ing" out of a workbook
Workbook and Worksheet manipulation
My Personal Macro Workbook Won't Show
Read-only Workbook
Can't show a Workbook opened by GetObject()
Linking data from one Workbook to another
Activate Workbook by using a variable
Sharing Macro/workbook with others
Restrict workbook to network
Delete everything in a workbook that is a number

Tagged:setting the name in workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us