Excel VB Editor VBA Saving File to Desktop WinXP

[dprayner]

Hi Good people. I am on a network and I want to save a file to the Desktop C:\Documents and Settings\User\ Desktop\*.xls. The file saves correctly if I code my username. How do I code for any user on the network who may user the spreadsheet and save it to their desktop? Thank you, DAVE

 

[AnotherHiggins]

First, I'd just like to point out for future reference that this topic really should have been posted in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

Try this:

MyVariable = Environ("USERNAME")

Then use the variable when saving like this:

activeworkbook.saveas "C:\Documents and Settings\" & MyVariable  &"\ Desktop\FileName.xls."

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.