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 John Tel 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: dburks1
  • Content: Threads
  • Order by date
  1. dburks1

    How to retrieve the latest file saved

    I have created a script that saves the curent workbook to my temp. drive. After this action is perfromed I then start Outlook and scripted the email and distribtution list for the appropriate reciepiants of the report. My question is since the file will be the latest file saved in the temp...
  2. dburks1

    How to address a defined column

    I am moving columns from one worksheet to another. In doing so I am using the scrip to copy the entire column. ColumnsToCopy = Array("State", "City", "Address", "Phone") Set SourceSht = ActiveSheet Set newWbk = Workbooks.Add Set NewSht = newWbk.Sheets(1) NewSht.Name =...
  3. dburks1

    Save a file as previous months date

    I am trying to create a script that will allow for me to to save a file as the previous month and also display the corresponding year. The script that I have below is getting me close to what I want but its saving the file as the current month. I know that what I have below isnt going to yield...
  4. dburks1

    How to copy certain columns in excel

    I have a worksheet that has almost 50 columns and the list is forever growing. For reporting reasons I only need to use some of the columns. Does anyone know of a script that will allow me to indentify the columns that i want to keep and delete all of the other remaining columns? For example...

Part and Inventory Search

Back
Top