vbscipt

Hi! I need a vbscript to reopen a spreadsheet when it closes and refresh the document every minute. I have tried using task scheduler but it wont work because I dont have admin privileges. Thanks for your help! :) Regards, Rochelle

Hi, I am facing problem for Task Scheduler to run a excel macros. When I run the Vbscript in Task Scheduler, the status shows running but nothing happen. I open the excel file manually and it shows below reasons, so i have to end the excel using task manager to let me access to the file again...

Hi, Could anyone please help me figure out what is wrong with below VBScripting and how do I correct it? It meant to 1) Open excel -- works 2) Refresh all data -- works 3) Remove external connection -- Dont work 4) Save as new file without any external connection -- Dont work due to 3rd step...

Hi Everyone, I Want to Split the column(or From Cell to the down) with the available text in the cell. I want do it without merging other columns. I hope following image can explain my concern. is there any way to do it?

We are trying to write a script that opens Internet Explorer into a webpage that acts like a DOS screen. We then need to begin typing into said webpage. Below is the beginning code we have managed to make but it does not make the IE screen the current active screen to begin typing into and we...

i am trying to get a excel result in a proper format but i am so confused in the looping and the condition and tried all night long and still not able to figure it out. Easy structure but complex coding, If possible it would be better if the code is VBscript friendly. Thanks Actual table from...

I have a problem, my users are missing on selecting a dropdown while working on a website (Intranet). I was looking for a macro which is continuously running, when a browser is selected by the user and clicks on "Complete Task" the macro must prompt the user that the Dropdown was not selected...

Hi, I have ID(Col A),NAME(Col B) and STATUS(Col C) Column in Sheet1. In Sheet2 NAME(Col A) and STATUS(Col B) columns are existing. My requirement is, i have to compare sheet1 column A and B with Sheet2 Column A and B. If it is match then Sheet1 Col A value should be populated in Sheet2 Col C and...

I have multiple MDB's files in a Windows folder named 'Results' MDB1.MDB , MDB2.MDB , MDB3.MDB .... MDBx These are Quotation results from vendors. Each MDB has the same Query 'Q_Total_RFQ'. The query has three columns: "RFQ" , "Vendor" , "Total" Now what I need is to run a script or macro...