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!

  • 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. Junior6202

    Loop through cells copy and paste

    I initially tried that but it does not work. It give me an error that says " That command cannot be used on multiple selections" that's why I thought maybe some vba code would work.
  2. Junior6202

    Loop through cells copy and paste

    Hi All, I am new to VBA and I want to performed this task: I have two columns in excel A and B. I want to loop through column B and If cell its not Null copy the data and replace the data in the cell in column A. of course if it was only a few cells I would do it manually but I have a few...
  3. Junior6202

    String or binary data would be truncated.

    I'm new to Sql but I understand the basics and maybe a bit intermediate. I wrote this query to pull some information involving 3 tables dbo.NewFamNbrs$, dbo.CGIItemMaster and dbo.CGIFamilyMaster. In addition I want to perform an update statement to update column dbo.CGIItemMaster.FamilyIDX with...
  4. Junior6202

    Restart and auto log in

    HI All, I'm new to VBScript and was wondering if any one can guide the right direction. I want to write a script that will restart windows 7 and auto log in with a specific user and password. Any help is appreciated. Thank you
  5. Junior6202

    Loop through files

    Hi all, I found a script that I had modified a bit. The purpose of this script is to convert ".csv" files to Excel. The code works, but there are 600 csv files in the folder, I know that I have to set a loop to go through each file and convert it. I have the basic idea of what a loop does but...
  6. Junior6202

    CSV conversion to Excel

    Thank you for the Response SkipVought but I figured it out. I just used a wildcard in the .InitialFileName = "P:\test\*.csv".[bigsmile]
  7. Junior6202

    CSV conversion to Excel

    Hi all, I'm fairly new to Vbs and I have a script that takes a particular csv file and converts it to excel. The problem is that the cvs file is automated and it always have a different name. I'm setting this script to run automatically so is there a way to set the .InitialFileName to pick...

Part and Inventory Search

Back
Top