View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
peter peter is offline
external usenet poster
 
Posts: 36
Default How can I export the Pivot Table with saved data created by OWC?

I am using Office XP, I am using VB.NET for writing a
program which I can create a Pivot Table report which
retrieve data from DB. I know how to connect the database
and set fields to excel using the OWC object. However, I
want export the Excel file with the saved data, that
means not connect to DB anymore. Then, I can send it to
user.
Please help, thanks.