Pivot Table to CSV File - VBA

Status
Not open for further replies.
A

Alexa

New Member
Outlook version
Email Account
Exchange Server
Hello all,

I am trying to convert a pivot table to a functional csv file. This is what I have so far but keep getting error messages. Any suggestions would be so very appreciated.

Thanks!
Alexa

sub Export_To_Excel_View1

Dim xlApp
Dim xlBook
Dim xlSheet


Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = true

Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets("Sheet1")

Set Doc = ActiveDocument

Doc.GetSheetObject("CH89").CopyTableToClipBoard true
xlApp.ActiveSheet.Range("A1").Select
xlApp.ActiveSheet.Paste

end sub
 
Status
Not open for further replies.
< Custom Contact Form how to update when loaded. | Cannot Figure Out This VBA >
Similar threads
Thread starter Title Forum Replies Date
N Private check box in table view Using Outlook 0
Y Outlook Task View - Table Format - Customize Reminder Time to Drop-Down Selection Using Outlook 2
J What is the best EntryID format to set on MS Access table Outlook VBA and Custom Forms 3
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
P Table AutoFit > AutoFit to Contents Outlook VBA and Custom Forms 0
D Paste Excel table into Outlook message Outlook VBA and Custom Forms 6
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
T "From" field font size in table list of emails Using Outlook 0
M Extracting cell data from table Outlook VBA and Custom Forms 2
G Message template / custom forms and VBA Help needed - inserting info into table Outlook VBA and Custom Forms 3
A Synchronize Access Table with Outlook Calendar Appointments Outlook VBA and Custom Forms 3
R Convert Access table to pst Using Outlook 1
T Populating listbox with MS Access table Using Outlook 2
Hudas Hyperlink Saved Outlook Email to MS Access Table Using Outlook 4
L Excel table format lost in Outlook Using Outlook 6
D outlook 2010 table format lost on send Using Outlook 1
L Cannot sync Calendar to iphone. Cannot export to CSV. Cannot view as Table. Using Outlook 3
M Table does not display Outlook VBA and Custom Forms 1
L [Outlook 2003] Add Table to form Outlook VBA and Custom Forms 2
J Lookup from an Access table Outlook VBA and Custom Forms 1
S Create Auto eMail with Web table Content Outlook VBA and Custom Forms 1
A Birthdays from .csv to Calendar - arriving day behind Using Outlook 5
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
C How to export Outlook data to csv? Using Outlook 0
avant-guvnor Import csv problem Using Outlook 7
T Outlook 2016 CSV Translator Import Error Using Outlook 6
T exporting contacts names reversed in CSV file Using Outlook 8
Diane Poremsky Can't import CSV or move Outlook items into EAS Accounts Using Outlook 0
N Importing Google contacts from CSV file removes recipient names in autocomplete list Using Outlook 0
R Correct a wrong csv export file from WLM 2012 Using Outlook 0
Diane Poremsky Filter and Save Contacts to a CSV File Using Outlook 0
Diane Poremsky Filter and Save Contacts to a CSV File Using Outlook 0
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
D Open attached CSV, copy newdata and paste it to database CSV Outlook VBA and Custom Forms 2
LarryH Importing csv file to custom form/fields? Using Outlook 3
O Importing contacts from CSV, comma delimited Using Outlook 7
wallisellener BCM 2013 importing contacts from CSV file BCM (Business Contact Manager) 8
B BCM 2010: Exporting Notes to .CSV with Business Contacts? BCM (Business Contact Manager) 3
E Macro to export BCM business data to CSV file BCM (Business Contact Manager) 1
P Export selected contacts to a .csv Using Outlook 2
M Error Messages when exporting Outlook 2010 Contacts to a CSV (DOS) or Excel Using Outlook 2
K Importing CSV contacts- doesnt allow me to map or move forward V 2007 Using Outlook 1
M how to save incoming mail in TRUE csv format Outlook VBA and Custom Forms 1
G Code that Runs nightly to export folder into a csv Outlook VBA and Custom Forms 1
F Import Calendar appointments from CSV file Outlook VBA and Custom Forms 3

Similar threads

Back
Top