Experts, I have data with dates along the top row. When I make a chart, I do not see these dates along the axis like I believe I should. I would also like to use the built in pivot charting grouping such as group my month. I am not sure if I can do so though. I believe dates along the top row creates issues for pivoting/charting? How to solve?
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.