Results 1 to 5 of 5

Thread: [RESOLVED] append csv into closed workbook

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Location
    Italy-Napoli
    Posts
    2,093

    Resolved [RESOLVED] append csv into closed workbook

    I just have a workbook named TEMPLATE.xls in c:\mydir\
    i need to import into this worbook a csv file, with a delimited ";", without open the wbook.
    example, please

  2. #2
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,239

    Re: append csv into closed workbook

    you have to open the workbook, one way or another
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Mar 2005
    Location
    Italy-Napoli
    Posts
    2,093

    Re: append csv into closed workbook

    Quote Originally Posted by westconn1 View Post
    you have to open the workbook, one way or another
    im sorry, "without open", without to show the workbook... during the code, but in silent mode.

  4. #4
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    4,144

    Re: append csv into closed workbook

    Code:
    Dim xlApp As Excel.Application
    
    Set xlApp = CreateObject("Excel.Application")
    xlApp.DisplayAlerts = False
    xlApp.Visible = False

  5. #5
    PowerPoster
    Join Date
    Feb 2006
    Posts
    21,863

    Re: append csv into closed workbook

    Old demo. No MS Excel required on the machine.

    Name:  sshot.png
Views: 35
Size:  32.4 KB
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width