Points: 7283

10/8/2019 3:24:52 PM

Excel - refresh the dataset and save from VBS

* This article, and all our great Dynamics GP documentation, Is available on the Dynamics GP menu

A client called me today and asked for something that I'd not considered before - he had Excel spreadsheets that are connected to a data source, he wants to refresh them and email them out nightly 

*** the email recipients are outside the domain and will not have a connection to the data souce


The article below describes how I did this
Version: Unknown or N/A
Section: VBA,.NET Development
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables