File System Object

[sassriverrat]

Is there a way to dim a FSO code so that a computer doesn't have to have the library checked off in the references tab? Otherwise I need to find a new way to copy a file in VBA without .CopyFolder and .CopyFile....thanks

 

[DanteAmor]

Check this

https://docs.microsoft.com/en-us/of...erence/user-interface-help/filecopy-statement

 

[sassriverrat]

hmmmm...unfortunately I don't think I can do that because the file is active (open) when the code should run... essentially I'm using the copy feature to "save as"

 

[sassriverrat]

actually that gives me another idea so that might just work! Thanks!

 

[DanteAmor]

You can also use savecopyas

https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.savecopyas

Let me know if you have any doubt

 

[sassriverrat]

Awesome. So one more question: recommendations on a better way to check for a file existing then len(dir(xxname)) <> “” then?

thanks

 

[Norie]

To use the FileSystemObject without the reference you could use late-binding.

Dim FSO As Object

    Set FSO = CreateObject("Scripting.FileSystemObject")

    ' do things with file system object FSO

 

[sassriverrat]

Is there any scenario then when excel might not recognize FSO then because the references have been checked?

 

[Norie]

Not sure what you mean, in the code I posted FSO is a variable with an arbitrary name - it shouldn't make a difference if the reference is checked or not.

 

[DanteAmor]

Awesome. So one more question: recommendations on a better way to check for a file existing then len(dir(xxname)) <> “” then?

thanks

review these options

https://www.mrexcel.com/forum/excel-questions/1091765-fastest-way-check-if-file-exists.html