Hello,

in excell I wrote code :
NbVeh = Workbooks(file).Sheets(brut).PageSetup.LeftFooter
NbVeh1 = Mid(NbVeh, 10, 3)
NbVeh1 = NbVeh * 1this code extracts from 10th character forward in length 3 characters from left footer and converts it to number (the extracted data is always number).

Is it possible to do the same thing in access?

Thanks for help

If you're asking with respect to using the Mid() function then yes it is the same. Have you tried it out?

Welcome to AWF by the way

Thank you for such a fast answer.

The problem is I'm a quite newbie in access (well I know SQL and basics of access) but I don't know how to write a macro in VBA.

Can you help me?

You've got some reading to do then. Have a look at this thread on some good online tutorials:

http://www.access-programmers.co.uk/forums/showthread.php?t=195249

You would need vba instead of a macro.