Search the Community

Hi Guys, I'm trying to move away from Task Scheduler as my trigger for opening an Excel file. The problem there is it has a minimum of 5 min interval (I need at least 30 sec) and If the process of the initial instance of the Excel file is longer than the usual that after 5 min another instance executes it messes up my memory bandwidth. What I want is to use VB Script that first check if a particular Excel file is open if yes then wait for another 30 sec to check.Question: What is the right syntax/code for detecting a specific Excel file and loops every 30 sec. But I also want to be able to end the loop if I want to.Here is my current code: Gateway TimeoutRequestURI=http://timeentry/Set Recordset = CreateObject("ADODB.Recordset") ConnString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=PHMNWWKS027604; DATABASE=db_skusetup; " &_"UID=root;PASSWORD=; OPTION=3"'Check for Export Query'Recordset.ActiveConnection = ConnString exportSQL = "SELECT * FROM tb_queue_export WHERE request_status = 'Pending' ORDER BY request_id DESC LIMIT 1"Recordset.Open exportSQLSet objExcelExtract = CreateObject("Excel.Application")Set objWorkbookExtract = objExcelExtract.Workbooks.Open("C:Usersushuam00DesktopLAPTOP.xlsx") If objWorkbookExtract.ReadOnly then if Recordset.Fields(3) <> "" then end if end iftest= MsgBox(Recordset.Fields(3),3,Recordset.EOF)Recordset.Close ReadOnly is not doing it for me.

Hey guys. Hope everyone here had a great 4th of July holiday! I am building an internal site that of course is only accessible via intranet. Its primary coding is very simple. Its HTML based with some Javascript and some VBScript. I will be honest. I am not an expert programmer by any means. So here is the issue. We have no access to the server logs as we do not admin the logs nor are we allowed to request them. We are basically borrowing the space. My management wants to have each page, when accessed or clicked on (either one) to log the hit to a csv file and a txt file saved on the server. I know a lot of people dont think VBScript is the way to go. This is what is needed in each column in the log: Date\Time stamp \ Hostname \ NT Login \ Page that was loaded We are in a Windows XP\7 Environment. We know this server supports IIS. We are also currently using SSI for our DHMTL menu. I was hoping someone could help me use the DHTML menu as an "onclick" so that any option clicked on the menu by the client would log the above information to a specific file. We are very limited on the access we have on the server. I am not very skilled in VBS at all and this is simply a last minute side project they want to test out. So if someone could help me with this that would be excellent. Thank you in advance.