Tagged Questions
1
vote
1answer
300 views
Copy data upto last used Row of a specific column
I am using this code to get the last used rows-
rowNo=objExcel.Activeworkbook.Sheets(1).UsedRange.Rows.count
Now, i want to copy the data of a specific column upto last row used.
//What to write in ...
1
vote
1answer
975 views
Excell VBScript: copy value from another document
Let's say we have work1.xls and work2.xls
In work1 we have column A filled with Names and B with numbers
In work2 we have column with same Names (but more of them and in randomized order) and numbers
...
1
vote
1answer
598 views
How do I execute my vbs file that has VBA code in it
This is my vbs file
Sub Macro1()
Workbooks.Open Filename:= "C:\Documents and Settings\DELL.PGDM\Desktop\rett.xls"
some VBA excel code here goes like sorting and filtering
End Sub
How do ...
0
votes
1answer
61 views
Get Row number of excel using ADO
We are trying to get the row number of particular recordset retreived based on soome condtion. consider below table
Name Id
abc 1
cde 2
efg 3
Now, how to get the row number or ...
0
votes
1answer
161 views
How can I read Excel file row by row and send email to the names on the worksheet?
We have an Excel file called empList.xlsx with a list of users whose servers are very close to running out of space.
The email is intended to advise users of the current space status and to delete ...
0
votes
1answer
246 views
Excel Pivot table creation through vbscript
I have a requirement where I set up three pivot tables created from the same sheet #3. Now the sheet #3 is also getting populated with the data from sheet#1 and #2. every new population of sheet first ...
0
votes
1answer
112 views
Excel null date columns are needs to be updated by ADODB and vbscript
I am working MS Excel-2010.I have an excel sheet like below:
Process# requirementrcvd designdate codingdate test1 date test2 date deliverdate
11 10/11/2009 ...
2
votes
0answers
438 views
Excel worksheet - if the column contains X then copy the row and all rows with the same word in column A to sheet 2
The current code copies content from sheet 1 to sheet 2 if X and from sheet 1 to sheet 3 if Y. I need it changed so that if a row in column B = X it copies every row that has the same word in Column ...
0
votes
0answers
45 views
VBA Proxy settings for a non admin
At the moment i'm using the following code :
strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & ...
0
votes
0answers
305 views
If value equals x,y,z then copy paste the row to new sheet
I have excel sheets with values x,y,z in an unordered manner (x,y,z will be in different rows in different workbooks). I would like to do the following,
If value equals x,y,z then copy paste the row ...
0
votes
0answers
87 views
Get HTTPS SSL Certifiate expiration date
Is there any option to get the expiration date of ssl certificate?
For example we have a website: https://superbank.comm
So the connection is using certificate. You can see the expiration date in the ...
0
votes
0answers
43 views
Is there any Collection objects available which has Copy method?
Suppose I have an ArrayList as below :
Dim ArrayListTaskDetails
Set ArrayListTaskDetails = CreateObject("System.Collections.ArrayList")
For RowCount=2 To ...
0
votes
0answers
172 views
Date - time format issue in excel using VBScript
The following code i am using to calculate the durations between time say -11/13/2012 11:21:41 AM and #11/14/2012 2:32:59 PM# and the function producing the correct output: 1:03:11(dd:hh:mm).But now ...
0
votes
0answers
218 views
VBScript - Error: Can not access read-only document
I'm trying to write a VBScript that collects basic system information and writes the data on an excel file. When executing, I get the below error message,
Microsoft (R) Windows Script Host ...
0
votes
0answers
181 views
Generating and loading an excel (.XLS) file using VB Script in DTS package
I want to load the excel file with database data.So i created a DTS package which transfers the data from database to excel(.xls) file.Since DTS accepts only .xls extension files, i am planning to ...
