Hi everyone,
i want to set the default file path in excel with VEE to for examble "C:\temp", i have tried *Application.DefaultFilePath = "C:\temp"* , but this didn't work.
( [https://msdn.microsoft.com/en-us/library/tf9k1sdd%28v=vs.90%29.aspx] )
To get the default path i have used *A = Application.DefaultFilePath* and it worked.
hope that someone can help me.
Thanks
i want to set the default file path in excel with VEE to for examble "C:\temp", i have tried *Application.DefaultFilePath = "C:\temp"* , but this didn't work.
( [https://msdn.microsoft.com/en-us/library/tf9k1sdd%28v=vs.90%29.aspx] )
To get the default path i have used *A = Application.DefaultFilePath* and it worked.
hope that someone can help me.
Thanks
If the new value is set, then it might be something to do with the way you are using the default directory, in which case why not post that here.
If the new value is not set, then presumably there is some permission or other reason ( syntax is not exactly as expected ( even though it might match the example ;-) ).
HTH,
Mike