Dear Yogananda
Instead of sharing such details kindly send a input or output sheet
As your details are too long to read and understand and then provide u any
answer
SO kindly share an excel with group
On Tue, Feb 14, 2012 at 6:40 AM, yogananda muthaiah <
yogananda.mutha...@gmail.com> wrote:
>
please see the attachment, may be it can help you
sanjib
2012/2/13 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>
> Dear Excel Experts
>
> I have a problem in excel date format in column A
> whenever i enter the date dd/mm/ it changes to mm/dd/
>
> I tried to chan
Dear Philehof,
Please try it..
Sub open_url()
On Error GoTo xyz
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
With ie
.Navigate "http://www.un.com";
.Visible = 1
End With
Do While ie.busy
Loop
Set ie = Nothing
xyz: Exit Sub
End Sub
On Tue, Feb 14, 2012 at 1:42 AM, Phile
Hi Group
With the below code, it is possible to jump to the link. How would it be
possible to add an alias to url. Eg. instead of www.UN.com, then it would
display *Homepage of the UN*.
Option Explicit
private Sub Workbook_Open()
Dim ie As Object
Dim url As String
Set ie = Crea
I have code to query a database and return data to the "data" sheet.
The number of rows of data returned will vary.
Through VBA code, how do I tell the pivot table to update the range of
the source data (which is really to update the last row).
(Selecting CTRL-End, goes past where the actual data
hi Raj,
Thanks for your macro but i am sorry this is not performing vlookup
function inthis.
can you please look into this
On Tue, Feb 14, 2012 at 12:37 AM, Raj Mahapatra wrote:
> Hi Rekha,
>
> Please find the attached file
>
> Go to View Macro and Run "Macro 1"
>
> data automatically will
Hi Rekha,
Please find the attached file
Go to View Macro and Run "Macro 1"
data automatically will give you your output
for any further queries, please feel free to revert
Thanks & Regards
Rajesh Mahapatra
On Mon, Feb 13, 2012 at 5:29 PM, rekha siri wrote:
> hi experts,
>
> please help me
Thanks for the effort xlstime. But these are not what I am looking for
in Excel 2010. I am looking for Home - Editing - Fill button(editing
section). Please help me with any tutorial for this section if
possible. Thanks !!
Rohan.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Thanks a lot
On 12 February 2012 22:28, wrote:
> **
> Go to control panel and change date format in regional setings.
> --
> *From: * .•:*¨¨*:•. .•:V.Kiran Kumar :•. .•:* ¨¨*:•.
> vadnalaki...@gmail.com
> *Sender: * excel-macros@googlegroups.com
> *Date: *Sun, 12 Feb
Requesting “urgent” usually turns me OFF and results in me DELETING the
message, but.
You can use that url and get the prices but only like this so you would need to
parse out the info.Instead try Yahoo.
http://finance.yahoo.com/q?s=JUBLFOOD.NS&ql=1I can send a file.
{"futLink":"\/liv
- Click on *Excel Office Button*
- Click on the *Excel Options* button
- Select the *Trust Center* tab
- Click on the *Trust Center Settings…* button
- Select the *Privacy Options* tab
- Uncheck the *Remove personal information from file properties on save*box
- Click *OK* twic
Dear Veeru,
Check below link...
http://winadminnotes.wordpress.com/2011/06/21/privacy-warning-this-document-contains-macros-activex-controls/
On Mon, Feb 13, 2012 at 4:07 PM, Veeru TOC wrote:
>
>
> Dear Group
>
>
> Below type of Error Code Display always what can
> i d
Dear Group
Below type of Error Code Display always what can i
do
** **
--
*Thanks&Regards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical & Contractors**
****H.No-5-9-286/65,Plot No-65
Rajiv Gandhi Nagar
Sharad
in Odin - Mkt watch -right click and select the option "OPEN IN MS EXCEL "
you will get the watch list in excel with fluctuation of prices
Note : This will be available upto MKt hour only
On Mon, Feb 13, 2012 at 3:41 PM, sharad jain wrote:
> Priyanka,
>
> Can you please explain in detai
Priyanka,
Can you please explain in detail?
Thanks,
Sharad
On Mon, Feb 13, 2012 at 3:20 PM, PrIyAnKa wrote:
> Dear Sharad
>
> Do u use ODIN? if yes then recent prices can be get directly from there
>
>
> On Mon, Feb 13, 2012 at 3:07 PM, sharad jain wrote:
>
>> Thanks Maries,
>>
>> However, I a
Thank you very much Maries
On Mon, Feb 13, 2012 at 12:58 PM, Maries wrote:
> Hi,
>
> Try this code:
>
> *Sub LacsChange()
> On Error Resume Next
> Dim MyCell As Range
> For Each MyCell In Selection.Cells
> MyCell.Value = MyCell.Value / 10
> Next
>
Dear Sharad
Do u use ODIN? if yes then recent prices can be get directly from there
On Mon, Feb 13, 2012 at 3:07 PM, sharad jain wrote:
> Thanks Maries,
>
> However, I am not able to download any price data.
>
> Regards,
> Sharad
>
>
> On Mon, Feb 13, 2012 at 10:25 AM, Maries wrote:
>
>> http:
Thanks Maries,
However, I am not able to download any price data.
Regards,
Sharad
On Mon, Feb 13, 2012 at 10:25 AM, Maries wrote:
> http://www.mrexcel.com/tip103.shtml
>
>
> On Mon, Feb 13, 2012 at 8:37 AM, sharad jain wrote:
>
>> Hi Experts,
>>
>> Can anyone suggest a way to directly download
Dear all,
I am using Excel 2007 when i open a file My Macro Not run any one help
this
Private Sub Workbook_Open()
MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com"
End Sub
''=or
Private Sub Workbook_Open()
Call My Macro
End Sub
Regards
http://www.4shared.com/file/3WYWaW-Y/Indian.html
On Mon, Feb 13, 2012 at 1:26 PM, NOORAIN ANSARI wrote:
> Dear Vikram,
>
> Please find attached Converter.
>
> On Sun, Feb 12, 2012 at 8:00 PM, Vic Kumar wrote:
>
>> Hi,
>>
>> Please find enclosed macro to convert numeric value to words in excel
>>
20 matches
Mail list logo