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 Mike Lewis 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: *

  1. eBartlett

    Text File Drops Leading Zeros

    We have just been importing the data as a text file. I have a reference book on data parsing in VBA. Your comments will help me. Thanks.
  2. eBartlett

    Retrieve User Name

    Same question, new twist. How do I get this information into the footer of all worksheets? The user may add worksheets and I want to make sure the username is captured on all of them? My macro appears below: Private Sub Workbook_Open() Worksheets("Event...
  3. eBartlett

    Retrieve User Name

    It works! THANKS!
  4. eBartlett

    Variable Fields in Word

    Good idea, and I like it, but as a newbie, I would be looking for the syntax to help me do that. Also, aren't the macros stored on the C: drive? I think I would need to put the macro on each individual's PC.
  5. eBartlett

    Variable Fields in Word

    Yes, We need one signature line if one individual is to sign, two signature lines for two individuals, etc. Currently we need to stop what we are doing and unprotect the file for users. We cannot give them the password.
  6. 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...
  7. 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?
  8. 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.
  9. eBartlett

    Conditionally format adjacent column

    That worked. Thanks! Great feature.
  10. 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