View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
KR KR is offline
external usenet poster
 
Posts: 121
Default FileSystemObject.copyfile

Before I got your response, I kept trying, and finally found a similar
solution from an old post; they used:
Set FSO = CreateObject("Scripting.FileSystemObject")
Which seems to work even without the reference. I'll check the reference
just for future use, and it looks like I'm good to go!
Thanks again for all the help!!
Keith

"Charlie" wrote in message
...
You need the Microsoft Scripting Runtime library. From your VBE window

do:

Tools--References

(it might take a moment to open). Then scroll down to find the library

and
click the checkbox (don't just highlight the line.) Click Ok.