data import to access from excell footer (1 Viewer)

BHawk

New member
Local time
Today, 08:51
Joined
Jul 1, 2010
Messages
4
Hello,

in excell I wrote code :
Code:
NbVeh = Workbooks(file).Sheets(brut).PageSetup.LeftFooter
NbVeh1 = Mid(NbVeh, 10, 3)
NbVeh1 = NbVeh * 1
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
 

vbaInet

AWF VIP
Local time
Today, 15:51
Joined
Jan 22, 2010
Messages
26,374
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
 

BHawk

New member
Local time
Today, 08:51
Joined
Jul 1, 2010
Messages
4
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?
 

Users who are viewing this thread

Top Bottom