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 wrote:
>
> Hi,
> I'm lo
independence day? which country ?
On Sat, Aug 15, 2009 at 10:19 AM, Dhananjay Pinjan wrote:
> Wishing you all a very happy Independence Day.
>
> Thanks & Regards,
> Dhananjay
>
> >
>
--~--~-~--~~~---~--~~
--
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 wrote:
> Friends
>
> Can u solve this logo quiz?
>
>
>
>
>
>
>
>
> Iqbal S
>
> >
>
--~--~-~--~~~---~--~~
-
lease mention the return format...
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com - Saving energy-Save Earth
>
>
>
>
> On Mon, Aug 10, 2009 at 3:12 PM, zheng yu wrote:
>
>> Dear all,
>>
>>
>>
Super explanation !
On Thu, Jul 30, 2009 at 10:33 AM, Ajit Navre wrote:
> I think, it is due to the implicit conversion of constants in expression.
> In this particular case, both the quantities i.e. 4 and 1 are
> interpreted as integers. After multiplication, the result actually is 4
you mean progress bar?
On Thu, Jul 30, 2009 at 10:45 AM, vivek agrawal
wrote:
> 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 greatly appreciated...
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 wrote:
> Hello Kumaran
> Exit For would completely exit from the for loop..
>
> i want it to skip the code for th
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 wrote:
> Hi Anil,
> I don't know much about VB but you c
le will open as 'hidden' (like the Personal.xls file) and you
> can distribute IT
> to others. when THEY open it, a copy is moved to their add-ins folder and
> will open "hidden"
> whenever THEY launch Excel.
>
> So...
> the short answer to your question is:
&
Hi All,
I move some excel workbooks from computer A to another B. Computer A
has Bloomberg excel addin, but Computer B doesn't have, not even has
Bloomberg.
Strange thing is that now when i start any Excel session on Computer B,
the Excel has an Bloomberg add-in, although it doesn't work.
Hi All,
Can anybody tell the difference between add-in in sheet and reference in
VBA?
cheers
Vincet
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and
hmm..anybody can make the macro work in the original sheet?
On Fri, Jun 12, 2009 at 6:29 PM, zheng yu wrote:
> Hey guys thanks
>
> but ..I copy the code into new sheet, and it works perfect too.. it is just
> in that original sheet, it only works for 0 ,but rest of them..
>
&g
me
> Have you turnedmacros on?
>
>
>
> 2009/6/12 zheng yu
>
>> Hi All,
>>
>>I got this request from a colleague who is asking me to find out the
>> problem assuming i am the best VBA and C++ programmer here.;P
>>
>>But I can't fix it
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 wrote:
>
> Hi,
>
> here is my problem. I would like to click on a button in my worksheet
> and doing so opening a web query win
desn't work for 2007 though
On Mon, Jun 8, 2009 at 6:20 AM, Ramesh Katta wrote:
>
> Hi all,
>
>
> Name : Ramesh
> Subject : Open a workbook which has formule.
> Tip :Use Ctrl+` to see the all formule which are in the sheet.
>
> We use Ctrl+` to see the all used formulas in the current work
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 numbe
this runs for me as well..my version is 2007
On Wed, May 27, 2009 at 7:22 AM, ddadmin2009 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 have any error hand
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 wrote:
>
>
Hi Dilip,
Thanks for your explanation.Great!
On Tue, May 12, 2009 at 4:59 PM, Dilip Pandey 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 will copy
hahahaha...Ctrl+H again..hehe ,well it comes in handy:-)
On Tue, May 12, 2009 at 4:54 PM, Dilip Pandey wrote:
> Hi
>
> press Ctrl +H and replace "total charge:" with "".
>
> Thanks.
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...
Hi ,
I think the best and efficient way to learn is to buy a Excel 2003/2007
book and come to forum a lot. That is exactly how I started one and half
year ago.
On Sun, May 10, 2009 at 2:18 PM, bathina srinivasa rao <
ask_...@rediffmail.com> wrote:
> kindly help by sending Ebook on Excel.
>
>
Indeed insightful ! Thanks Paul
Just to give a hands-on example of Paul's explanation on converting number
to date using String. Here is how it is, i just tried:
Cell(A1) -- "12/05/2009 " This is a date format
Cell(B1) -- "=TEXT(A1,"MMDD")" ,then in Cell B2, you get the string
pr
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 wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores
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 fo
s
>
> Rishi Pathak
>
>
> On Sun, May 10, 2009 at 5:13 AM, zheng yu wrote:
>
> Can anyone explain a bit principle and ways of BREAKING passwords?
>
> On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati wrote:
>
> Plz help me to crack the password for MS - Word.
> Thanks a
trick question...don't know how to trigger action on ENTER...hmm.waiting for
info as well:)
On Thu, May 7, 2009 at 9:58 PM, Doug wrote:
>
> I've got an Excel spreadsheet that I'm going to use a wedge program
> with to capture data from an instrument and parse it into the sheet. I
> would like t
Can anyone explain a bit principle and ways of BREAKING passwords?
On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati 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
> wrote:
>
>> Install Ultim
Yes..it works! Thanks
On Wed, May 6, 2009 at 6:30 PM, Fabio Lemos 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 escreveu:
>
> >
> >
> >
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 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 Cell is select
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 Exc
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 wrote:
>
> H
Hi Gurumurty Sastry,
I have done the same thing as this before.
dim wk as workbook
For i=1 to number of files
set wk=workbooks.open (Filename:= Name of the file)
wk.range("T100").copy destination
:=workbooks("Spreadsheet").range(whatever you want)
Next i
Hope this can help
Kin
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 wrote:
> Hi Harmeet,
>
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 y
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 t
This one is awesome! Thank you Mudassar!
On Thu, Mar 26, 2009 at 1:14 PM, Mudassar Ramzan wrote:
> Pl find the attachment.
>
>
> Thanks & regards,
>
> ||* **M**udassar Ramzan** *|* **MIS Officer** **|* *WorldCALL Telecom Ltd*
> *|** 061- 814-3999 *|* 0321 7325277 **||*
>
>
>
> >
>
--~--~--
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 punc
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. Ther
40 matches
Mail list logo
