vba - Shared Excel macro enabled workbook - Excel cannot access the file issue -
what want do. send macro enabled excel document colleagues working macro opens save file dialog , generates csv. what have done? i have made vba-macro in excel 2013 , works fine on machine. however, when send macro enabled excel-sheet colleague gets: microsoft office excel cannot access file 'path document on computer'. there several possible reasons: the file name or path not exist. the file being used program. the workbook trying save has same name open workbook my source: sub convert2csv() dim filename string filename = "ordersedel_" & format(now, "yyyy-mm-dd hh mm") & ".csv" application.filedialog(msofiledialogsaveas) .title = "xxx" .allowmultiselect = false .initialfilename = filename .filterindex = 15 result = .show if (result <> 0) ' create file filename = trim(.selecteditems....