using File Copy VBA

[bamaisgreat]

Thanks for looking.

Im having trouble getting the code to FileCopy the active workbook. Any suggestions? Thanks again

ActiveWorkbook.save
On Error Resume Next
Kill "C:\VBA Code\Book5.xls"
On Error GoTo 0
FileCopy :="ActiveWorkbook", Destination:="C:\VBA Code\Book5.xls"
End Sub

[alansidman]

Here is some code on the subject

http://www.rondebruin.nl/folder.htm

[bamaisgreat]

Thanks for the info that has alot of useful information..
The problem im having is that it doesnt show how to do the ActiveWorkbook with the filecopy as shown below

Please Login or Register  to view this content.

[alansidman]

Since the active file is open, don't you really just want to save it to a destination and not copy it?

http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[bamaisgreat]

I was hoping there was just a simple fix to the small bit of code I had posted, but it seems to be a little more complex than I thought. The code below is the whole Sub the Red highlighted area is where I need another copy made of the ActiveWorkbook.

Please Login or Register  to view this content.