Thread
:
Macro assigned to a button
View Single Post
#
11
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Macro assigned to a button
And it didn't work??? I just created the same folders and file and moved it
with the macro.
--
Don Guillett
SalesAid Software
"Sadcrab" wrote in message
...
Don
I've changed the info as follows and created relevant directories:
Sub movefile()
OldName = "C:\Test\Active\Test1.xls"
NewName = "C:\Test\Complete\Test1.xls"
Name OldName As NewName
End Sub
"Don Guillett" wrote:
I did provide an example. Perhaps you could give the info on the path and
file name for old and new??
--
Don Guillett
SalesAid Software
"Sadcrab" wrote in message
...
Sorry Don I still can't get it to work can you supply an example
"Don Guillett" wrote:
This does work. Just change oldfolder to your desired folder and
oldname
to
your file name, etc. Then fire.
--
Don Guillett
SalesAid Software
"Sadcrab" wrote in message
...
"Don Guillett" wrote:
maybe this simple idea will help?
Sub movefile()
OldName = "C:\oldfolder\oldname.xls"
NewName = "C:\newfolder\newname.xls"
Name OldName As NewName
End Sub
--
Thanks Don but I can't get it to work. I get a runtime error 53 File
not
found more help on this please. Thanks
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett