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 derfloh 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: arv1111
  • Content: Threads
  • Order by date
  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

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