Uploading excel files: Useful and Cool
 

Hello!
I have a space on a server. I want some people who use my application to be
able tu upload their backups onto my server so I can process them. However, I
would like them to be able to do the upload directly from Excel. Is there a
way to do this programatically?
Thanx in advance,
Albert

Uploading excel files: Useful and Cool
 

Albert

Sub BUandSave2()
'Saves the current file to a backup folder and the default folder
'Note that any backup is overwritten
Application.DisplayAlerts = False
ActiveWorkbook.SaveCopyAs FileName:="your path to server\" & _
ActiveWorkbook.Name
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 08:27:01 -0700, Albert
wrote:

Hello!
I have a space on a server. I want some people who use my application to be
able tu upload their backups onto my server so I can process them. However, I
would like them to be able to do the upload directly from Excel. Is there a
way to do this programatically?
Thanx in advance,
Albert