Hello all
I need to prepare the reconciliation report for my company and send it to
all the person who is responsible for their a/c.
I will be filling the date in the reconsheet only for column E and now I
need to send only the a/c and the details for which they are handling.
I need formulas to
Thanks Vaibhav,
It was great but I discussed with my boss. He said we need salary slip in
separate files so is it possible that as we click on the micro first it
create a new file after it send in e-mail id(and password also be
implements).because employee print out it.and accounts deptt also need
Note my question and resolve, Please...
I want to execute a process through Excel VBA while;
Any user is working on a Workbook he want to send the same workbook as
attachment from Excel menu (already available) and excel save this file in
temp folder of outlook before attaching, while the open wor
Dear Experts,
I am facing a problem to extract characters from right of string.
Please help.
Thanks in advance.
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
While the Goal Seek feature is interesting and I thank you for
bringing it up, I don't think it answers my problem.
I'm attempting to make a predictive model, so I'm looking for a method
to determine the best X and Y value to fit the data set. So, while X
and Y certainly change from record to reco
We have a requirement to run a templated output for a WebFocus report
that include the capability to have the output ready to print. In
other words, a user should be able to see the exact printout available
when the Excel opens by clicking on "Print Preview".
Issues:
1.) The output can be anywa
try the file ... you can changed the number of columns for the split
regards
r
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
sorry is:
s =VBA.Environ ("appdata")
fso.BuildPath s = (s, "Microsoft")
fso.BuildPath s = (s, "Excel")
fso.BuildPath s = (s, "excel*.xlb")
regards
r
2010/11/25 roberto mensa
> I see you've changed the page I would have used even
> s =VBA.Environ ("appdata")
> fso.BuildPath s = (s, "Micr
I see you've changed the page I would have used even
s =VBA.Environ ("appdata")
fso.BuildPath s = (s, "Microsoft")
fso.BuildPath s = (s, "Excel")
since excel until 2003 version also runs on mac
regards
r
2010/11/25 roberto mensa
> hi Ashish
> in my Italian version it does not work
The number of rows for each column I want to choose
The main data like this
1
2
3
4
5
6
7
8
9
I want it on new sheet like this
1 4 7
2 5 8
3 9
I choose the number of ro
hi all,
in addition to the suggestions had already... try
Option Explicit
'>>
Public Sub Tester()
'for each open workbook
Call Dimagrire
End Sub
'<<
'>>
Public Sub Tester2()
'for one open workbook
Call Dimagrire("Pippo.xls")
End Sub
'<<
'--
the best download excel gant that i know is here:
http://www.riolab.org/index.php?option=com_content&view=article&id=76:diagramma-di-gantt&catid=47:excel&Itemid=68
for the page traslate in english:
http://translate.google.it/translate?js=n&prev=_t&hl=it&ie=UTF-8&layout=2&eotf=1&sl=it&tl=en&u=http%
Thanks Ashish
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "OpenExcel.com"
Sender: excel-macros@googlegroups.com
Date: Thu, 25 Nov 2010 05:40:23
To: MS EXCEL AND VBA MACROS
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Speed up Excel Start Up (FA
hi Ashish
in my Italian version it does not work. It has to be changed Application
Data into Dati Applicazioni.
While sub test runs properly:
Sub test()
Dim s As String
Dim fso, f, e
Set fso = CreateObject("Scripting.FileSystemObject")
s = VBA.Environ("appdata")
s = fso.BuildPa
Hi,
I have downloaded gnatt chart from web. Please can anyone explain how to do
this chart in steps.
Thanks
Chandra Shekar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and lin
Hi Girish,
I was just going through your attached VBA code. I have observed that in
many places your VBA code is using excel formulas. As per my experience the
more you will use excel formula in your spreadsheet it will slow the
performance of your spreadsheet. You can turn the automatic calculati
Hey Friend,
The script needs to be run in 'Application Data --> Microsoft -->
Excel'. If you can go here manually then VBA code must run fine.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http
perhaps I was misunderstood because of my bad English, i don't know where is
the problem, I would not have asked ... is correct?
where come you want to run the script?
something goes wrong permissions?
regards
r
2010/11/25 OpenExcel.com
> Ok Robert, then what is the problem?
>
>
> ___
Dear Experts,
I have attached one VBA Code which we are using regularly
for huge data it is running very slow
is there any way to make it faster
Pls Suggest
Thanks in advance
Girish
--
Warm Regards,
*Girish Sherigar*
* (¨`·.·´¨) *
*`·.¸(¨`·.·´¨)* *Keep*
* (¨`·.·´¨)¸.·´ Smiling!*
* `·.¸.·´
Hi,
I am working on it. Will send you by tomorrow.
Thanks for waiting.
On Thu, Nov 25, 2010 at 10:03 AM, Ankit Agrawal
wrote:
> Sir ji,
>
> I think it does not have any solution that why no body given any ans.or any
> solution.
>
>
> -- Forwarded message --
> From: Ankit Agrawa
Hi Friends,
A useful post on reducing the excel workbook size. This may reduce the
file size dependently from 10% to 500% .
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Thanks & Regards
Ashish Jain
(Microsoft Certified Application S
Hi Sundarvelan,
Read this article or use VBA Macro mentioned thereby:-
http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http:/
You are right Robert. When user don't mention their excel version. We
can not go back to old version unless specified. This code works on
both 2007 and 2010.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Pro
Ok Robert, then what is the problem?
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Nov 25, 5:13 p
2010/11/25 OpenExcel.com 26may.1...@gmail.com
> A reference to 'Visual Basic for Applications' must be
> made in order to access VBA Object model.
>
>
yes of course.
regards
r
--
--
Some important links for excel
Dear Ashish,
Thanks for the Questions.:-)
Love&Regards,
Sreekanth Nambiar
9916941744
On Thu, Nov 25, 2010 at 5:10 PM, OpenExcel.com <26may.1...@gmail.com> wrote:
> Hi Sreekanth,
>
> This is not confirmed but ya they are general Excel VBA interview
> questions. Might be of your help.
>
> 1.
Hi Sreekanth,
This is not confirmed but ya they are general Excel VBA interview
questions. Might be of your help.
1. Difference between ByVal and ByRef
2. Meaning of Option Explicit and Option Base
3. Size of Integer and Long Data Type
4. Various Lookup formulas(HLOOKUP,VLOOKUP,LOOKUP,MATCH,INDEX
Hi Robert,
Just a quick check. May be I sound foolish but please check
references. A reference to 'Visual Basic for Applications' must be
made in order to access VBA Object model.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(
Hi Robert,
What kind of problem?
VBA.Environ("appdata") can be used irrespective of the OS(must be
windows).
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.
Thank you
it is really helpful
Small formula worked well
On Fri, Nov 19, 2010 at 10:57 AM, sumit kumar wrote:
> Dear Sumanth
>
> Here is ur solution...hope this solve ur query.
>
> Regards
> Sumit
>
> On Fri, Nov 19, 2010 at 9:58 AM, sumanth kumar wrote:
>
>> Dear All,
>>
>> Can you please pro
hi Ashish,
There are problems to use VBA.Environ("appdata") ?
regards
r
2010/11/25 OpenExcel.com <26may.1...@gmail.com>
> Hi Friends,
>
> Visit
> http://www.excelitems.com/2010/11/speed-up-excel-start-up-faster-excel.html
> on http://www.excelitems.com
>
>
>
> ___
Dear Experts,
Can you please help me with Excel-VBA interview questions?
Thanks&Regards,
*Sreekanth M
*Mobile:9916941744
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi
You have to Delete all un used coloumn and un used row
Affter that u can Create CSV File
On Thu, Nov 25, 2010 at 3:20 PM, wrote:
> Hi
>
> You have to clean up all your sheets. i.e. Re-Set excel last cells by
> deleting un used cells.
>
> Delete all un used coloumn and un used row.
>
> Sent
Hi Sundarvelan,
First, the actual problem need to find out. Only then it can be solved
in an efficient manner.
1. How many worksheets do you have?
2. How many rows and columns are occupied in each worksheet?
3. How many charts and pictures have been used?
Reduction of file size depends on thes
Hi
You have to clean up all your sheets. i.e. Re-Set excel last cells by deleting
un used cells.
Delete all un used coloumn and un used row.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sundarvelan N
Sender: excel-macros@googlegroups.com
Date: Thu, 25 Nov 2010 12:54:02
Hi Friends,
Visit
http://www.excelitems.com/2010/11/speed-up-excel-start-up-faster-excel.html
on http://www.excelitems.com
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems
36 matches
Mail list logo
