-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vbscipt
-
R
Task Scheduler fail to open excel and run macros
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...- RoeyJia
- Thread
- excel macros outlook task scheduler vba vbscipt
- Replies: 0
- Forum: Excel Questions
-
R
Open file, delete connection and save as
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...- rins
- Thread
- vba vbscipt vbscript/macro
- Replies: 3
- Forum: Excel Questions
-
P
How to Split Single column from specific Row?
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?- pradee
- Thread
- excel excel & formula excel & vba vba vbscipt
- Replies: 3
- Forum: Excel Questions
-
T
VBS newbies...
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...- torilitzau
- Thread
- active window add text screen vbs vbscipt
- Replies: 0
- Forum: General Discussion & Other Applications
-
N
Looping through the excel cells
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...- nisdey
- Thread
- end lentextline midtextline vba & excel vbscipt
- Replies: 1
- Forum: Excel Questions
-
A
Macro that can Stop/alert user if a Dropdown is not selected while working on a website
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...- aryan_vivek
- Thread
- macro - auto run vbscipt
- Replies: 0
- Forum: Excel Questions
-
V
Compare two column values in different sheet and populate Sheet1 Column A values in Sheet2
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...- Vinothkumar
- Thread
- excel & vba vbscipt
- Replies: 2
- Forum: Excel Questions
-
M
import query results from multiple access files into excel
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...- miky011
- Thread
- aceess exel import import data by vba query vbscipt
- Replies: 1
- Forum: Excel Questions
