Hi
check
http://www.rondebruin.nl/mail/tips2.htm
On Mon, Jun 6, 2011 at 11:48 PM, Mahesh parab mahes...@gmail.com wrote:
Hi
which version of Excel you are using ?
in 2007 its .SendUsingAccount property
in 2003 its .SentOnBehalfOfName property
can you send sample workbook.
Thanks,
Hi,
I've good knowledge of Advance Excel. Now i want to learn of to do
programming through VB, make macro's in VB.Can some one give me a link of
the tutorial thru which i can learn the basics of VB.
Thanks a ton..
Gagan
--
try this
http://akoul.blogspot.com/2011/02/merge-data-from-multiple-sheet-from.html
see if it helps
On Tue, Jun 7, 2011 at 2:37 AM, Greg gamoun...@gmail.com wrote:
Hi,
I am trying to use a macro which copies multiple workbooks into a
single workbook. However, something is going awry. The
check the websites and videos at listed o n the below links
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
On Tue, Jun 7, 2011 at 4:08 AM, Gagan Singh gaganvicky2...@gmail.comwrote:
Hi,
I've
Thanks its working
Worksheets(sheet2).PrintOut Copies:=2
On Mon, Jun 6, 2011 at 8:09 PM, ashish koul koul.ash...@gmail.com wrote:
try this
Worksheets(sheet2).PrintOut Copies: 2
On Mon, Jun 6, 2011 at 4:58 PM, jmothilal gjmothi...@gmail.com wrote:
Sir
i want print 2 copies for my
Simran
can you attach the sample file ..
On Tue, Jun 7, 2011 at 12:00 AM, Mahesh parab mahes...@gmail.com wrote:
Hi
check
http://www.rondebruin.nl/mail/tips2.htm
On Mon, Jun 6, 2011 at 11:48 PM, Mahesh parab mahes...@gmail.com wrote:
Hi
which version of Excel you are using ?
in
Hello Experts,
I need your assistance. I'v a workbook which has 4 sheet. I want to create a
automatically hyperlink (through formulae) when I change content of cell a2,
hyperlink automatically should change...Please help me.
Thnx
*---
кαяαηη*
--
Hi All Please help,
My excel file icon got changed and shows the internal data instead of standard
excel image
[cid:image001.jpg@01CC2522.109E5730]
[cid:image002.jpg@01CC2522.109E5730]
I wanted the standard excel image as my file view and
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 6 Jun 2011 13:20:10
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Dear excel guru,
I have a
Hi Karan,
Copy and paste the below formula in B2 cell of your Index sheet.
=HYPERLINK(
CONCATENATE([,MID(CELL(filename),SEARCH([,CELL(filename))+1,SEARCH(],CELL(filename))-SEARCH([,CELL(filename))-1),],A2,!B1),Click
Here)
or
=HYPERLINK(
Dear Karan find the attachment.
--
*Great day,*
*
Thamu*
On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 karan1...@gmail.com wrote:
Hello Experts,
I need your assistance. I'v a workbook which has 4 sheet. I want to create
a automatically hyperlink (through formulae) when I change content
Hi Karan,
please find attached file with the result.
i have included one formula in the same sheet for your reference.
thanks,
saber
On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 karan1...@gmail.com wrote:
Hello Experts,
I need your assistance. I'v a workbook which has 4 sheet. I want to
Hi,
Students English maths sceience Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90 b
sunyana 38 65 70 60-80c
sunitha 80 90 68 36-60
Thanks Ashish for your reply. When I use this macro I get the
following error message:
Compile error: User-define type not defined.
The following line in the macro code is highlighted:
Dim objShell As New Shell32.Shell
-Greg
On Jun 7, 2:22 am, ashish koul koul.ash...@gmail.com wrote:
try
hi sukumar,
please find attached.
regards,
saber
On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi,
Students English maths sceience Grades
suresha 45 80 90 90-100 A
srinivas 25 36 60 80-90
have you added Microsoft shell control and automation in refrences
tool - reference - Microsoft shell control and automation
On Tue, Jun 7, 2011 at 7:11 PM, Greg gamoun...@gmail.com wrote:
Thanks Ashish for your reply. When I use this macro I get the
following error message:
Compile error:
Hi Anil,
Try this,
Go to windows Explorer then
ToolsFolder OptionsFile Types tab and select XLSX files from the list.
Click on the Advanced button which will open up the Edit File Type dialog
and you should see the Change Icon button on the top.
Regards,
saber
On Tue, Jun 7, 2011 at 2:49 PM,
save this file in folder and run macro and the new file created will be
saved in the same folder automatically
On Tue, Jun 7, 2011 at 8:25 PM, Greg gamoun...@gmail.com wrote:
Ok, I've added Microsoft shell and the error message has gone away but
no file is created. I look into the folder I
To excel gurus
Pls do something Its become a nightmare sir to me.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: chhajersand...@gmail.com
Date: Mon, 6 Jun 2011 18:25:17
To: excel-macros@googlegroups.com
Reply-To: chhajersand...@gmail.com
Subject: Re: $$Excel-Macros$$
Good initiative Ayush and many thanks to Ashish.
I am having one doubt. Some job application needs to be filled up
online and hence external link is mandatory. Please suggest.
Best Regards,
DILIPandey
On 6/7/11, Ayush jainayus...@gmail.com wrote:
Dear members,
There is an idea shared by
Hello ,
I would require an excel cash book that would do the following things
1. Payments to party ( Debit )
2. Receipts from party ( Credit )
The operator should be able to enter only like the
Select Credit / Debit Entry
Enter Party Name :
Enter Cash Denomination :
Inward denomination -
OK... I've a problem. I've got the gist of this... but it's just
not working for me.
In worksheet 'Source Data', in Cell A5 is the Title for A Column ..
DEMO PROJECT, and subsequent data beneath that (starting A6)... (These
are addresses).
There are some data in columns B-K, but don't want these
I am exporting some data from a logistics company and the tracking #'s
are 18 digits but when they go into my CSV, they are in scientific
notation and when I make them numbers the last digits default to
zeroes. Any ideas?
--
It helped very much Ashish, thank you again for your kind teachings.
John
On Fri, Jun 3, 2011 at 1:43 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith johnasmit...@gmail.comwrote:
Need help please extracting specific data from
i guess you want to create addin in excel check the link below
http://www.ozgrid.com/VBA/excel-add-in-create.htm
On Wed, Jun 8, 2011 at 2:13 AM, programmernovice programmernov...@yahoo.com
wrote:
Hello, I need to an Excel macro that will click a button on the
toolbar. A drop-down menu
can you share the excel file
I am not sure whether this will help you or not ,can you run the below macro
once in ur workbook
Sub BreakLinks()
'Author : Ken Puls (www.excelguru.ca)
'Macro Purpose: Break all links in the active workbook
Dim vLinks As Variant
Dim lLink As Long
'
try this
Sub TEST()
Rows(2: Range(A1).End(xlDown).Row).Copy
Sheets(Detailed).Select
Sheets(Detailed).Range(A65356).End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Sheets(Detailed).Range(A1: E
Sheets(Detailed).Range(A1).End(xlDown).Row).Sort
key1:=Sheets(Detailed).Range(a:a),
Thnx again to all of you for solving my problem. You all are great!
*---
кαяαηη*
On Tue, Jun 7, 2011 at 4:39 PM, mohd saber md.saber2...@gmail.com wrote:
Hi Karan,
please find attached file with the result.
i have included one formula in the same sheet for your reference.
thanks,
28 matches
Mail list logo