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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

    Text File Drops Leading Zeros

    I routinely work with extracts where any account numbers which start with "0" or "000" appear without the leading zeros, as the data gets parsed as a text file and the leading digits get dropped. What is the best way to remedy this with VBA? The files are large and contain...
  2. eBartlett

    Retrieve User Name

    I would like the user name to appear as a footnote in Excel. I have the syntax to access the network login id, but I want to capture the user's full name from Excel. Does anyone know how to do this?
  3. eBartlett

    Variable Fields in Word

    We have contracts that may require the signature of 1-3 parties. The documents are protected. Can anyone offer a good suggestion on how to set up the documents so that multiple users can specify how many signature lines they need in a contract. We must keep the documents protected.
  4. eBartlett

    Conditionally format adjacent column

    Any ideas on how to conditionally format an adjacent column? I need to remind users to fill in, say, column D, if column C contains the word "NEW". I could use an IF statement, but I prefer to use conditional formatting to highlight the cell. Any thoughts? Many thanks.

Part and Inventory Search

Back
Top