Hi Excel Gurus,
I have been working with excel,VBA, C++ for 2 years. lately I have come
across this task where I need to download this excel sheet from web page. I
have no idea how to automate the downloading .Can some gurus give some tips
and help? any advice is welcome.
The web page
Hi
I am using vba and Reuter data everyday. I didn't get your question that
clearly.
normally I would use =RtGet(IDN,RIC,FieldName) to get live market
data.
I've never use application.evaluate(RIC) ...what is for?
On Thu, Aug 27, 2009 at 10:15 AM, thedoc brooks...@googlemail.com
independence day? which country ?
On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan dppin...@gmail.comwrote:
Wishing you all a very happy Independence Day.
Thanks Regards,
Dhananjay
--~--~-~--~~~---~--~~
,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On Mon, Aug 10, 2009 at 3:12 PM, zheng yu vincent2...@gmail.com wrote:
Dear all,
Please take a look at the spreadsheet. I extract these three
columns from database, then the second
I didn't get this the meaning of this sheet..what am i supposed to do with
it?
On Wed, Aug 12, 2009 at 2:22 PM, Iqbal Shaikh iqbal.sw...@gmail.com wrote:
Friends
Can u solve this logo quiz?
Iqbal S
--~--~-~--~~~---~--~~
you mean progress bar?
On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal
vivek.agrawa...@gmail.comwrote:
Hi ALL
Can any body help me create a progress reporter or if someone has it
or if someone has build on his and he is willing to share that... then
PLEASE do... Your help would be
use GOTO
there is no statement such as Continue in VBA
for i=1 to 1000
if i=5 then goto NextLoop
' other code
NextLoop:
next i
On Wed, Jul 29, 2009 at 2:47 PM, vivek agrawal vivek.agrawa...@gmail.comwrote:
Hello Kumaran
Exit For would completely exit from the for loop..
i want it
Hi Marty
I think uplaoding the file to FTP server is not within the range of Excel
vba work. it is the FTP client that does this.
1) You should have a FTP client that uploads files to server.
2) There is auto-update function in the FTP client . so once you point the
folder where the file is,
Hi
sleep 100 is not that good in that it freezes EXCEL completely.
A better alternative is Application.onTime now+timevalue(00:00:10)
you can find detailed documention on Excel Help
On Tue, Jun 30, 2009 at 5:21 PM, Sandeep sandymau...@gmail.com wrote:
Hi Anil,
I don't know much
, but hidden
References are DLL's.
I'm sure there are LOTS of other differences, but this works for me!!!
hope this helps,
Paul
--
*From:* zheng yu vincent2...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Monday, June 15, 2009 6:14:36 AM
*Subject
You can simply use record macro and do all the process through,then you
get it in VBA. You can see the VBA code in VBE editor
On Mon, Jun 8, 2009 at 2:36 PM, Philippe lamy.phili...@gmail.com wrote:
Hi,
here is my problem. I would like to click on a button in my worksheet
and doing so
Hi Dave,
Thanks for your share.
This is one of lines I used a lot as well. The only drawback of this is
that you need to give it the number of Column. Most of times, it is more
easier to give the Column Name,like A instead of 1 when it reaches beyond
AA 'cos you need to count the number
this runs for me as well..my version is 2007
On Wed, May 27, 2009 at 7:22 AM, ddadmin2009 ddadmin2...@gmail.com wrote:
this runs fine for me and does not require any extra reference library.
can u tell me your excel version n browser u have.. make sure u have some
data in column A... i don't
Any guy here tried to build a COM or .NET library for EXCEL?
Some calculation takes huge amount of time in VBA, so i am thinking using
C++ or C# to do the calculation and VBA just calls this add-in class to do
the job and get the result .
On Thu, May 7, 2009 at 6:42 PM, Ajit Navre
Hi Paul,
I don't wanna copy the formula, just wanna copy the text after =.
Sometimes there is a long string after =, and I wanna copy that string
instead of typing it at other place:) If there is not shortcut, is there
any way at all..hehe
Well, regarding Ctrl+D : If there is
Precise! Very useful !
when I export a Date (appears as a Date format) to XMl..why it appears as
a number 39919.375.any idea on that?
On Tue, May 12, 2009 at 2:15 PM, Paul Schreiner schreiner_p...@att.netwrote:
First, I want to remind you that the date/time isn't being stored as a
Hi Dilip,
Thanks for your explanation.Great!
On Tue, May 12, 2009 at 4:59 PM, Dilip Pandey dilipan...@gmail.com wrote:
Hi Yu,
For copy purpose, you can simply copy the formula and then you can replace
(Ctrl +H) the = sign with .
Now moving over to your second question:-
Ctrl + D - it
at 5:13 AM, zheng yu vincent2...@gmail.com wrote:
Can anyone explain a bit principle and ways of BREAKING passwords?
On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati kamalgula...@gmail.comwrote:
Plz help me to crack the password for MS - Word.
Thanks and regards,
Kamal Gulati
On Mon, May 4
Can anyone explain a bit principle and ways of BREAKING passwords?
On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati kamalgula...@gmail.com wrote:
Plz help me to crack the password for MS - Word.
Thanks and regards,
Kamal Gulati
On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte
Hi Walid,
you can use Data-Validation to do that. Check Help on Validation
On Thu, May 7, 2009 at 9:09 AM, Mr Walid Zahran walid...@gmail.com wrote:
Hi Group;
I'm new to MS EXCEL AND VBA MACROS. I want to know how to insert a
ListBox into a Cell.
I need it to be visible ony when this
Yes..it works! Thanks
On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos flnle...@gmail.com wrote:
You will need to use the indirect formula, which converts an addres to
a reference
=indirect(b1 c1)
Regards!
Fabio L. Lemos
cel.: 8122-1206
Em 06/05/2009, às 11:34, Yu vincent2...@gmail.com
more tips on Command line:
start a new Excel session:
call C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
Q:\Summit\Prod\Excel\test.xls
start a workbook in existing Excel session
call Q:\Summit\Prod\Excel\test.xls
But any one knows how to save or close or other manipulation on Excel
Hi Ajit,
This is so helpful and informative! I really appreciate all the replies
from ppl in his forum.
I used a lot of VBA ,but not that much built-function. But now I know a
powerful tool
Thanks again for everyone
Vincent Zheng
On Fri, May 1, 2009 at 3:26 PM, Ajit Navre
Hi Shay,
you can copy this and paste in your workbook_open() event. This should
meet what you want
Private Sub Workbook_Open()
Dim RemindTime As Integer
Dim B As Boolean
Dim C As Boolean
RemindTime = 5'set to whatever days
Hi Hari,
Can you drop me some tips on breaking the VBA password ? some previous
employees have wrote some vba codes ..but they are password protected..and
we are not able to contact them.Thank you.
Kind Regards
Vincent Zheng
On Fri, Mar 20, 2009 at 6:49 AM, hari prekkeh...@gmail.com
Hi Alokeshwar Tiwary ,
can you explain what is [F17] mean here?
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
[F17].Activate
End Sub
On Sun, Mar 29, 2009 at 1:52 PM, Alokeshwar Tiwary
alokeshwar.tiw...@yahoo.com wrote:
Though it looks like flash or something but its not. There
Hi Vinu,
thanks for your post..but I don't get the Sumproduct
function..=SUMPRODUCT(($A$1:$A$9=F4)*($B$1:$B$9=G4))
what puzzles me most is (($A$1:$A$9=F4) ...I have never seen such an
expression..can you please explain it.what is the result of that
expression..
and I change the
This one is awesome! Thank you Mudassar!
On Thu, Mar 26, 2009 at 1:14 PM, Mudassar Ramzan johnplaye...@gmail.comwrote:
Pl find the attachment.
Thanks regards,
||* **M**udassar Ramzan** *|* **MIS Officer** **|* *WorldCALL Telecom Ltd*
*|** 061- 814-3999 *|* 0321 7325277 **||*
Hi Mudassar,
while I am looking at Drill bit equivalence sheet, I noticed that you
have some drop-down llist/combo box..I wanna know are you using Validation
list or the Active Object Combo Box... and where you put the values that
displayed in the drop down list..I didn't find the values on
29 matches
Mail list logo
