Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: HarlanJ
  • Content: Threads
  • Order by date
  1. HarlanJ

    Macro resume based on user condition

    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...
  2. HarlanJ

    Copying an open excel document with VBA

    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...
  3. HarlanJ

    Starting Line Input from a user given line

    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...

Part and Inventory Search

Back
Top