Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all! I had posted a message here, and I do not believe it was
answered. Maybe it fell through the cracks (very possible as there are bunches of posts a day) or maybe it was deleted because someone found the secret communist anti-France satanic message hidden carefully within the subject title. Or maybe you people have answered this same question about 500 times and didn't want to answer it a 501st time. Well...sorry, but I fear I must bother you again. If I missed the post and someone DID answer me, sorry, but I missed it. My Question: Does anyone know how I can get a spreadsheet to save to desktop consistently on an NT based system where user name might be different? If I do not put anyfile path in my macro, it saves it to the users documents folder. is there a way i might be able to backstep to desktop from there? or is there a way i can just say "userDesktop" or something? Or will I need to somehow find the active username and add it into a filename string like {"C:\Documents and Settings\" & UserName & "\Desktop\" & DForm.DSave & ".xls"}? Thanks |