Hi Experts
I am waiting for your reply on below.
1st Example --
I have file named File1, which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in File1 Open event, so that it can UPDATE all external links.
2nd Example
Please tell me how can use this add in please send the example sheet
Thanks
On Thu, Jul 5, 2012 at 9:52 AM, Deba Ranjan drdeva...@gmail.com wrote:
Thanks Chile,
Working fine.
Thanks Regards,
*Deba Ranjan P*
On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel
Dear Amit,
We have to write code for each file in Workbook_Open Event like..
Private Sub Workbook_Open()
'For File1
Workbooks.Open FileNmae:=D:\VBA_Class\File1.xls,
UpdateLinks:=xlUpdateLinksAlways
'For File2
Workbooks.Open FileNmae:=D:\VBA_Class\File2.xls,
UpdateLinks:=xlUpdateLinksAlways
Hi Jai,
what my logic is that , if i have many conditional formula as per the
requirements of the data base, then we have create a lot function manually
in the Visual application.
So its very transparent that if already function code is written in
the add - in , then repeatedly we
Dear Moderator,
i appreciate if any one gets award.
Four types of mails are filling my mailbox
*1. MVP Award*
*2. Introduce Yourself*
*3. Five Year Completion*
*4. Help ful Member*
Then why *Not Job posting* also this will help forum members too.
Regards,
Pankaj
On Thu, Jul 5, 2012 at 10:04
Hi Experts
I need a macro which changes the FONT COLOR of ENTIRE ROW as per font color
of a particular cell in that row. Sample file attached.
Pls help me here.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Group,
how can i get all mail IDs from my outlook to excel to make a list of
all IDs and Co., please help me out
Thanks Regds
ROHAN
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Just follow follow the link
http://support.microsoft.com/kb/295664
On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young rohan.j...@gmail.com wrote:
Dear Group,
how can i get all mail IDs from my outlook to excel to make a list of
all IDs and Co., please help me out
Thanks Regds
ROHAN
--
Dear Amit,
Please try it..
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 3 And Target.Value Then
Target.EntireRow.Interior.ColorIndex = Target.Cells.Font.ColorIndex
End If
End Sub
*
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
*Congrats..Ashish Dilip*. :)
On Thu, Jul 5, 2012 at 11:05 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
cong both of you
Regards,
Sanjib
On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey divake...@gmail.comwrote:
*Congrats..Ashish Dilip, for your gr8 Achievement.*
Dear Sanjib,
Its not working improting i need to import all Mail IDs from My Sent
Inbox Folder, i need any macro for this
thanks
On Thu, Jul 5, 2012 at 4:01 PM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Just follow follow the link
http://support.microsoft.com/kb/295664
On
use this one
Sub ChangeRowColor()
Dim sheet As Worksheet
Dim row_min As Integer
Dim row_max As Integer
Dim rowC As Long
' Select the used range.
Set sheet = ActiveSheet
'sheet.UsedRange.Select
' Display the range's rows and columns.
row_min = sheet.UsedRange.Row
row_max
Hi Group,
I made a custom menu and ribbon icon using xml in my workbook. I want to
keep selected the created custom menu everytime whenever workbook activated.
Divaker
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Hi Experts,
I'm in crunch situation.Let me try to explain.We have some Excel files
named-1,2 3 saved on network share of pune they are really very heavy
like 40 MB each. What i have to do is to fetch the data of current week for
eg. week-27.I have analysed them the trend of data is
Thank you all.. J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Asa Rossoff
Sent: 05 July 2012 1:39
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Rajan Verma - Most helpful
=SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 05 July 2012 1:56
To: excel-macros@googlegroups.com
Subject:
HI LOKESH
I think query is still not clear
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: 05 July 2012 5:14
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$
I think Noorain's solution is the excellent among all replies.
gr8 Noorain.
Divaker
On Thu, Jul 5, 2012 at 6:22 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
** **
=SUM(--(LEFT($E$4:$E$23,8)=B4)*$F$4:$F$23) with CSE
** **
* *
*Regards*
*Rajan verma*
*+91 7838100659
Congrats Rajan this is the third time continuously. congratulation once again
Regards,
Lalit Mohan
On Thu, Jul 5, 2012 at 6:18 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Thank you all.. J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com
Dear SG.
Please try it..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim ECol As Long 'Last Column
Dim lRow As Long
Dim BRow As Long 'Last Row
Dim
hi Noorain,
thanks alot.I haven't tried this.Before trying, i would like to ask some
queries.I'm not too good in macros...will this macro reduce the size of
files placed at share drive or should i open all files on share drive
then run this macro at my end??? Please clear my doubts on it.
Its working well
Thanx!!
On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Deepak,
Please use below code...
Sub N_spilit_Worksheet()
Dim i As Long
Dim k As Long
Dim j As Long
Dim rng As Range
Dim sh As Worksheet
On Error Resume Next
Set sh =
Dear SG,
Please open all files on share drive then run this macro at your end.
Revert me if get any issues in it.
On Thu, Jul 5, 2012 at 7:12 PM, SG sonal...@gmail.com wrote:
hi Noorain,
thanks alot.I haven't tried this.Before trying, i would like to ask some
queries.I'm not too good in
Hi
Its counts are not coming correct
Pls check on this.
On Thu, Jul 5, 2012 at 7:16 PM, Deepak Rawat deepakexce...@gmail.comwrote:
Its working well
Thanx!!
On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Deepak,
Please use below code...
Sub
Since you already have it filtered why have separate sheets. Simply add rows at
top and use a subtotal(109. Or a separate sheet with sumifs for each city
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Deepak Rawat
Sent: Thursday, July 05, 2012 8:26 AM
To:
Dear All,
I want to Compress all the files(.zip) to the specified folders with the
password..Where i will have a passwords towards that file names..
have attached sample Password list..
I need a VBA Code...
--
*Best Regards,*
*Venkat *
*
*
*
*
*
*
--
FORUM RULES (986+ members already
Try this, might help.
http://www.excelfox.com/forum/f10/activate-ribbon-tab-excel-2007-2010-a-50/
If it doesn't, can you post your XML code?
Regards,
Sam Mathai Chacko
On Thu, Jul 5, 2012 at 5:59 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Group,
I made a custom menu and ribbon icon
Pankaj then check your filter settings of mails.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pankaj gmail account pankaji...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Jul 2012 13:19:17
To: excel-macros@googlegroups.com
Reply-To:
Hi all,
i want help regarding range selection from worksheet.
i have created 1 macro to select specific range from sheet and for that
matter i have used below mentioned code
Sheets(sheet1).Select
ActiveSheet.Range(C7:BS37).Select
my macro should work on range which i have mentioned in the
try something like this
a2 = sheet name
b2 = cell adress
Sub test()
Sheets(Range(a2).Value).Range(Range(b2).Value).Select
End Sub
On Thu, Jul 5, 2012 at 10:47 PM, Avinash avinash007pa...@gmail.com wrote:
Hi all,
i want help regarding range selection from worksheet.
i have created 1
Awesome
Jhakaa.!!!
Thank You So Much...!:)
On Thursday, July 5, 2012 10:51:16 PM UTC+5:30, ashish wrote:
try something like this
a2 = sheet name
b2 = cell adress
Sub test()
try this see if it helps
Sub Scan_my_outlook_inbox()
'TOOLS -Refrence - microsoft outlook
'declare outlook objects
Dim olapp As Outlook.Application
Dim olappns As Outlook.Namespace
Dim oinbox As Outlook.Folder
Dim oitem As Outlook.MailItem
Dim myItems As Outlook.Items
Dim i As Long
i = 2
'set
---
You've been invited by Vishwanath to use Google Talk.
If you already have a Google account, log in to Gmail and accept this
chat invitation:
http://mail.google.com/mail/b-a4b38dd589-e244be0d28-ZcZgsAYcG4j1bijAsRsh5Purqhk
To
---
You've been invited by Vishwanath to use Google Talk.
If you already have a Google account, log in to Gmail and accept this
chat invitation:
http://mail.google.com/mail/b-a4b38dd589-b737a56e20-WJs5adlbt2F2kMJWJK0mqrtMbFQ
To
Hi All,
Similar to below one.
can any one help me in pasting a table from a excel sheet into a new
outlook window with left alignment.
Thanks in Advance.
Regards,
Vinay
-- Forwarded message --
From: David Grugeon da...@grugeon.com.au
Date: 1 July 2012 17:10
Subject: Re:
Dear Ashish Ji,
thanks but i m not getting the result, can you please send me the add
in or anything else for it
regds
ROHAN
On Thu, Jul 5, 2012 at 10:58 PM, ashish koul koul.ash...@gmail.com wrote:
try this see if it helps
Sub Scan_my_outlook_inbox()
'TOOLS -Refrence - microsoft outlook
36 matches
Mail list logo