Variable in a file path (VBA/Powerpoint/2000)

[tgmoon]

Hi everyone.

A quick question. Is it possible to use a variable in a file path that occurs several times in some code. For example, c:Pictureschart.....?

many thanks

Thom

[HansV]

Yes, by declaring a constant or variable, and using & to concatenate strings. For example:

Dim strFile As String
Dim strPath As String
strPath = "C:PicturesChart"
strFile = "Orders.xls"
Workbooks.Open strPath & strFile
...
strFile = "Accounts.xls"
Workbooks.Open strPath & strFile
...

If the path will never change, you can replace

Dim strPath As String
strPath = "C:PicturesChart"

with

Const strPath = "C:PicturesChart"

[tgmoon]

Many thanks for this Hans