cstlaurent
Board Regular
- Joined
- Jan 14, 2005
- Messages
- 182
Hi
I am not use with VBA in Excel. I am trying to undrestand but not there yet. I am trying to facilitate capturing our vacation calendar in Access instead of building the tools completely in Access. I figure to write some code to look in a given selected area and return the name an the week where an X is place.
The vacation are kept in a Excel format such as:
Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Name1 x x x
Name2 x x
Name3 x x x
What I would like to have is this info send to an Access Table.
Tehcnician -- Week --
Name1 8
Name1 9
Name1 13
Name2 3
Name2 4
Name3 8
Name3 9
Name3 10
Hope you understand what I am looking for, Any help will be appreciate.
Thanks.
I am not use with VBA in Excel. I am trying to undrestand but not there yet. I am trying to facilitate capturing our vacation calendar in Access instead of building the tools completely in Access. I figure to write some code to look in a given selected area and return the name an the week where an X is place.
The vacation are kept in a Excel format such as:
Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Name1 x x x
Name2 x x
Name3 x x x
What I would like to have is this info send to an Access Table.
Tehcnician -- Week --
Name1 8
Name1 9
Name1 13
Name2 3
Name2 4
Name3 8
Name3 9
Name3 10
Hope you understand what I am looking for, Any help will be appreciate.
Thanks.