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

2014-02-23 Thread Rupesh Patil
Dear Ravinder, Thanks your quick reply. I got same error. at ufmailfrom.Controls(cntrl.Name).Value = ufmailfrom.cb_all.Value line Run time error 380. On Mon, Feb 24, 2014 at 10:40 AM, Ravinder wrote: > PFA. IF HELPS > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegro

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

2014-02-23 Thread Ravinder
PFA. IF HELPS From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rupesh Patil Sent: Saturday, February 22, 2014 4:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dependent Combo box Hi Expert, I need your help, I have one multipage

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

2014-02-23 Thread Rupesh Patil
Dear Ashish, Thanks you very much. I tried you code and I got this run time error "Run time Error '380' could not set the value property. Invalid property value". could you please assist me why this error come. Thanks and regards, Rp On Sat, Feb 22, 2014 at 7:13 PM, ashish koul wrote: > Priv

$$Excel-Macros$$ VBA Code to access pictures from drive C

2014-02-23 Thread Hilary Lomotey
Hello Experts, embedding pictures in excel sheet can take a lot of size so i need an assistance with a code to access pictures based on a drop down selection. ie assuming i have a combo box with three names a, b and c, if i select a i want to link it to a particular picture on the c drive. kindl

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

2014-02-23 Thread Shankhajit Srimani
Ashish, Thanks a lot for the help. This does 90% of what I am looking for. This is awesome and thanks yet again.. However, I require a little more help from your end please, if possible. How do I get some form function (like a button) to trigger popping up pop up box which will ask for a date ra

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

2014-02-23 Thread ashish koul
http://www.myengineeringworld.net/2013/11/excel-vba-download-internet-files.html http://www.lazerwire.com/2011/11/excel-vba-download-files-from-internet.html http://www.cpearson.com/excel/downloadfile.aspx Declare Function URLDownloadToFile Lib "urlmon" Alias _ "URLDownloadToFileA" (ByVal pC

Re: $$Excel-Macros$$ Study material for LOOPS

2014-02-23 Thread xlstime
Please check below link http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=122:excel-vba-loops-with-examples-for-loop-do-while-loop-do-until-loop&catid=79&Itemid=475 . Enjoy Team XLS On Sun, Feb 23, 2014 at 11:42 AM, suresh k wrote: > De