ms excel

  1. M

    Convert CSV to XLS

    I have a form that deals with excel (csv, xls) to convert a CSV file to a XLS file and adjust a few columns. I use the resulting file to upload the data to a msaccess table. The csv file is downloaded from the internet and is the only format available. The problem I have is that there a couple...
  2. P

    Question Prevent manually opening Excel instance during Automation

    Hi, I have a VB .Net windows application that generates reports in excel files from a dataset. I use "New Excel.Application" to create the application, delete all but one worksheet to begin with, and push data from my dataset in a loop. During this process, I do not show the Excel GUI to the...