Hello,
in excell I wrote code :
this 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
in excell I wrote code :
Code:
NbVeh = Workbooks(file).Sheets(brut).PageSetup.LeftFooter
NbVeh1 = Mid(NbVeh, 10, 3)
NbVeh1 = NbVeh * 1
Is it possible to do the same thing in access?
Thanks for help