Uploading excel files: Useful and Cool

A

Albert

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
 
G

Gord Dibben

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
 
Top