Morning all.
This forum has helped me time and time again but I think this one might be one step too far...
At the moment I use a VBA code to transfer my appointments (which change regularly) from a spreadsheet over to my Outlook calendar. It's saved me so much time and I absolutely love it!(I tell everyone about it, even if they don't want to listen). With this in mind I was wondering if I could use a VBA code to interact with other software, particularly the SAGE accounting system.
In a nutshell I process regular orders for engineered product which consistent of multiple parts which can come from 3 different suppliers (imagine a skateboard and I have to source the board, trucks & wheels from different suppliers). So I receive an order from a customer and then send an order to our suppliers for each of the parts to make it. These are all repeats so I just duplicate the orders and send straight to the supplier. What I'm wondering is if there's a mega code that will allow me to select a product (skateboard for example), run the code and it will automatically send my orders out to my suppliers.
I am very doubtful this is possible but this forum has surprised me before so worth a shot.
Any thoughts on this (even if not an answer and just an opinion) would be greatly appreciated.
Thanks!
This forum has helped me time and time again but I think this one might be one step too far...
At the moment I use a VBA code to transfer my appointments (which change regularly) from a spreadsheet over to my Outlook calendar. It's saved me so much time and I absolutely love it!(I tell everyone about it, even if they don't want to listen). With this in mind I was wondering if I could use a VBA code to interact with other software, particularly the SAGE accounting system.
In a nutshell I process regular orders for engineered product which consistent of multiple parts which can come from 3 different suppliers (imagine a skateboard and I have to source the board, trucks & wheels from different suppliers). So I receive an order from a customer and then send an order to our suppliers for each of the parts to make it. These are all repeats so I just duplicate the orders and send straight to the supplier. What I'm wondering is if there's a mega code that will allow me to select a product (skateboard for example), run the code and it will automatically send my orders out to my suppliers.
I am very doubtful this is possible but this forum has surprised me before so worth a shot.
Any thoughts on this (even if not an answer and just an opinion) would be greatly appreciated.
Thanks!
