saving a file - syntax problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ozgirl - 22 Dec 2005 06:01 GMT

Hi,

i'm hoping someone can help me.

i have some code which saves a report to specific place. the problem i have
is when two people run the report at the same time. one works and the other
gets an error

the path i currently have is
V:\Temp\rptRCTI_Expanded.rtf

what would the correct syntax be above to have the file save to My Documents
for each user. (My Documents has the space)

thanks heaps
Lee-Anne

Reply to this Message

John Nurick - 22 Dec 2005 08:05 GMT

This function will return the user's My Documents folder:

Public Function MyDocumentsFolder() As String
Dim wshShell As Object
Set wshShell = CreateObject("WScript.Shell")
MyDocumentsFolder = wshShell.SpecialFolders("MyDocuments")
End Function

>Hi,
>
[quoted text clipped - 12 lines]
>thanks heaps
>Lee-Anne

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

ozgirl - 22 Dec 2005 23:32 GMT

many thanks John..

>This function will return the user's My Documents folder:
>
[quoted text clipped - 14 lines]
>
>Please respond in the newgroup and not by email.

Reply to this Message