PPT with Excel Linked File with username variable in Path

[gmooney100]

I have a Powerpoint that I want to insert an Excel Linked file to my desktop and this file will be shared with multiple users whom I will instruct to save the Excel file to their desktop.

When I try to add the linked Excel file the dialog box ask for the file location is will not let me substitute %userprofile% into the path name.

Any ideas how this can be accomplished?

[Paul_Hossler]

The title says "username" but the text says "userprofile" -- there's a difference




environ("userprofile")

environ("username")

[gmooney100]

Hi Paul,

I am not sure which one I mean. I tried both %username% and %userprofile% and neither of them worked. It gave me an error that the path was not found for both.

[Paul_Hossler]

What's the real path you want?

Usually it's something like

environ("userprofile") & "\Desktop"

returning

"C:\Users\You\Desktop"