$$Excel-Macros$$ Cell Reference ( automatic Updation on Date Change)

2011-01-23 Thread kush sharma
Dear All, I have a query in which i need your help. Lets Say, I am using an Excel sheet which has got multiple sheets inside it and a master sheet. Each Sheet is made for a different item that i sell. It has got colums such as Closing Balance(Yesterday), Inward and Outward and daily closing balanc

Re: $$Excel-Macros$$ Re: Refreshable Web Query

2010-11-11 Thread kush sharma
___ > Thanks & Regards > Ashish Jain > McKinsey India Knowledge Center > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > > > > >

$$Excel-Macros$$ Refreshable Web Query

2010-10-13 Thread kush sharma
Heloo Everyone, I have this problem whenever i try to create a refreshable web query. As soon as i eneter the link in the web address bar the window appears which asks something like "this page contains a script, do you wish to continue?" now i do click yes, but this message appears again so fast

$$Excel-Macros$$ VBA for downloading a file

2010-09-06 Thread kush sharma
is there any VBA for downloading a particular file from a website and downloading it at a specified location?? if anyone can just explain it through a simple example, I'd be glad. -- * Regards Kushlesh Sharma * -- * Regards Kushlesh Sharma Research Analyst Swastika Investmart Limited Email: