Hello! Short story: I am trying to tie a "Billing Tool" I made into an access database.
Long Story: I recently developed a billing tool in Excel. The user dumps a text file into a "raw" tab, then via a series of push button macros, an invoice is built. This final invoice contains unique account numbers (hundreds). When complete, the user has the ability to push a "Save" macro that outputs the invoice tab as a separate excel file to a drive. I would like to add to this function and send the account number to an access DB and time stamp it. Each time the user creates an invoice, the new account numbers would be sent to the same access DB-- essentially creating a log of accounts that have been invoiced and the time they were generated.
Is this possible via VBA script? I have limited Access skills but can learn.
Long Story: I recently developed a billing tool in Excel. The user dumps a text file into a "raw" tab, then via a series of push button macros, an invoice is built. This final invoice contains unique account numbers (hundreds). When complete, the user has the ability to push a "Save" macro that outputs the invoice tab as a separate excel file to a drive. I would like to add to this function and send the account number to an access DB and time stamp it. Each time the user creates an invoice, the new account numbers would be sent to the same access DB-- essentially creating a log of accounts that have been invoiced and the time they were generated.
Is this possible via VBA script? I have limited Access skills but can learn.