I have been doing that - which has got me to a level whereby I know how to write code to select between different worksheets and change data in cells. I can also attach code to buttons and display user forms.
I just don't know the right way of doing things. I think the most desirable solution would be to create the VBA code and distribute it as an add-in for Excel. That way, it's in the menus and the office numpties can't delete it or overwrite it (I'm dealing with people who have no real clue what a folder is, or how to send a link in an email instead of the actual file which they want updating by everyone in the office).
All I want is a simple app that presents the user with three very easy to understand options (month and year of the invoice to be created and a button that says "create invoice" which prompts for the text file to take the data from). They then print the invoice, or email it, or they come and ask me for the umpteenth time how to export it as a PDF.
**EDIT** I've no doubt I could muddle up a solution, but it would be woefully inelegant and prone to user error. I would end up getting the blame for the user error :^}
I just don't know the right way of doing things. I think the most desirable solution would be to create the VBA code and distribute it as an add-in for Excel. That way, it's in the menus and the office numpties can't delete it or overwrite it (I'm dealing with people who have no real clue what a folder is, or how to send a link in an email instead of the actual file which they want updating by everyone in the office).
All I want is a simple app that presents the user with three very easy to understand options (month and year of the invoice to be created and a button that says "create invoice" which prompts for the text file to take the data from). They then print the invoice, or email it, or they come and ask me for the umpteenth time how to export it as a PDF.
**EDIT** I've no doubt I could muddle up a solution, but it would be woefully inelegant and prone to user error. I would end up getting the blame for the user error :^}