$$Excel-Macros$$ Re: MS Excel -Animation

[zheng yu]

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 are several
> picture in each sheet which become visible and invisible one after another.
> See attached and you will get it.
>
>
>
> _
> "There are known knowns. These are things we know that we know. There are
> known unknowns. That is to say, there are things that we know we don't know.
> But there are also unknown unknowns. There are things we don't know we don't
> know."
>
>  --
> *From:* mahesh parab 
> *To:* excel-macros@googlegroups.com
> *Sent:* Sunday, 29 March, 2009 11:00:50 AM
> *Subject:* $$Excel-Macros$$ MS Excel -Animation
>
> Dear All
>
> The attach excel sheet contain animation in sheet. can anyone explain me
> the steps,
> how this is done
>
> --
> Check out the all-new Messenger 9.0! Click 
> here.
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: answer for query

[zheng yu]

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 punctuation * to , like
: SUMPRODUCT(($A$1:$A$9=F4),($B$1:$B$9=G4)) then the result is 0...can you
tell me the difference?

Thanks so much



On Sat, Mar 28, 2009 at 4:21 PM, Vinu  wrote:

> Hello Praveen,
> I hope you are doing well, happy Ugadi.
>
> I have enclosed the copy of xl sheet, which solves your query.  I used
> Sumproduct forulat, just change the company names to know the count.
>
> Please let me know if you have any issues.
>
>
>
> --
> Vinu
>
>
> (¨`*.*´¨) Always
> `*.¸(¨`*.*´¨) Keep
> (¨`*.*´¨)¸.*´ Smiling!
> `*.¸.*´
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Useful Excel Sheets

[zheng yu]

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 **||*
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Useful Excel Sheets

[zheng yu]

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 the sheet or in
VBA?

  Thank you..

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 **||*
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Fwd: Please let me know the answer to your sample querry. !!!its urgent!!!

[zheng yu]

 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 you prefer

  For i = 1 To ActiveSheet.UsedRange.Rows.Count
B = (ActiveSheet.Cells(i, 1) - Date) < RemindTime
C = (ActiveSheet.Cells(i, 1) - Date) > 0
If B And C Then
MsgBox ActiveSheet.Cells(i, 2) & " is coming in " &
(ActiveSheet.Cells(i, 1) - Date) & "days "
End If
Next i
End Sub

Vincent Zheng


On Tue, Mar 31, 2009 at 8:02 AM, shay shay  wrote:

> Hi All,
>
>   this question was asked byone of our memgers, wherein as soon an excel
> opens it has a list of reminders and it shows as a message box to the recent
> date.
>
> Kindly forward me the  solution as I am not able to find in my inbox.
>
> Regards,
> Shay
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to break the vba project password

[zheng yu]

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,
>
> Enclosed please find the file.
>
> Regards
> Hari Kumar
>
>
>  --
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Harmeet Singh
> *Sent:* Wednesday, March 18, 2009 7:19 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: How to break the vba project password
>
>   Where is the file.
>
> On Thu, Mar 19, 2009 at 1:20 PM, hari  wrote:
>
>>  Hi All,
>>
>>
>>
>> Can anyone help me how to break a vba protect password.
>>
>>
>>
>> Regards
>>
>> Hari kumar
>>
>>
>>
>>
>>
>
>
> --
> Thanks & Regards,
>
> Harmeet Singh
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Help on a Formula in Excel

[zheng yu]

 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

Kind Regards

Vincent Zheng





On Fri, Apr 3, 2009 at 8:37 AM, gurumurthy sastry Kondury <
gurumurthy.sas...@gmail.com> wrote:

> Hi All,
>
> Please help me with the below query.
>
> Suppose I have a folder Named "FOLDER". This folder has 50 Files. I have
> been maintaining a *Spreadsheet* with the names of all these files.
> Now I want to pull the data in the Cell 'T100' of each and every file to
> the *spreadsheet* against each respective file name.
>
> Is there any formula that can help me for this?
>
>
> Thanks & Regards,
>
> Gurumurty Sastry K H
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: { } -his is a function?

[zheng yu]

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:

>
> HI,
>
> As per the previous comments on this, it essentially is an array formula,
> that is applied to a range of a cells instead of a single cell. The
> function
> DfListHolidays() is designed to return an array, and not a single value. So
> if you enter the function as usual in a cell, DfListHolidays() still
> returns
> an array, and the first element in the array is assigned to the cell. When
> you drag the formula across, each time DfListHolidays() returns an array
> and
> the first element is assigned to the cells. To Avoid this, select the range
> of cells (where you want the results to appear), Press F2, type in the
> formula and end the formula by pressing CTRL+SHIFT+ENTER (not only ENTER or
> CTRL+ENTER). Now the selected cells have all the elements of the result
> array. In an array formula entered like this, you will not be able to
> delete
> a single cell. You need to select the entire range and delete the formula.
>
> Regards
>
> Ajit
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Yu
> Sent: Friday, May 01, 2009 2:16 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ { } -his is a function?
>
>
> Hi all,
>
>   I've been programming VBA for around 1 and half years.But this is
> the first time I encounter this . It is a not a VBA issue.it is a
> Excel Function i guess. But I have no idea what it is.
>
>   Here is what it does: Retreive Financial Calendar from a specified
> date to a specified data via Reuters Excel add-in (Reuter is data
> provider).   Reuters has provided the function already.
>
>  The Function provided by Reuters is =DfListHolidays
> ("Country","StartingDate","EndofDate"). Pretty straightforward. For
> instance,if I wanna know USA financial banking holiday from 2005 to
> 2010, i just type in =DfListHolidays("USA","2005","2010")
>
>  The thing is when you type in  =DfListHolidays("USA","2005","2010")
> in one cell, it only shows the first banking holiday. When you drag
> that formula down ,all cells also show the same date as first cell.
>
>   BUT... someone else has used  {=DfListHolidays
> ("USA","2005","2010")} in a column. and cells in that column show all
> banking holidays from 2005 to 2010.
>
>  My question is what is { } ? How does it work?
>
>  I have upload the file called "Kalender_ViaReuters.xls" to the
> group. Thanks for any ideas!
>
>  Please also email anytime if you are not clear what I mean.
>
> Vincent Zheng
>
> Denmark
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to copy Excel files thru Command prompt

[zheng yu]

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
through Command line?

On Tue, May 5, 2009 at 5:56 PM, yogesh yerawar  wrote:

> Hi,
>
> copy filename destination path
>
> eg.
> copy book1.xls c:\my documents
>
>
> 2009/5/5 singla.kris...@gmail.com 
>
>>
>> Hi eveybody,
>>
>> can anyone tell me how to copy excel files using command prompt.
>>
>> thanx in advance
>>
>>
>>
>
>
> --
> Thanks and Regards,
> Yogesh Yerawar
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Insert ListBox into Cell

[zheng yu]

 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 selected.
>
> Thanks, Walid
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Cell reference

[zheng yu]

 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 dear all,
> >
> >   For instance, I wanna D1 refers to A1,so D1 has the value 10 as A1
> > has. Now B1 has value"A", and C1 has value "1", I want D1 has the
> > formula "=A1"
> >
> >   It doesn't work when I type  "=B1&C1" in D1... Can anyone gives
> > some shine on it?
> >
> >  I know how to do it in VBA..quite easy:   range("D1").value =range
> > (range("B1")&range("c1")).value. But i do not know how to do it on
> > spreadsheet. Thanks
> >
> >
> >
> >   A   B  C   D
> > --
> >
> > 10   A   1  =A1
> >
> > >
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: single password for excel

[zheng yu]

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 Ultimate Add-in attached along with the mail. Explore the
>> options, I m sure you can break passwords of excel *worksheet* and *
>> module*.
>> In case of problems, revert back
>>
>> Praveen Khunte
>>
>>
>> Prashanth Banneni wrote:
>>
>> Hi all,
>>
>> Can any one give me the password breaker tool.
>>
>> Thanks in advance
>>
>> Regards,
>> Prashanth
>>
>>  On Sat, May 2, 2009 at 3:06 PM, girish gv  wrote:
>>
>>> post the file i will break the password
>>>
>>> On 12/19/08, jasm...@1908  wrote:

  HI there,….



 Send me the file and I will break the password and give you the new
 password..



 Regards..



 Manjit Singh


  --

 *From:* excel-macros@googlegroups.com [mailto:
 excel-mac...@googlegroups.com] *On Behalf Of *AMARNATH RAVEENDRANATH
 *Sent:* 16 December 2008 09:12 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Re: single password for excel



 Hello All



 I have forgotten my password for an excel. Is there a way to retrieve it
 or delete it.



 Thanks & Regards

 Amar





>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
> --
> =
> - k...@m@l' g...@ti' -
> =
> Ph: +91 9899101928, 9718361928
>
> -
> "Don't compare yourself with anyone in this world. If you do so, you are
> insulting yourself."
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Run a macro on Enter?

[zheng yu]

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 to make it happen without having to use a mouse to click a
> button. A hot key combo or a form would work but it would be really
> sweet if I could just press Enter from the correct cell.
>
> Is it possible to run a macro by simply hitting enter on a cell
> without even entering any data in the cell? The active cell will
> always be in column 4.
>
> None of the answers I found online so far work for me.
>
> Thanks.
> Doug
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: single password for excel

[zheng yu]

hahaha,thanks Rishi Pathak [?] Hmm.i was just thinking out of box
la[?]but now i know some box you just can get out of..it is wild
and dangerous
outside :-)

On Mon, May 11, 2009 at 9:48 AM, Dave Bonallack
wrote:

>  Oh dear, someone really hasn't been paying attention.
>
>
> --
> Date: Mon, 11 May 2009 11:25:56 +0530
> Subject: $$Excel-Macros$$ Re: single password for excel
> From: rishi.pathak1...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Microsoft passwords can not be broken!!
>
>
>
> With regards
>
> 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 and regards,
>
> Kamal Gulati
>
>
>
>
> On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte 
> wrote:
>
> Install Ultimate Add-in attached along with the mail. Explore the options,
> I m sure you can break passwords of excel *worksheet* and *module*.
> In case of problems, revert back
>
> Praveen Khunte
>
>
> Prashanth Banneni wrote:
>
> Hi all,
>
> Can any one give me the password breaker tool.
>
> Thanks in advance
>
> Regards,
> Prashanth
>
> On Sat, May 2, 2009 at 3:06 PM, girish gv  wrote:
>
> post the file i will break the password
>
> On 12/19/08, *jasm...@1908*  wrote:
>
>  HI there,….
>
> Send me the file and I will break the password and give you the new
> password..
>
> Regards..
>
> Manjit Singh
>
>  --
>  *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *AMARNATH RAVEENDRANATH
> *Sent:* 16 December 2008 09:12 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: single password for excel
>
>  Hello All
>
>  I have forgotten my password for an excel. Is there a way to retrieve it
> or delete it.
>
>  Thanks & Regards
>  Amar
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> =
> - k...@m@l' g...@ti' -
> =
> Ph: +91 9899101928, 9718361928
>
> -
> "Don't compare yourself with anyone in this world. If you do so, you are
> insulting yourself."
>
>
>
>
>
>
>
>
>
> --
> With regards
> Rishi pathak
>
>
>
>
> --
> Find out how with Windows Live! Want to stay on top of your life 
> online?<http://windowslive.ninemsn.com.au/>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

<><>

$$Excel-Macros$$ Re: copy text from a formula & Ctrl+D

[zheng yu]

  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 formula in the above cell, actually
when you use Ctrl+D, the below cell copies the formula as well. That is
totally same as Ctrl+C then Ctrl+V...I don't know what makes Ctrl+D
different?

On Tue, May 12, 2009 at 2:20 PM, Paul Schreiner wrote:

> Are you saying that you want to copy the formula WITHOUT the "=" ??
>
> I'm not sure if there is a shortcut.
>
> But in answer to your second question:
> Ctrl-D simply copies the contents of the above cell.
> Paul
>
>  --
> *From:* Yu 
> *To:* MS EXCEL AND VBA MACROS 
> *Sent:* Tuesday, May 12, 2009 2:32:06 AM
> *Subject:* $$Excel-Macros$$ copy text from a formula & Ctrl+D
>
>
> Hi All,
>
>
> In cell A1 I have a formula like "=blablabla(arg1,arg2)".  How
> can just copy "blablabla(arg1,arg2)" ? is there a short cut ?
>
> And what is the difference between Ctrl+D and  "Ctrl+C then Ctrl
> +V"..both seem to copy and paste...and I was told there is slight
> differenct...
>
>   Thanks!
>
> Yu
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Concatenating Problem

[zheng yu]

 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 it as a NUMBER ("4/16/2009 9:00 AM" is stored as: 39919.375)
> But, you're using a cell format of: "m/d/yy h:mm AM/PM" (or similar) to
> DISPLAY the number as a date/time.
> Excel then checks the fraction of a day (.375) and determines that it is
> less than .5, so therefore
> the designation of AM is used.
>
> When you're concatenating the 'time zone' to the date, you're creating a
> text string that no longer
> retains the date "number" (therefore, future date manipulations will not be
> possible)
>
> That being said, what YOU need to do is duplicate what Excel does.
> find the time portion of the date/time by determining the
> decimal(fractional) portion
> of the date number.
> I chose to find the INTEGER portion of the number and subract it from the
> number (A1 - INT(A1))
> then, check to see if this is the first half of the day, or the second
> half: (A1 - INT(A1)) < .5
> If it is, then display "AM", if not, display "PM".
> or:  =IF(A1-INT(A1)<0.5,"AM","PM")
>
> the result is:
> =CONCATENATE(MONTH(A1),"/",
>  DAY(A1),"/",   YEAR(A1)," ",
> HOUR(A1),":",   MINUTE(A1),   SECOND(A1)," ",
> IF(A1-INT(A1)<0.5,"AM","PM")," ",   B1)
>
> good luck,
>
> Paul
>
>  --
> *From:* "jamadagnira...@gmail.com" 
> *To:* MS EXCEL AND VBA MACROS 
> *Cc:* jamadagnira...@gmail.com
> *Sent:* Tuesday, May 12, 2009 3:57:44 AM
> *Subject:* $$Excel-Macros$$ Concatenating Problem
>
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A  Column B  Column C
>
> 4/16/2009 9:00 AM  CDT  4/16/2009 9:00 CDT
>
> You see, after i concatenate Column A and Column B, in Column C, i get
> the above value. If you notice, i am not getting "AM" text in Column
> C. Below is the formula i used -
>
> =CONCATENATE(MONTH(A1),"/",DAY(A1),"/",YEAR(A1)," ",HOUR(A1),":",MINUTE
> (A1),SECOND(A1)," ",(B1))
>
> Please can anyone give me the formula to concatenate, so that i get AM
> or PM accordingly in Column C. Please help.
>
>
> Regards,
> Raghu J.
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Concatenating Problem

[zheng yu]

 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
presentation of the date, now you can export to any file (xml,text) and have
the date appearance as 20090512.



On Tue, May 12, 2009 at 3:09 PM, Aindril De  wrote:

> Excellent explaination Paul...
> Learnt something new today..
>
> Keep up the great work..
>
> Regards,
> Andy
>
> On Tue, May 12, 2009 at 7:15 PM, Paul Schreiner wrote:
>
>>  First, I want to remind you that the "date/time" isn't being stored as a
>> "date".
>> Excel stores it as a NUMBER ("4/16/2009 9:00 AM" is stored as: 39919.375)
>> But, you're using a cell format of: "m/d/yy h:mm AM/PM" (or similar) to
>> DISPLAY the number as a date/time.
>> Excel then checks the fraction of a day (.375) and determines that it is
>> less than .5, so therefore
>> the designation of AM is used.
>>
>> When you're concatenating the 'time zone' to the date, you're creating a
>> text string that no longer
>> retains the date "number" (therefore, future date manipulations will not
>> be possible)
>>
>> That being said, what YOU need to do is duplicate what Excel does.
>> find the time portion of the date/time by determining the
>> decimal(fractional) portion
>> of the date number.
>> I chose to find the INTEGER portion of the number and subract it from the
>> number (A1 - INT(A1))
>> then, check to see if this is the first half of the day, or the second
>> half: (A1 - INT(A1)) < .5
>> If it is, then display "AM", if not, display "PM".
>> or:  =IF(A1-INT(A1)<0.5,"AM","PM")
>>
>> the result is:
>> =CONCATENATE(MONTH(A1),"/",
>>  DAY(A1),"/",   YEAR(A1)," ",
>> HOUR(A1),":",   MINUTE(A1),   SECOND(A1)," ",
>> IF(A1-INT(A1)<0.5,"AM","PM")," ",   B1)
>>
>> good luck,
>>
>> Paul
>>
>>  --
>> *From:* "jamadagnira...@gmail.com" 
>> *To:* MS EXCEL AND VBA MACROS 
>> *Cc:* jamadagnira...@gmail.com
>> *Sent:* Tuesday, May 12, 2009 3:57:44 AM
>> *Subject:* $$Excel-Macros$$ Concatenating Problem
>>
>>
>> Hello,
>>
>> I have a problem in displaying AM or PM, when i try to concatenate to
>> cells. Below is the reference -
>>
>> Column A  Column B  Column C
>>
>> 4/16/2009 9:00 AM  CDT  4/16/2009 9:00 CDT
>>
>> You see, after i concatenate Column A and Column B, in Column C, i get
>> the above value. If you notice, i am not getting "AM" text in Column
>> C. Below is the formula i used -
>>
>> =CONCATENATE(MONTH(A1),"/",DAY(A1),"/",YEAR(A1)," ",HOUR(A1),":",MINUTE
>> (A1),SECOND(A1)," ",(B1))
>>
>> Please can anyone give me the formula to concatenate, so that i get AM
>> or PM accordingly in Column C. Please help.
>>
>>
>> Regards,
>> Raghu J.
>>
>>
>>
>>
>>
>>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: $$Excel-Macros$$

[zheng yu]

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.
>
> regards,
>
> B.SRINIVASA RAO
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: copy text from a formula & Ctrl+D

[zheng yu]

 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 the data with formula and text / formatting from
> above cell.
> Ctrl + C and Ctrl + V, will first move the data to clipboard and then copy
> the same from clipboard to the destination you choose.
>
> thanks,
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
> On Tue, May 12, 2009 at 12:02 PM, Yu  wrote:
>
>>
>> Hi All,
>>
>>
>> In cell A1 I have a formula like "=blablabla(arg1,arg2)".   How
>> can just copy "blablabla(arg1,arg2)" ? is there a short cut ?
>>
>>And what is the difference between Ctrl+D and  "Ctrl+C then Ctrl
>> +V"..both seem to copy and paste...and I was told there is slight
>> differenct...
>>
>>   Thanks!
>>
>> Yu
>>
>>
>>
>>
>> >>
>>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: delete a common word in a column pls help

[zheng yu]

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...@yahoo.com
> New Delhi - 110062
>
> On Tue, May 12, 2009 at 10:20 AM, subs  wrote:
>
>>
>> hi
>>
>> i have data like this in the column of the excel table
>>
>> total charge: apl  total charge:ppg   total
>> charge:uia
>>
>>
>> These are the the columns.  there are many more columns like them. i
>> want to remove total charge in all the columns headings. i want to
>> keep apl, ppg  and uia and so on. the word total charge has to be
>> deleted. What is the easiest way of doing that- i want to retain
>> whatever is there after total charge. Thanks
>>
>>
>>
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: general discussion on DDE OLE ActiveX in VBA project

[zheng yu]

 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,
>
> 1. Microsoft Forms 2.0 Object lib. provides the MSForms2.0 Controls. Just a
> few. To know more about each of the referenced components, in VBE press F2
> to bring up the object browser. In the first combo-box (upper-left - All
> Libraries), select the appropriate one, and you will know what objects,
> methods, classes etc. are exposed by that library. As for the ActiveX
> reference, better to google the file name to know more.
>
> 2. Coming to OLE and DDE, take a look at the following link, that might
> help--
> http://forums.techarena.in/software-development/1133040.htm
>
>
> Regards
>
> Ajit
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Yu
> Sent: Thursday, May 07, 2009 7:12 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ general discussion on DDE OLE ActiveX in VBA
> project
>
>
> Hi guys,
>
>   While I browse the Tools-->References in VBA , I notice that there
> are lots of references, basically classified into 4 groups:
>
>Type Libraries(*.olb, *.tlb, *.dll)
>Executable Files (*.exe, *.dll)
>ActiveX Controls (*.ocx)
>All Files (*.*)
>
>   I can see currently my VBA project has referenced to Visual Basic
> for Applications, Microsoft Excel 12.0 Object Library, OLE automation
> and Microsoft Forms 2.0 Library as well as Office 12.0 Object Library.
>
>  My first puzzle is about  ActiveX  vs. Forms 2.0 . I can see that if
> I didn't add reference to ActiveX controls,then my Form doesn't have
> controls toolbox, after I add reference to ActiveX, the Controls
> appear in the toolbox. So what is the use of Microsoft Forms 2.0
> library there? From its name, I assume it should also provide form
> controls.
>
>   I can see ,by default, VBA project has reference to OLE
> automation . And I hear some senior guys in company that they used DDE
> back in the old days. I couldn't even find DDE in the reference
> window.  How DDE differentiate it from OLE.(OLE is just an upgrade of
> DDE?) And how they are related to ActiveX?
>
>  As far as I understand, DDE is quite old technology for sharing data
> between applications, like writing data into Excel cell from your own
> program. OLE and ActiveX are relatively new, based on COM. When I
> write vba code in Excel to manipulate Word, am I using OLE or ActiveX
> or DDE? How can I control which one to use? which one is better?
>
>  we can discuss these stuff here:)
>
> Regards
>
> Yu Zheng
>
>
>
>
>
>
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Is there any way to search Google using VBA and Get Search Results in Excel

[zheng yu]

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 handling in the code.. debug and
> see where u have the  problem
>
> On Tue, May 26, 2009 at 3:51 AM, Upendra Singh <
> upendrasinghsen...@gmail.com> wrote:
>
>>  Hi,
>>
>>
>>
>> This code is not running. Does this requires any reference library to be
>> included except default….
>>
>>
>>
>> Regards,
>>
>>
>>
>> Upendra Singh
>>
>> 9910227325
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *ddadmin2009
>> *Sent:* Tuesday, May 26, 2009 11:47 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: Is there any way to search Google using
>> VBA and Get Search Results in Excel
>>
>>
>>
>> I think that is definitely possible with VBA.. but to start with check the
>> below code to get google search result count in excel... you can explore
>> more and tweak the code accordingly to get your desired result.
>>
>>
>>
>>
>> http://funwithexcel.blogspot.com/2009/05/how-to-get-google-search-results-count.html
>>
>>
>>
>> just a hint, as shown in the code,
>>
>>
>>
>> results_var = search_http.responsetext
>>
>>
>>
>> results_var is the key for getting your search results. just get the
>> results and write each search result to a separate sheet for more clarity.
>>
>>
>>
>> Hope this helps.
>>
>>
>>
>> On Mon, May 25, 2009 at 5:05 AM, Upendra Singh <
>> upendrasinghsen...@gmail.com> wrote:
>>
>> Hi,
>>
>>
>>
>>
>>
>> Is there any way to search Google using VBA and Get Search Results in
>> Excel…..
>>
>>
>>
>> Regards,
>>
>>
>>
>> Upendra Singh
>>
>>
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-mac...@googlegroups.com] *On Behalf Of *Dhartikumar Sahu
>> *Sent:* Monday, May 25, 2009 3:00 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Re: want to remove Open password in excel
>>
>>
>>
>> hi Rahul
>>
>>
>>
>> but for remove the password i should open the file. if can not open
>> without password then what to do...
>>
>>
>>
>> Regards
>>
>> Dhartikumar
>>
>> On Sat, May 23, 2009 at 6:55 PM, RAHUL GARG  wrote:
>>
>> Hi  Dear freiend,
>>
>>  Go to the tool menu in the toolbar, click on
>> security tab & remove the password which aplies on it
>>
>>
>>
>> Your freind,
>>
>> Rahul Garg
>>
>>
>>
>>
>>
>> --- On *Sat, 23/5/09, girish gv * wrote:
>>
>>
>> From: girish gv 
>> Subject: $$Excel-Macros$$ Re: want to remove Open password in excel
>> To: excel-macros@googlegroups.com
>> Date: Saturday, 23 May, 2009, 4:43 PM
>>
>> forward the file i wil remove i wil send it to u back
>>
>> On 5/19/09, *Dhartikumar Sahu* 
>> http://in.mc87.mail.yahoo.com/mc/compose?to=dhartiku...@gmail.com>>
>> wrote:
>>
>> hi group
>>
>>
>>
>> can u suggest me how to remove open password in excel
>>
>>
>>
>> Thanks
>>
>> Dhartikumar
>>
>>
>>  --
>>
>> Cricket on your mind? Visit the ultimate cricket website. Enter now!
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --
>> http://funwithexcel.blogspot.com/
>>
>>
>>
>>
>>
>
>
> --
> http://funwithexcel.blogspot.com/
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Tips

[zheng yu]

 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 manually.
My solution is I write a few lines to convert string name of Column to
number. How do you guys do it? or you use another way to find blank cells?

Cheers

Yu
On Sat, Jun 6, 2009 at 10:12 AM, Dave Bonallack
wrote:

> Hi Group,
> Tip.
> The following line of code line returns the first blank cell at the end of
> a series of data, ignoring any blank cells within that series.
> In this case, the series is in Col A.
> I use it a lot when copying stuff onto the bottom of existing data.
>
> This is not new, but might be useful for those still learning VBA - which I
> guess is all of us really...
>
> A = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Address
>
> If you just need to know the Row number, use
>
> A = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
>
> By the way, I think this 'submit your tip' idea is excellent.
>
> Regards - Dave.
>
> --
> Click Here View photos of singles in your 
> area
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Tip of the week

[zheng yu]

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 worksheet.
>
>
>
> Thanks&Regards
> Ramesh Katta
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to open a web query from a macro ?

[zheng yu]

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 window with a given address. The aim
> is not to retrieve data but just to open the web querry window
> (without going to Data/Import External Data/New web query ...
> The button is there. It is just that I cannot find the Vba formula to
> open the window without importing any data. And I am not interested in
> opening my hyperlink in IE.
>
> Thanks for your help.
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Unhide doesn't work in a Worksheet_change event & C++ add-in development

[zheng yu]

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..

please open the sheet and take a look..




On Fri, Jun 12, 2009 at 3:13 PM, Fabio Lemos  wrote:

> I have tested and it works for 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. I can create a new sheet with same functions and it
>> works..but I can't fix this one. Please take a look.
>>
>>   in sheet" Parametervalg" there is a simple Worksheet_change event, and I
>> just put these lines of code there. And amazingly they don't work.
>>
>>   The problem is that in Range("C5"), there is 5 numbers you can choose
>> 0,1,2,3,4,5. And when you choose 0, it will hide certain columns; when you
>> choose 1 it will unhide them. Rest of numbers do similar things. But when I
>> choose 0, it doesn hide all columns, and when i choose 1, it DOES NOT unhide
>> all of them when I write this piece of code in a new sheet,it works just
>> fine.
>>
>>  Private Sub Worksheet_Change(ByVal Target As Range)
>>
>>   If Target.Value = "0" Then
>>MsgBox "000"
>>'Sheets("Parametervalg").Select
>>Columns("G:K").EntireColumn.Hidden = True
>> End If
>>
>> If Target.Value = "1" Then
>>MsgBox "111"
>>Columns("G:K").EntireColumn.Hidden = False
>> End If
>>
>>  end sub
>>
>>
>> By the way, anyone here in the forum does Excel-addin C++ development ?
>>
>> Vincent
>>
>>
>>
>>
>>
>
>
> --
> Fabio Lemos
>
> e-mail: flnle...@gmail.com
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Unhide doesn't work in a Worksheet_change event & C++ add-in development

[zheng yu]

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..
>
> please open the sheet and take a look..
>
>
>
>
> On Fri, Jun 12, 2009 at 3:13 PM, Fabio Lemos  wrote:
>
>> I have tested and it works for 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. I can create a new sheet with same functions and
>>> it works..but I can't fix this one. Please take a look.
>>>
>>>   in sheet" Parametervalg" there is a simple Worksheet_change event, and
>>> I just put these lines of code there. And amazingly they don't work.
>>>
>>>   The problem is that in Range("C5"), there is 5 numbers you can choose
>>> 0,1,2,3,4,5. And when you choose 0, it will hide certain columns; when you
>>> choose 1 it will unhide them. Rest of numbers do similar things. But when I
>>> choose 0, it doesn hide all columns, and when i choose 1, it DOES NOT unhide
>>> all of them when I write this piece of code in a new sheet,it works just
>>> fine.
>>>
>>>  Private Sub Worksheet_Change(ByVal Target As Range)
>>>
>>>   If Target.Value = "0" Then
>>>MsgBox "000"
>>>'Sheets("Parametervalg").Select
>>>Columns("G:K").EntireColumn.Hidden = True
>>> End If
>>>
>>> If Target.Value = "1" Then
>>>MsgBox "111"
>>>Columns("G:K").EntireColumn.Hidden = False
>>> End If
>>>
>>>  end sub
>>>
>>>
>>> By the way, anyone here in the forum does Excel-addin C++ development ?
>>>
>>> Vincent
>>>
>>>
>>>
>>>
>>>
>>
>>
>> --
>> Fabio Lemos
>>
>> e-mail: flnle...@gmail.com
>>
>> >>
>>
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel add-in and Reference in VBA

[zheng yu]

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 VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Can't find add-in in Add-in manager Excel 2007

[zheng yu]

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. But the add-in
logo is always in the workbook.

   I couldn't find Bloomberg addin in the Addin manager .it is just not
listed there.

   any ideas on this?

Vincent

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Excel add-in and Reference in VBA

[zheng yu]

 Thanks ! Paul!

  this is very thorough and precise!

  Thanks so much. Sometimes, I can feel the differences..but can' t
summarize and tell. i guess it is because I don't understand too deep.

  Again,thanks so much

Vincent



On Mon, Jun 15, 2009 at 5:50 PM, Paul Schreiner wrote:

> Without getting into how Excel stores, saves and distributes the two,
> here's how they are USED.
>
> "References" are libraries (usually .DLL's) that are distributed with
> the the Excel application.
> These may be "activated", or left unused.
> Let's say, for example, that you wish to use VBA to access a Lotus Notes
> Address Book.
> You would then "activate" the "Lotus Domino Objects" Reference.
> You would then have access to the methods and objects necessary for access
> to Lotus Notes.
>
> I have a situation in which text files are opened in Excel, but some
> columns are created
> as "text", and I need to convert them to numeric.
> I wrote a sub called txt2num that replaces "0" with 0, "1" with 1, "2" with
> 2 and so on.
> I don't want to have to write this every time I need it.
> I want it available whenever I have a workbook open.
>
> There are several ways of accomplishing this.
> I could create a "macros.xls" workbook and open it every time I open Excel.
>
> Or, I could place it in a specific folder, and configure Excel so that it
> opens all files
> in that folder whenever Excel is launched.
>
> Or... notice that when you open Excel, you automatically open a "hidden"
> workbook
> called Personal.xls (or Personal.xlsb in Excel 2007).
> You could put your macro in THIS VBA Project and it would be available
> whenever you launch Excel...
>
> But... what if you want to SHARE this (or these) macros?  You can't share
> your Personal.xls file...
> so instead, you put the macro in a new file and save it as an .xla file.
> Now THIS file 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:
> Add-Ins are in Excel format, 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 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, June 15, 2009 6:14:36 AM
> *Subject:* $$Excel-Macros$$ Excel add-in and Reference in VBA
>
> 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 VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: How to use timer in Excel VBA

[zheng yu]

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 can try to use
>
> Public Declare Sub Sleep Lib "kernel32" (ByVal
> dwMilliseconds As Long)
> .
> .
> "Code before sleep"
> .
> DoEvents
> sleep 100
> .
> "code after sleep"
> .
> 
>
>  Public Declare Sub Sleep Lib "kernel32" (ByVal
> dwMilliseconds As Long)
> // Declaration for sleep command
>
> DoEvents
> //Used for updating the screeen so statement before sleep will work
> properly  else the code line before the sleep did execute before the sleep,
> but the display update it triggered did not.
>
> sleep 100<-- in milli seconds use 1000 for 1 second
>
> - Original Message -
> *From:* anil kumar 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, June 30, 2009 7:08 PM
> *Subject:* $$Excel-Macros$$ How to use timer in Excel VBA
>
> Hi,
>
>  Actullay i want to use a paticular coding that should be run or re run
> again after a particular time interval that can be possible in vb through
> the Timer control can we do the same in excel if any one knows the same
> please do the needful.
>
> how can i use a timer control which is in VB can i use the same in EXCEL
> VBA if any one know that please send me the the procedure and the code.
>
> i m using application.ontime for the same but was not able to do my task.
>
> --
> Thanks & Regards
> Anil Kumar
>
> >
>

--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Saving a txt file to an ftp server

[zheng yu]

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, then the FTP client will uploads those files in
that folder to FTP server automatically at schedule time.

   There are many free FTP client you can download

   I just think this is easier than doing it in VBA

Cheers

Yu Zheng

On Mon, Jul 20, 2009 at 1:06 PM, MartyH  wrote:

>
> Hi all,
>
> I currently have a macro that takes data from a spreadsheet and
> reformats it to a pipe delimited .txt file then saves to a location on
> my C: drive.
> I then manually place the file on an ftp server - is there any way
> that I can save the file direct to the ftp server or move it from my
> C:drive to the ftp server?
>
> I have read a few articles on API that seem to suggest a solution but
> my VBA understanding isn't quite to the level where I can fully
> undersatnd the code in published examples and thus tweak it to my
> exact requirements.
> Any help would be freatly appreciated.
>
> Many thanks,
>
> MartyH
>
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,000 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Escaping a foir loop

[zheng yu]

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 the current loop and iterate to the next
> loop
>
> Thanks and Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com  - Saving energy-Save Earth
>
>
>
>
> On Wed, Jul 29, 2009 at 4:45 PM, OfficeVba Trainer <
> officevbatrai...@yahoo.com> wrote:
>
>>  Hi Vivek,
>>
>>
>> For intI=1 to 1000
>>
>> ..Statements
>>
>> If intI=750 Then Exit For
>>
>> Next
>>
>> Let me know if u have any queriies.
>> Kumaran V
>> ++91 9873152622
>> Thanks and regards
>> Office VBA Trainer
>> http://officevbatrainer.blog.co.in
>>
>>  --
>> *From:* vivek agrawal 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wednesday, July 29, 2009 4:24:22 PM
>> *Subject:* $$Excel-Macros$$ Escaping a foir loop
>>
>> Hi ALL
>> Can anybody please tell me how to Escape a for loop ...
>>
>> for ex... i am running a for loop for 1000 times at the starting of
>> the code in the loop, i am checking the value of a variable i want that
>> if the value the variable is below a particular limit, then the rest of the
>> code should not run and the next should be started...
>>
>> i want the line of code which i should insert in the ifendif
>> statement
>>
>> its urgent can anybody please help me..
>>
>>
>> Thanks and Regards,
>> Vivek Agrawal
>> Skype ID - vivek.agrawal83
>>
>> GoogleMoonlight.com   - Saving energy-Save
>> Earth
>>
>>
>>
>>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Progress Reporter

[zheng yu]

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...
>
> thanks a lot..
>
> Regards,
> Vivek Agrawal
> Skype ID - vivek.agrawal83
>
> GoogleMoonlight.com  - Saving energy-Save Earth
>
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA

[zheng yu]

 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
> which is beyond the max-min limits of an integer – +32767 to -32768. The fix
> in typecast either of these 2 quantities as long.
>
>
>
> e.g.
>
>
>
> c = 4& * 1
>
>
>
> or
>
>
>
> c=clng(4) * 1
>
>
>
> That way, we can force the number to be evaluated as a long (and not an
> int), thereby forcing the whole expression to be evaluated as a long.
>
>
>
> The same thing happened in what, harmeet has suggested. C=a*1, here
> since a is a long, the expression becomes a long expression.
>
>
>
> Regards
>
>
>
> Ajit
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Harmeet Singh
> *Sent:* Thursday, July 30, 2009 12:16 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Overflow error in Excel 2007 VBA
>
>
>
> Couldn't figure out why but workaround is:
>
>
>
>
>
> Sub Test
>
> Dim a As Long
> Dim b As Long
> Dim c As Long
> Dim d As Long
> Dim e As Long
>
> a = 4
> b = 7 * 100
> c = *a* * 1 ' < Why do I get an overflow error here?
> d = 100
> e = a + b + c + d
>
> End Sub
>
> On Thu, Jul 30, 2009 at 8:20 AM, Cliff  wrote:
>
>
>
> I can't figure out why  I am getting an overflow error on the line
> indicated below.  Any suggestions?
>
>
> Sub Test
>
> Dim a As Long
> Dim b As Long
> Dim c As Long
> Dim d As Long
> Dim e As Long
>
> a = 4
> b = 7 * 100
> c = 4 * 1 ' < Why do I get an overflow error here?
> d = 100
> e = a + b + c + d
>
> End Sub
>
>
> --
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Timevalue and Datevalue suddently doesn't work any more

[zheng yu]

Hi Vivek,

   Thank you for your reply

   I found out it is very funny. i change the cell(containing date or time)
format to Date , then i used function Datevalue() and timevalue(), they
work!



On Wed, Aug 12, 2009 at 10:50 AM, vivek agrawal
wrote:

>
> hi
>
> I think the returnvalue of the timevalue() and datevalue() can also be
> achieved by changing the cell format of the cell(containing the date or
> time) from "date" or "time" to "general". Attached is the workaround
> hope this is what you want..
>
> if not, then please 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,
>>
>>
>> Please take a look at the spreadsheet. I extract these three
>> columns from database, then the second column contains the Date, and third
>> column contains Time.
>>
>>For the past week, I can use Timevalue() function to get the time
>> from third Column...But suddenly today it doesn't work any more. Even
>> Datevalue doesn't work for column 2.
>>
>>   I also use these two functions in VBA.and they worked just fine
>> before...but not today.
>>
>>  Anyone experienced the same problems?
>>
>>  Thanks for any input
>>
>> Cheers
>>
>> Vincent
>>
>>
>>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Logos Quiz !!

[zheng yu]

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
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Independance day

[zheng yu]

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
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Linking to Reuters market data in vba

[zheng yu]

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 looking for a way to link to Reuters live market data in vba.
>
> Doing this from a workbook is relatively straightforward, however I
> don't want any links in my spreadsheet as this slows things down
> considerably.
>
> Currently, I'm using the following vba code:
>
> Application.Evaluate ("Reuters Code")
>
> where "Reuters Code" represents the reuters code (RIC) for the
> specific market data I'm interested in.
>
> However, this doesn't always work, so I'm looking for a more direct
> and efficient way to do this.
>
> Any Thoughts?
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Excel automatic download from web

[zheng yu]

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 address is as follows. The excel sheet is a snap shot of
Foreign Exchange Implied Volatility data. I can click on the excel and
download. But i guess there is a way to do it programmatically.


https://eulive.barcap.com/BC/barcaplive?menuCode=MENU_FIA_TOOLKIT&url=/TSP/tspbr/csvDataPage?pm=2f686f6d652f6e7974737070722f5453502f62617463682f7265706f7274732f2f7075626c69635f68746d6c2f7473702f62617463682f6f2f6f7665726761736f2f54657374352f6373762f646174612e68746d6c

 Thank you for your time and kind help !
Br

Vincent

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe