File size

B

Bill

Can anyone help.
I am importing images files from a directory.

MyPath = "path"
MyNamejpg = Dir(MyPath + "*.jpg")
Do While MyNamejpg <> ""
'
'
loop
this will read all the jpgs in the directory and write to a table. Is there
a way to get each file size and store in field in table.
thanks!
 
C

Cheryl Fischer

Check out the FileLen() function - it returns the size of the file in bytes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Dir() not working in MS Word 2016 in MAC system 0
Mail Merge Directory Conditional Page Break 0
How to paste this down? 3
Directory Inventory 1
Sub projects added as read only in Master file which are saved on sharepoint 1
Inserting multiple images into a worksheet 7
macro listing subfolders from selection of mainfolders 1

Top