When I run macro to fetch data from csv file, the source csv file becomes blank in newer office 365

%3CLINGO-SUB%20id%3D%22lingo-sub-2457073%22%20slang%3D%22en-US%22%3EWhen%20I%20run%20macro%20to%20fetch%20data%20from%20csv%20file%2C%20the%20source%20csv%20file%20becomes%20blank%20in%20newer%20office%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2457073%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20using%20Office%20365%20since%202017-18.%20I%20am%20using%20macro%20to%20fetch%20data%20from%20xls%2C%20xlsx%20and%20csv%20workbooks%20with%20only%20one%20worksheet%20in%20each%20workbook%20from%20OneDrive%20folder%20which%20is%20synced%20with%20my%20account%20to%20update%20a%20dashboard%20prepared%20in%20excel.%20Some%20macros%20were%20created%20in%20Office%20365%20version%202002%20(Build%2012527.21104).%20These%20are%20running%20successfully%20on%20that%20version%20of%20Office%20365.%20But%20when%20I%20am%20running%20macro%20from%20the%20same%20worksheet%20in%20newer%20versions%20of%20Office%20365%2Cthe%20data%20in%26nbsp%3B%20the%20source%20worksheet%20is%20getting%20deleted%20and%20the%20file%20is%20getting%20blank%20and%20file%20size%20is%20becoming%20zero(0)%20in%20OneDrive%20folders.%20Then%20I%20have%20to%20restore%20the%20source%20with%20older%20version%20for%20each%20workbook%20in%20OneDrive%20folders.%20This%20is%20only%20happening%20for%20new%20version%20of%20Office%20365%20like%202102%20(Build%2013801.20738)%20which%20I%20have%20checked%20repeatedly.%20I%20have%20tried%20in%204-5%20different%20system%20with%20different%20versions%20of%20Office%20365.%20I%20also%20have%20tried%20with%20creating%20new%20worksheet%20and%20new%20macro.%20But%20problem%20still%20persists%20with%20newer%20Office%20365.%20Am%20I%20missing%20something%20in%20the%20new%20version%20of%20Office%20365%20or%20some%20changes%20to%20be%20done%20in%20excel%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help.%20Thanks%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2457073%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

I have been using Office 365 since 2017-18. I am using macro to fetch data from xls, xlsx and csv workbooks with only one worksheet in each workbook from OneDrive folder which is synced with my account to update a dashboard prepared in excel. Some macros were created in Office 365 version 2002 (Build 12527.21104). These are running successfully on that version of Office 365. But when I am running macro from the same worksheet in newer versions of Office 365,the data in  the source worksheet is getting deleted and the file is getting blank and file size is becoming zero(0) in OneDrive folders. Then I have to restore the source with older version for each workbook in OneDrive folders. This is only happening for new version of Office 365 like 2102 (Build 13801.20738) which I have checked repeatedly. I have tried in 4-5 different system with different versions of Office 365. I also have tried with creating new worksheet and new macro. But problem still persists with newer Office 365. Am I missing something in the new version of Office 365 or some changes to be done in excel ? 

 

Please help. Thanks in advance

 

0 Replies