Actually collection it’s just like an array you can store values in collection
object and there is a feature to give name of store value (position) and it
takes only unique names (name of element should not be duplicate otherwise it
will hit error. See below
Sub colexample()
Dim coll as new
Hi Ravinder sir,
Can you please explain about the collections and below line of code how it
works ? Becoz im not familiar with collections
For i = 2 To ws.Range("g1").End(xlDown).Row
col.Add ws.Range("g" & i), CStr(ws.Range("g" & i))
Thanks & Regards,
Ganesh N
On Tue, Apr 22, 2014 at 11:52 AM,
Hi Gupta,
Please find the attachment.
Thanks & Regards,
Ganesh N
On Tue, Apr 22, 2014 at 11:43 AM, Ravinder wrote:
> Pfa,…first click on button and then select where u want to save file.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *kapi
Pfa,…first click on button and then select where u want to save file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of kapil Gupta
Sent: Monday, April 21, 2014 8:48 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need new Workbook create us
Hello Experts,
I need your help, I need to convert Json(output return from webservice) to
Array.
following is json output
[["A","string",0,"NULL"],["B","string",0,"NULL"],["C","string",0,"NULL"],["D","string",0,"NULL"],["E","string",0,"isemail"],["F","string",0,"ismobile"],["G","string",0,"NULL"]
Dear Kapil,
Please see the attached.
This will create workbooks, paste filtered data and save them as per the
name column (Col G).
*Keep in mind the following:*
a) The new excel files will be created in the same folder* where you have
saved this file*. So, when you download this, save it in a f
in excel 2010 and above calender control has been removed so you will not
find it
On Tue, Apr 22, 2014 at 7:01 AM, Falina Gan wrote:
> To Ashish,
>
> The article is for Windows XP and Office 2007.
>
> Do you have the experience in Microsoft Office Standard 2010- 32 bit?
>
> Hope to hear from yo
To Ashish,
The article is for Windows XP and Office 2007.
Do you have the experience in Microsoft Office Standard 2010- 32 bit?
Hope to hear from you soon.
Thanks.
On Friday, April 18, 2014 1:47:34 PM UTC+8, Falina Gan wrote:
>
> To Whom It May Concern,
>
> May I ask, why can;t we click the
Hi,
Kindly solve this query.
1. I have attached one sheet all data in sheet according by name
2 need create new workbook using macros according by name wise.. Means
Name is A then should be Create workbook A and other is B then create other
workbook Name is B. and data also Assign in nam
Pls share ur cv
Sent on my BlackBerry® from Vodafone
-Original Message-
From: kapil Gupta
Sender: excel-macros@googlegroups.com
Date: Mon, 21 Apr 2014 04:00:54
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon
Hi,
I am look
Hi Ashish,
It's not working.
On Friday, 18 April 2014 15:04:40 UTC-5, ashish wrote:
> try this
>
> http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3487-Automating-Out-of-Office-in-Outlook.html
>
>
> On Fri, Apr 18, 2014 at 10:52 PM, Bv Dileep
> > wrote:
>
>>
But what is the password in this code. Please reply
On Saturday, March 22, 2014 7:03:12 PM UTC+5:30, renuka chari wrote:
>
> Dear Deepak,
>
> thanks for your great help... it would be working so great...
>
> but i was found a small problem from Output 2 here i am getting positive
> values twice
Hi,
I am looking for the job in Data analysis profile and i have expericenced
in Excel, vba and access and basic knowledge of Sql.
Regards,
Kapil
On Friday, October 28, 2011 9:36:28 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> E&Y(Gurgaon) looking out for VBA professionals with 1-
Thanks Ravinder
your quick reply, I tried your suggestion but I got compile time error,
Expected : end and statement
On Mon, Apr 21, 2014 at 3:03 PM, Ravinder wrote:
> You have to give ; in double quote lik e ”;”, you gave without double
> quote (pass ;)
>
>
>
> *From:* excel-macros@googlegrou
You have to give ; in double quote lik e ”;”, you gave without double quote
(pass ;)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rupesh Patil
Sent: Monday, April 21, 2014 2:53 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ concatenat
Hello Expert,
How to invoke webservice with username and password VBA micro.
Please help me out, I am using following code
Dim MyRequest As Object
Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
MyRequest.Open "POST", "
http://192.168.1.111/ayushman/ws/validate
16 matches
Mail list logo
