Vbscript Update Mdb File' title='Vbscript Update Mdb File' />Using vbscript and setting an ADO recordset to a variable.I have a lot of PDF files I am trying to rename based on criteria found in an excel spreadsheet.The spreadsheet lists the ID, last name, first name.Smith Joe.I can open and read from excel fine and can create the ado connection and get a response to my query, but cannot find a way to take the part of the recordset that contains the filename and save as a variable.The code I am using updated to current codesetOn Error Resume Next.Becky Brogan The Mystery Of Meane Manor Final Cut '>Becky Brogan The Mystery Of Meane Manor Final Cut .Letter. Directory Input.BoxWhat letter are we scanning.Directory.Location C CLNotes.Letter.Directory UCaseLetter.Directory.Sub. Directory Directory.Location Letter.Directory.Full. Directory Directory.Location Letter.Directory.Creating Excel objects.Set xl Create.ObjectExcel.Application.Set xl.Book xl. Workbooks.Openc CLnotesdboPatient.Set xl.Sheet xl.Book. WorksheetsLetter.ASP.NET Tutorial asp.Directory.Visible True.Rows xl.Worksheet.Function.Count. Axl.Sheet.RangeA A. Filename 0.For xl.Row 1 to total.Rows.Last. Name xl.Sheet.Cells. Itemxl.Row, 2. Microsoft Office 2003 Professional Swedish Firestorm Server here. First.Name xl. Sheet.Cells.Itemxl. Row, 3.Full.Name Last. Name Firstname.Filename xl.Sheet.Cells. Itemxl.Row, 1.Text. Full.Name b lorraine.Set obj.Connection Create.ObjectADODB.Connection.Set obj.Record. Set Create.ObjectADODB.Recordset.Vbscript Update Mdb File' title='Vbscript Update Mdb File' />Connection.Open ProviderSearch.Collator.DSO Extended PropertiesApplicationWindows.Record.Set. Open SELECT System.File.Name FROM SYSTEMINDEX WHERE Contains Full.Name, obj.Connection.Record.Set. Move.First. Filename obj.Recordset.Fields.ItemSystem.File.Name. Do Until obj.Recordset.EOF. Wscript.Echo obj.Recordset.Fields.ItemSystem.File. Name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |