Thanks for the pointers,
I see now then that the
was used to return to default after the previous command (~18 lines up) was
.
I also see how jumping forwards and backwards like this can get confusing, but i suppose as its a short script it may be acceptable?
I've tried to split up my post into comments and code to make it easier to read, and have taken your comments on board...
'-JS- suspend screen updating
'-JS- "source" is the range in which the root directory is specified by the user
'-JS- If no root directory was specified, the default will be C:\
'-JS- If root directory is specified, specification is prioritised
'-JS- Exports The rescaling module as a .bas file (to the root directory?)
'-JS- Sets abbreviation for access to file system object functions
'-JS- Source folder is set as the root directory (with file system object functions enabled)
'-JS- sets "MyFile" as the .csv file within each sub-sub-folder ("Exports") in the source folder.
'-JS- I think this section searches for a folder called exports and converts a .csv file to a .xslsb file,
' then it processed the file by calling another subroutine ("show bounce" which is within the previously exported module "graph_scaling"),
' then continues this process for any nyumber of folders in the root directory.
'-JS- If files DO NOT exist, then do the following
'-JS- Convert .csv file to .xslb, but if both already exist, then go to "Done"
'-JS- open the .xlsb workbook
'-JS- wait till workbook has finshed opening before proceeding
'-JS- If files DO exist, then do the following
'-JS- Once the workbook is open, wait this length of time before proceeding
'-JS- Once the workbook is open, ensure it is the active workbook
'-JS- Imports the module into the active workbook, presumably so that the subroutine within it can be applied to the active workbook.
'-JS- calls and runs the sub "show bounce"
'-JS- saves processed file as a macro enabled .xslb file
'-JS- return to default error handling
'-JS- resore screen updating
Bookmarks