Search results for query: *

Thank you for all the help.

Hey Skip... I receive an error: Compile Error Method or data member not found - on line wsSample.Save

In new Workbook named Sample.xlsx, I want to run the macro that will take the data from all the workbooks in the folder c:\Test from Columns A2:A22 and D2:D22 and paste it into the Sample.xlsx.

One time... there maybe more than one file but files are named with a datetimestamp at end

Folder Path: C:\Test Excel file name: test.xlsx Columns A2:A22 and D2:D22 Want to take the data from those columns and put it into a new xlsx

The record pulled from the recordset is all on one line... I am trying to make the text more presentable...

I am currently using replace function to add a new line after each "." but will be more presentable if there is a new line after every 5 words? How can I add a new line after every 5 words?

My string contains: The dog walked across the street. How can I parse this string and only return walked across .. Take only words between dog and street.

String contains a value in HTML format. The value is an email. The value contains tags such as <P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><o:p><FONT face ... I was able to remove the HTML format, but I end up losing the format in general. The email will show on one line, etc... Any...

UpdateCommand="UPDATE [Table1] SET [SEQ_NUM] = ?, [RECORD_IND] = ?, [UFC_ID] = ?, [Parameter_Value] = ?, [Start_Date] = ? WHERE (([Parameter_Name] = ?) OR ([Parameter_Name] IS NULL AND ? IS NULL)) AND (([SEQ_NUM] = ?) OR ([SEQ_NUM] IS NULL AND ? IS NULL)) AND (([RECORD_IND] = ?) OR ([RECORD_IND]...

I am experimenting with Visual Studio 2015. I created a webform in which contains a datagrid. I have enabled Edit and Delete on the grid. When I select PREVIEW IN BROWSER option, the page loads with the datagrid returning the correct data. I have two links in the grid Edit and Delete. I select...

Yes, the VBS is being run on the server

How can I pass a session variable into a .vbs file

Ticket Resolved - ran this code from ASP: <% Dim objShell Dim vbsFile vbsFile = Server.MapPath("Example.vbs") Set objShell = Server.CreateObject("Wscript.Shell") objShell.Run vbsFile Set objShell = Nothing %>

Your absolutely right Skip - I was not aware of the "star it".. my apologies and thanks for the heads up

I have a web page and when the user loads the page it displays the name attached to the PC - the Control Panel\USER ACCOUNTs info

Using asp how can I execute this command: c:\Windows\SysWOW64\wscript.exe "C:\Test.vbs

I am able to successfully execute the following code as an excel macro. However I wanted to be able to run this code using vbscript. When I run this from my html page I encounter: Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'TDApiOle80.TDConnection' on...

I want to find duplicate dates for a specific book rental:

How can I check to see if the Date Modified in for a specific file name is yesterday... For example: File Name Date Modified Test3.txt 2014-07-28 Test2.txt 2014-05-08 Test1.txt 2014-01-01 IE: LAST modified date for files starting with Test...