I was offered a project for a little extra cash (which i despirately need). I need to create a VB form which takes in user input, and based upon input, writes data to an excel spreadsheet. It also must access a microsoft access database to obtain other information. I have limited knowledge of excel and visual basic (im a java man), and next to 0 knowledge of access. I thought the easiest way would be to create a program in Visual Basic 6.0 and have it access the excel spreadsheet and the access database, but I don't know how to do that.
It may be easier to create a macro in Excel or Access, rather than a Visual Basic program. I really don't know. If anyone could help, I'd really appreciate it. As you can see, I really need the help.
Thanks,
Seth
It may be easier to create a macro in Excel or Access, rather than a Visual Basic program. I really don't know. If anyone could help, I'd really appreciate it. As you can see, I really need the help.
Thanks,
Seth