none
Save a CSV file without excel being installed. RRS feed

  • Question

  • Hello

    I have written a simple VBA program in Outlook that extracts information from the body of an email and saves it to a CSV file using Excel.  There is no version of Excel on the server that it will run on.  Can I get it to work on the server without installing excel?

    Thanks

    Tuesday, January 27, 2015 9:46 AM

Answers

  • Hi Richard,

    You said that “save it to a CSV file using excel”, since you are using excel, in my opinion, the excel installed in that server machine is required.

    On the other hand, Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

    # Considerations for server-side Automation of Office

    https://support.microsoft.com/kb/257757/en-us?wa=wsignin1.0

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, January 28, 2015 9:38 AM
    Moderator

All replies

  • This does not appear to be a question about Microsoft Access database program, the topic of this forum.

    Access developers would use DoCmd.TransferText. If you wanted to do it in a more manual fashion you can use regular File I/O functions like Open, Print #, Put, Write #, etc.

    Outlook on the server? How strange.


    -Tom. Microsoft Access MVP

    Tuesday, January 27, 2015 1:37 PM
  • Tom,

    The forum is for office, not just access.

    Richard,

    the reason excel (and other client based office products) aren't supported on a server is that they are single threaded and cannot be shared in a server world (multiple users trying to use them simultaneously). CSVs are merely text strings and there are plenty of examples of how to create them without calling Excel.

    Al


    Al Edlund Visio MVP

    Tuesday, January 27, 2015 1:59 PM
  • Hi Al

    Thanks for your response, have you any examples?

    Thanks

    Rich

    Tuesday, January 27, 2015 3:07 PM
  • Tom,

    The forum is for office, not just access.

    Richard,

    the reason excel (and other client based office products) aren't supported on a server is that they are single threaded and cannot be shared in a server world (multiple users trying to use them simultaneously). CSVs are merely text strings and there are plenty of examples of how to create them without calling Excel.

    Al


    Al Edlund Visio MVP

    Al - No, it is not for all Office products. The title of the forum is "Access Developers" On the list of forums page it states:

    Access for Developers

    This forum is for Developer discussions and questions involving Microsoft Access

    ...unless your post was moved from another forum.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, January 27, 2015 4:05 PM
  • Hi Richard,

    You said that “save it to a CSV file using excel”, since you are using excel, in my opinion, the excel installed in that server machine is required.

    On the other hand, Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

    # Considerations for server-side Automation of Office

    https://support.microsoft.com/kb/257757/en-us?wa=wsignin1.0

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, January 28, 2015 9:38 AM
    Moderator