var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need help in automating this.
I need to export a query and then create a pivot table using this data.
Any help will be appreciated.
Check out Export to Excel in code bank. I am reasonably confident I put some pivoting into that.
ur codings are working excelent.
Thanks I will have a look.
In the mean time what i have done is just recorded a macro in excel to create a pivot, exported the query to that sheet using transferspreasheet and then called the macro from access after it exports the query data.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors