Hey Everyone-
Need a little help. I have done alot of Vb in Excel and have used Access quite a bit but have never written any Macros or VB in Access. Im not sure where to start but here is what I want. If anyone can let me know if this process is better served by a Macro or VB code in Access I would really appreciate it.
I have two queries that I want to AutoExport to Excel on the 10 and 25th of every month. I want to set up a Macro or VB which will run these exports automatically on those dates and save them to a specific folder out on the network. I noticed that Access has some features for this but not sure if VB would be better suited. Any help would be Great!
Thanks Chad
Need a little help. I have done alot of Vb in Excel and have used Access quite a bit but have never written any Macros or VB in Access. Im not sure where to start but here is what I want. If anyone can let me know if this process is better served by a Macro or VB code in Access I would really appreciate it.
I have two queries that I want to AutoExport to Excel on the 10 and 25th of every month. I want to set up a Macro or VB which will run these exports automatically on those dates and save them to a specific folder out on the network. I noticed that Access has some features for this but not sure if VB would be better suited. Any help would be Great!
Thanks Chad