- #Crc32 checksum calculator how to
- #Crc32 checksum calculator 64 Bit
- #Crc32 checksum calculator code
I'm testing on my Vista 64 bit computer (my other computer is incommuncado for several weeks until my bathroom renovation is completed. Sub Sub AddFolderTo2DArray() - line 527 in module - mvarArrOut(3, mlngRecord) =. TEST ME 3 - Selected Folder c:\ (manually entered). Does anyone care about 'short file names' in 2014. In the 'size' column I prefer (United States comma formatting ). TEST ME 3 - Minimal Results - Very nice output data.Ī. TEST ME 2 - No anomalies found - every path ran into a debug.assert false which is probably what you expected.ģ. TEST ME 1 - Error building an array of file names when folder selected had no files in it.Įrror occurred building an array of file names.
#Crc32 checksum calculator code
If it's not asking too much, could you spare the time to place a few breakpoints throughout the code and run it again to see where it occurs? I'd like to know what is triggering this for you.ġ. I have run this several times on different computers & folders and haven't received this error message for some time now.
To save you the effort on each release, I've changed the project to. Once this project is no longer beta, I will be removing all debug.assert False references (except from error checks e.g. It acts like a hardcoded breakpoint - I find it quite useful. That's intentional I use Debug.Assert False for development purposes. I'm currently planning to return FullNames of all files so this would also cover it. I haven't implemented this yet but can be easily done (by setting the folder path to another string variable, writing the array to row 2 and write the original folder string to cell A1). I have no objections to you adding this feature to your own copy if you want it. Which is why I decided against it - The main uses I have for this code would not involve processing the folder where ThisWorkbook is stored. However doing so would mean extra code to process on every loop and if you are processing a large number of files, this could greatly slow down the process time. It could be easily done by checking each filename against ThisWorkbook.name and skipping when strings are equal. (I chose 6.1 because I have this notion that it is desirable to use the highest version that you have of any given reference library. I have changed to ActiveX 2.5 in the current version. I know you don't require a response but I will anyway. I'll find what's going on at the next update. xls file, I got an error message (paraphrasing again), 'Error occurred building a list of files'. I got the same ActiveX compile error and the same fix.Ħ. Since I'm using Excel 2003, I converted to an. When I pressed f5 in the debugger, the Macro continued to completion with no output.ĥ. When I tried the fso Command button, I ran into a 'debug.assert false' on line 80. It would be nice if a comment were in the output indicating that the following files were from folder xxx.Ĥ. The output displays the file names but gives no indication of which folder is being scanned. It would be nice to allow that capability - and in the output you can mention that the file was skipped.ģ. I tried to checksum the folder that contained the Excel file and got a message (paraphrasing) 'You can't checksum a folder that contains this worksheet'. Please note there is a note in the code that says you need 2.5 or greater.Ģ. I unchecked ActiveX 6.1 and checked ActiveX 2.8 and worked fine. xlsm file it wouldn't compile because I don't have ActiveX 6.1. I'll find what's going on at the next update.ġ. The following were observed while running on a Vista 64 bit system using Excel 2003. Thanks for the Rep Points - much appreciated. I plan to have 3 separate versions of this function rather than 1 version with boolean arguments - the reason for this is excess object declarations and it would be checking the boolean argument for each and every loop - I wouldn't want this to run any slower than what it already is ) You can do this by commenting out the relevant lines in the recursive function. * (I haven't produced file only/folder only versions yet. what if the user selected folder is empty? what if the path string reaches 255 characters?). I know there are things I haven't plugged yet (e.g. 
#Crc32 checksum calculator how to
Please let me know if you encounter any unhandled error and how to reproduce it. It returns an array of all files & (non-empty) subfolders * from the folder selected by the user. I'm focused on testing/improving the t_ref_FileFolder_lister_1d module (start the test using the smaller button on sheet1 or run the DevTest_Recursive (found in module t_ref_FileFolder_lister_test ) Attached workbook is where I'm up to now.
0 kommentar(er)
