Take a look at the example for FileCopy in VBA's help.

Option Explicit
Sub auto_open()
Dim FromFileName As String
Dim ToFileName As String

FromFileName = "h:\mapname.bmp" '???
ToFileName = "c:\mapname.bmp" '???

FileCopy Source:=FromFileName, Destination:=ToFileName

'ThisWorkbook.Close savechanges:=False

End Sub

Put save this workbook into your XLStart folder.

I commented the last line out. When you're done testing, uncomment it and save
your workbook. When it runs it'll close this workbook--not so good for testing!



Alvin Hansen wrote:

Hi!
I want to make a macro there can
copy a map from one destiantion to another destination
F.esk H:/mapname to c:/mapname
An i want it to do this evrytime I start my excel file

Hope one can help

Alvin

--

Dave Peterson