Hello -
I have a user in a remote office that needs to export a file from Excel in
text format to a server in our main office. The macro has worked in the past,
but after setting this up for a new user, we can't get it to work. The macro
seemingly runs correctly, but the file never shows up in the remote
directory. The macro does work from my desk at the main office. The new user
is also able to manually copy a file to the remote directory, so it doesn't
appear to be a permissions issue. The one thing I have noticed, however, is
that the access to the server from the remote office is very slow. Could this
command be timing out? It takes a minute or two for the server directory to
manually appear on the remote user's computer.
Here is the code we are using:
'
' export text file to desktop

ChDir "\\sys002sv\Newsroom\DTIImport\MiscCharts"

fileSaveName = Application.GetSaveAsFilename( _
initialFileName:="\\sys002sv\Newsroom\DTIImport\Mi scCharts\MS_Bus_Lic",
filefilter:="Text files (*.txt),*.txt")
If fileSaveName < False Then
MsgBox "Saved File to " & fileSaveName
Else
MsgBox "Save Cancelled!"
End If
End Sub

thanks for any help - The only ugly workaround I can think of now is to have
the file save to the desktop, then do a manual copy.