+ Reply to Thread
Results 1 to 2 of 2

Excel Crashes during automated macro to FTP a file

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    work
    MS-Off Ver
    Excel 2010
    Posts
    15

    Arrow Excel Crashes during automated macro to FTP a file

    I am trying finalize a process that ftps files to a unix server. This process sporadically crashes during testing.

    Below is an outline of what the process does.

    Call ExportCSV
    Create a .CSV file for export and save it to the C drive
    Copy and paste values and formats from 4 seperate but contiguous ranges (ie using pastespecial)
    Save .CSV
    Close.CSV
    End Sub

    Call CreateBAT
    Print text to batch file
    Close batch file
    End Sub

    Call CreateTXT
    Create a Notepad File for output
    Print server credentials, instructions, etc to notepad file
    Close Notepad file
    End Sub

    Call SendFile
    Open batchfile and FTP
    Wait 3 seconds
    End Sub

    Call KillFiles (currently commented out to observe files)
    delete all files in directory
    End Sub

    The macro does not always crash. But it seems that when if it does crash that it has only pasted partial data to the .CSV file for export. Could this crash be fixed by inputting a DoEvents in between the CreateCSV module and the Create Batch module?
    It seems a few users experience a majority of the crash instances. Maybe they have too much open on their desktop?

  2. #2
    Registered User
    Join Date
    04-24-2013
    Location
    work
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Excel Crashes during automated macro to FTP a file

    I have commented out all code after the exportCSV module. Excel hasn't crashed for me the multiple times I've tested the code through the ExportCSV module.

    Maybe I only need a DoEvents between the ExportsCSV module and the CreateBAT module?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2011 Macro Crashes after Saving File
    By tpeters74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2013, 03:41 AM
  2. [SOLVED] Excel crashes while macro processes large text file
    By RitaG in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-05-2012, 10:34 AM
  3. macro for automated download file from http login required
    By hellowit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2012, 03:17 AM
  4. mac excel crashes while trying to recover a file
    By juanvi in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-13-2012, 02:42 PM
  5. Network Macro Crashes (cannot Save 'read-only' File)
    By Chuckles123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-11-2006, 11:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1