ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Do Macros cause corruption of big files (https://www.excelbanter.com/excel-discussion-misc-queries/57870-do-macros-cause-corruption-big-files.html)

Abhay

Do Macros cause corruption of big files
 
I frequently use Macros for formatting csv, dat or prn type of files. I am
told that such frequent use of Macros may corrupt the files. Is it true?

Dave Peterson

Do Macros cause corruption of big files
 
Since .csv and .prn (and .dat???) are plain old text files, they shouldn't be
corruptible at all.

If you're saving the file as .xls, then I've never noticed any correlation
between macro use and corrupt files. But I'd say finding the reason a file gets
corrupted is pretty difficult.



Abhay wrote:

I frequently use Macros for formatting csv, dat or prn type of files. I am
told that such frequent use of Macros may corrupt the files. Is it true?


--

Dave Peterson

Bill Martin

Do Macros cause corruption of big files
 
Abhay wrote:
I frequently use Macros for formatting csv, dat or prn type of files. I am
told that such frequent use of Macros may corrupt the files. Is it true?


The only reason I can see this would be true is if you had subtle programming
errors in your macros. The computer just does what it's told (most of the time).

Bill


All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com