Probleme with filesystemobject

[afaissal]

Hi everybody ,
i've copied some folders using the copyfolder method of filesystemobject . i've verified then , that files contained in the source folder are copied in the destination one (exactely the same).
after using the copy, i've proceed to editing one of the copied files (excel one) by using getobject method .
the pb is when i verify the new file copied , it has the name of the source one (ok) but a bigger size (logical),but when i open it ...,nothing , the file is named workbook1 and its clean !
could anybody help me please.

 

[misterstick]

a little code, please.

i suspect, however, that you are expecting GetObject to open a file from disk, when AFAICR, it gets one in memory.

use Workbooks.Open(filename) instead.


mr s. <