filesystemobject

Hi all, I have a macro, part of which lists all the files (all JPEGs) in a particular folder. I need to obtain the width/height of these pictures in pixels. My understanding is I can't do this with FileSystemObject, is there another way? Any suggestions gratefully received. Jerry

Hello everyone This is my first post. I've spent all day trying to figure this one out. What I'm trying to do is check the existence of files in subdirectories by matching text in an excel range ("A:A"). The text within each cell in the excel range are partial filenames. So far, I've been using...

Can someone post code for the following? <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Seeking program (script) that would: · Open each Excel file (.xlsb) in a designated folder · Save each · Close each Note: Needs to work even as folder content change...

Hi. I am trying to list files and their properties (need modified date and size) from a directory. I have tried using FileSystemObject, but retrieving the file name seems to take a lot of time (oddly the other properties are listed in a flash). It takes me several minutes to list just a couple...

I currently have a worksheet that, using a Form Button, generates a new worksheet that formats column widths, titles and also creates a file list of all files on my hard-drive along with date created and the full file path. Each file has all of its information in one row. From the original...