How to rename the worksheet name "Sheet1" to "File1" in VBA?
My VBA coding as follows:
Sub Copyfile()
FileCopy ("C:\Data2006.xls"), C:\Book1.xls
End Sub
How to rename the worksheet name "Sheet1" to "File1" in VBA?
My VBA coding as follows:
Sub Copyfile()
FileCopy ("C:\Data2006.xls"), C:\Book1.xls
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks