send the attachment
On Monday, May 18, 2015 at 5:19:18 PM UTC+5:30, Nitin Balodi wrote:
Hi Mandeep,
Thanks for the response, I have tried that and getting same result and I
cannot give predefined rows range since these are filtered out during run
time.
Regards.
Yours Sincerely,
Hi Nitin,, use this
Dim errormessagecode, copydata, msg As String
On Error Resume Next
Sheets(2).Activate
ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=19, Criteria1:=N/A
ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=10,
Criteria1:=Array(4-Resolved, 5-Closed, 6-Cancelled),
Sorry Mandeep, I cant share the file due to confidentiality issue, but I am
looking for a generic solution for this issue.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 18 May 2015 04:55:09 -0700
From: rockerna...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in the database name available A,B,C,D,E only then the
data for each should be make separate.
Thanks in advance.
Regards
Nasir Shaikh
--
Are you =EXP(E:RT) or
Thank you Mandeep i did it.
On Friday, May 15, 2015 at 9:01:41 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
Here can you please help me out with the code to paste snapshot on outlook
mail.
Thanks
Nasir Shaikh
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Do you want to Create separate sheets on the basis of column.???
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered by user and also some sub-totals as a
result of formula.
How do I have a formula to add all the entered figures only, excluding the
sub totals. Maybe sumif with is formula ?
Thanks
CharlesHarris
--
Are you
Can we have the sheet ???
On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote:
Hi
XL2000
Have searched for this with no luck.
Have a column with figures entered by user and also some sub-totals as a
result of formula.
How do I have a formula to add all the entered
Hi,
I am trying to read a nested recordset persisted through Access into Excel.
This all work fine by accessing the recordset fields property except when
the nested elements are empty. This means that the loaded data can end up
in the wrong column cell when using the fields index and trying
Thanks Mandeep!!!
Thanks
N.Sundarvelan
9600160150
On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
Go to file option Click on open then export it to excel , you can export
any folder to a excel file.
Regards,
Mandeep Baluja
On Monday, May 18, 2015 at
But I want Macro Excel File that will auto update all mail details in excel
periodically.
Please help!!!
Thanks
N.Sundarvelan
9600160150
On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N nsund...@gmail.com wrote:
Thanks Mandeep!!!
Thanks
N.Sundarvelan
9600160150
On Mon, May 18, 2015 at
Thanks Mandeep for reply.
Below is the column in which we required separate Tablefor each LOB.
*LOB Name* Health Personal Accident Engineering Health Personal
Accident Health Miscellaneous - Package Health Health Personal Accident
Health Health Health Personal
Hi Mandeep
Sheet attached.I want to check that the total of entries only adds up
to grand total. A double check to make sure everything in. Say total of
E11:E220
Thanks
Charles
On Monday, May 18, 2015 at 7:05:40 PM UTC+12, Mandeep Baluja wrote:
Can we have the sheet ???
On
Can you please mark color yellow to those cells which needs to be sum !!
On Tuesday, May 19, 2015 at 6:18:46 AM UTC+5:30, sswcharlie wrote:
Hi Mandeep
Sheet attached.I want to check that the total of entries only adds up
to grand total. A double check to make sure everything in. Say
On the button click create a new workbook and copy your data save your
workbook with .csv extension with the help of VBA code.
Regards,
Mandeep Baluja
On Tuesday, May 19, 2015 at 10:13:44 AM UTC+5:30, Ahmed Bayagon wrote:
Hello Guys,
I am trying to create a Button on Sheet1 named
check the attached macro
Sub Macro1()
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Sheets
If sht.Name ActiveSheet.Name Then
sht.Activate
Union(Columns(1), Columns(3), Columns(5)).Copy
Set wb = Workbooks.Add
wb.Sheets(1).Paste
wb.SaveAs Filename:=C:\Users\Mandeep.baluja\Desktop\k.csv
Hello Guys,
I am trying to create a Button on Sheet1 named Create CSV's where it will
take selective columns from other sheets i.e. Sheet 2, 3 etc and create csv
file.
How should I write a macro that will do something like this.
Any Inputs appreciated.
Regards,
AB
--
Are you =EXP(E:RT)
Further to this the same error occurs if I try to use the recordset to get
the same information
Set myRecordset = New ADODB.Recordset
myRecordset.Open C:\Temp\cust.xml, Provider=MSPersist,
adOpenUnspecified, adLockUnspecified, adCmdFile
Set TableSchema =
Hi,
I have so many product name and would like to import picture according to
my product name.
Anyone would able to help me some coding in VBA?
I have looking so many forum and study some of the coding but not go so
well on it.
I'm very appreciate someone able to help me.
Use this code basically it use the Autofilter technique to create sheets
and use of collection class to remove the duplicates.
Sub Macro60()
'Step 1: Declare your Variables
Dim MySheet As Worksheet
Dim MyRange As Range
Dim UList As Collection
Dim UListValue As Variant
Dim
Thanks dude
but I need code to make separate sheet for each LOB as these needs to
assign work to each individual.
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
Why you're not using the pivot table feature to create this, Create pivot
and use this column in row field to create separate sheets. only 6 are
required, but if you still wish you can use the code for the same.
Health Personal Accident Engineering Miscellaneous - Package Liability
Brother the code which you have given it is for excel.
I am talking about MS Access
On Monday, May 18, 2015 at 1:42:30 PM UTC+5:30, Nasir Saikh wrote:
Hi Experts,
I want to split table from main table with their names available in column
For example.
I have a database in the
Enable outlook library in reference and use this code. you can change the
date criteria to get the updated mails.
Sub GetFromInbox()
Dim olApp As Outlook.Application
Dim olNs As Namespace
Dim Fldr As MAPIFolder
Dim olMail As Variant
Dim i As Integer
Set olApp = New
Hi Champs,
I am getting error in copying filetered cells. Below is the code snippet. Point
to note is this works well when I test this code by running step-by-step (i.e.
by using F8 key) but when run as a complete code it gives me an error:
Assign sheet names while defining a range to be copied. means you should
use Sheet(Name).range(A1:A100) instead of Only Range and send me the
snapshot of error.
Regards,
Mandeep baluja
On Monday, May 18, 2015 at 4:31:22 PM UTC+5:30, Nitin Balodi wrote:
Hi Champs,
I am getting error in
Hi Mandeep,
Thanks for the response, I have tried that and getting same result and I cannot
give predefined rows range since these are filtered out during run time.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 18 May 2015 04:10:25 -0700
From: rockerna...@gmail.com
To:
27 matches
Mail list logo