My project was meant to benefit my
wife first and foremost. She can spend quite a bit of time in a given week
searching through the Internet looking for recipes to cook. There have been
many times when we have some ingredients but then she’s not sure what meal to
cook and needs some inspiration. I originally set out to design a system where
she could input a number of ingredients into a user form that would then search
a specified recipe website and return the first recipe from the search results
list. I wanted to cut out the step of searching the entire web or opening the
browser to a website and searching within that site. Another layer of
complication for my wife is her desire to eat almost exclusively based on the
Paleo lifestyle.
After
meeting some initial roadblocks with my web query, I decided to use a web
application agent to create an object that then fed into another user form that
then showed a list of the results. This allowed me to import only the
ingredients and directions into a clear, easily-readable user form that a user
can then save to a new excel worksheet. The code is housed in the one user form
and a single module in the ribbon to initialize the user form. Adding the
picture to the user form was a difficult step but I think added a lot of value
as a visual.
Files:
Files:
No comments:
Post a Comment