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 Chris Miller 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. arv1111

    Activate Excel built in Data Entry Forms whilst Linked / in Range mode

    Hi Hoping someone can assist. I have exported some data into Excel from Sharepoint. I have not yet unlink or convert to range. I know if i unlink or convert to range mode, i can bring up the forms by the following code: ActiveSheet.ShowDataForm Is there anyway of bringing up the form without...
  2. arv1111

    Excel Problem

    Hi guys Tried it but didnt work. Not sure if i missed something. This address is all in one cell. Say A1. 24 Boku Street Palm Beach Abcccc 21500 Tel: (00)00000000 When tried to convert text to column, it only picks up the first line - 24 Boku Street. Thanks. Regards, arv1111
  3. arv1111

    Saving Files - Date

    Hi I was wondering if someone might be able to help out. 1. I'm wanting to create a macro to save a file with todays date. File Name - AAA.xls In one of the cells, I have the formula =now() that basically shows current date whenever you open the file. I will set the directory for the files to...
  4. arv1111

    Changing File Names

    I'm trying to remove all non-readable characters on all my files (in one folder) in windows explorer. Is there anyway I can remove all of them at once? Thanks. Regards, arv1111
  5. arv1111

    Excel Problem

    Hi Gavona Thanks for the advice. Is there an alternative method? Thanks. Regards, arv1111
  6. arv1111

    Excel Problem

    Hi guys I need some help with one of my files. Cell A1 shows the following information:- Xantra Miggie 24 Boku Street Palm Beach Abcccc 21500 United States Tel: (00)00000000 1. How do i leave just the name in cell A and move the other info from 24 Boku Street to Cell B1. I need it to perform...

Part and Inventory Search

Back
Top