I've written a macro that parses text files into memory, modifies the values, and then outputs the new values to a spreadsheet. I have it written to cycle through a set number of lines in a text file before outputting the data, pausing for a moment (ex. 5 seconds), and repeating the process...
Hello,
I've written a procedure that checks the current year against a user-input year. If the two differ (i.e. the user selects next year), the workbook will be copied and saved with the current year appended to the file name.
However, I'm using the FileCopy statement and it returns an error...
Hey there,
I've written a macro that reads comma delimited text files into VBA and graphs the data in excel. The graph is set to update every 100 lines of read data before pausing for 5 seconds to let the user view the generated graph. I have some public variables that allow the user to pause...
