Powerpoint Title String Incomplete

Hello,

I have a vb code that I use to create PowerPoint slides by extracting charts from Excel. I need the title of my slides to read Per Case Margin Variance FY2005Q3

Dim FY as String
Dim QTR as String

FY = xlWrkBook.Worksheets("Variance Chart").Range("B1").Value
QTR = xlWrkBook.Worksheets("Variance Chart").Range("C1").Value
ActivePresentation.Slides(Index:=1).Shapes.Title.T extFrame.TextRange.Text = "Per Case Margin Variance FY" + FY + "Q" + QTR

However, the result I am getting is reading Per Case Margin Variance FYQ. Why are my variables not being put into the title?

I am new at VB so thanks so much!

You should use the & operator to concatenate. Using the + operator can give you strange results when numbers are involved.

ActivePresentation.Slides(Index:=1).Shapes.Title.T extFrame.TextRange.Text = "Per Case Margin Variance FY" & FY & "Q" & QTR

Thanks for your response!