New to VBA: Not sure how to handle data which the program will need in order to run........

vba , programming , newbie Richmond, United States
  • 11 years ago

    Hi, I am new to VBA programming but in my younger days i was a good pascal programmer. I know the syntax is not the same but i am learning.

    Question: For a friend i am trying to write a "bakery" program which will accept input from a user and based on this input the program will compare/calculate against hundreds of existing recipes. The output will be new recipes based on the desired qty to make. My question is how do i store or whats the best way to retrieve the hundreds of recipes which i will need to have access to. I have done some excel vba programming and in this case the recipes would already exist in another sheet in excel. But i want to do this ALL in VBA so i am not sure how to proceed. If some one could give me a little guidance to point me in the right direction i will take it from there.



Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe