$$Excel-Macros$$ Macro to Download csv file from a dynamic date based url to a specified file location

2014-02-22 Thread Shankhajit Srimani
Hi, I have a requirement to download a lot of historical data files from the archieve of an website. The url goes something like this: *http://nseindia.com/content/nsccl/fa...i_21022014.csv* This downloads file for 21022014 ie

$$Excel-Macros$$ Study material for LOOPS

2014-02-22 Thread suresh k
Dear Experts, Anyone having study material for learning all kinds of LOOPS. Please do forward. Many thanks. /Suresh -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discusse

Re: $$Excel-Macros$$ Dependent Combo box

2014-02-22 Thread ashish koul
Private Sub cb_all_Change() Dim cnt As Control If Me.cb_all.Value = "Yes" Then For Each cnt In Me.Controls If TypeName(cnt) = "ComboBox" Then cnt.Value = Me.cb_all.Value End If Next End If End Sub On Sat, Feb 22, 2014 at 4:50 PM, Rupesh Patil wrote: > Hi Expe

$$Excel-Macros$$ problem with for loop

2014-02-22 Thread ravi
I am strugglig with the problem. Here is the image 1 after selecting one of element in listbox and then if I click delete material (commandbutton). It has to delete the select material in sheet 2

$$Excel-Macros$$ Dependent Combo box

2014-02-22 Thread Rupesh Patil
Hi Expert, I need your help, I have one multipage with 11 combo boxes. all combo box have same value, value are "Yes", "No", "Don't No". there is one combo box called "All" what I want is that suppose user select("Yes") value from "All" combo box, other combo boxes value should be same ("Yes") as

Re: $$Excel-Macros$$ Excel micro

2014-02-22 Thread Rupesh Patil
Thanks Ashish your replay. I have solved my problem. thanks again On Sat, Feb 22, 2014 at 3:32 PM, ashish koul wrote: > can you share a sample file > > > On Fri, Feb 21, 2014 at 5:35 PM, Rupesh Patil > wrote: > >> Hi Expert >> >> I am trying to get multi select list box value into textbox

$$Excel-Macros$$ regarding working with web data through vba excel

2014-02-22 Thread Rajendra Prasad
Dear All, Let me know how to use google spreadsheet as a database and use all the function of database like add, delete, modify through vba excel. Thanks, Rajendra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

$$Excel-Macros$$ regarding topic for study in vba.

2014-02-22 Thread Rajendra Prasad
Dear all, i want to know what topic in vba excel one should study to get job in vba profile. Thaks, Rajendra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel micro

2014-02-22 Thread ashish koul
can you share a sample file On Fri, Feb 21, 2014 at 5:35 PM, Rupesh Patil wrote: > Hi Expert > > I am trying to get multi select list box value into textbox with comma > separated and I am using following code. > > Private Sub List_Food_Change() > Dim item As Integer > Dim listitemvalue