Dear Ashish,
I just downloaded the Open Excel.
It looks like a neat set of features.
Excellent work...
Would like to contribute to it, whever I get some time...
Cheers,
Andy
On Sun, Oct 31, 2010 at 11:27 PM, Ashish Jain wrote:
> Dear Members,
>
> We're proud to launch OPEN EXCEL under the GNU P
Hi,
This is what I actually looking for. It works great and solves my query.
Thanks for your efforts and help.
Regards,
Sharma
On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa wrote:
> the sub test is just one example of how to use the function into a routine.
>
> Sub test()
> Dim s As String
>
Just downloaded the file. Let me play around with it for some time
before I can add any comment on its utilities. Somehow I was able to
see a few utilities which would be quite useful.
Warm regards,
Anand
On Oct 31, 10:57 pm, Ashish Jain wrote:
> Dear Members,
>
> We're proud to launch OPEN EXCE
Dear Andy,
This is working Good i believe in Tag There are many categories are
available separated by comma(,),(/).is it Possible to match All word so that
i can match maximum apart from Checking only one word.
Thanks for your Support,
Chandrabhan Singh
On Mon, Nov 1, 2010 at 1:47 PM, Aindril
Looks very useful
Kudos on the good job
Regards
Rajesh Shah
On 1 November 2010 13:10, anandydr wrote:
> Just downloaded the file. Let me play around with it for some time
> before I can add any comment on its utilities. Somehow I was able to
> see a few utilities which would be quite useful.
>
I use one book for portability of macros and I'd like to be able to
turn on and off a worksheet_change macro from the book, not by adding
the script to each individual worksheet. I can't find any information
on this anywhere, so I thought this would be a good place to ask. All
I can think of is w
Application.EnableEvents = true/false
allows you to turn on/off ALL events, not just sheet change events,
but also BeforeSave, close, activate/deactivate, etc...
If you only want to turn on/off a specific event handler,
you can declare a Public variable like;
Public ChangeFlag
Set it to true/fal
Dear Paul,
Thank you so much for all your contribution this month.Your consistent
support has helped all the group members very much. You are all time
top poster as well.
I am proud to have you in the group.
keep the spirit up!!
Regards,
Ayush Jain
Microsoft MVP
--
I've got a workbook in which a user inputs values into cells on sheet
1, and then the info is copied to a log sheet. I'm using the following
code to find the next empty row in the log sheet to paste the info:
With historyWks
lastRow = .Cells(.Rows.Count, "A").End(xlUp).Offset(1,
0).Row -
Jeff,
There are lots of ways of finding the "next" empty row.
In your case, is it possible that column "A" does not always have a value?
also... lLastRec = lastRow - 1 will give you the PREVIOUS row instead of the
NEXT row...
Perhaps that's what is causing the problem.
Wouldn't you use:
lLastRec
I've always said:
What good is having skills if you keep them to yourself?
Telling someone what you can do shows conceit.
Helping someone to do something shows talent...
Plus:
If you REALLY want to learn how to do something, try teaching it to someone
else!
Because THEY will always want to know
Thank you. I added EnableEvents = true and used the function I vound
"App_SheetChange" to access the sheet when things changed. Is that
right? It didn't seem to do what I wanted it to.
On Nov 1, 9:32 am, Paul Schreiner wrote:
> Application.EnableEvents = true/false
> allows you to turn on/off
Hi,
I have a rather long macro that controls and limits the printing
process for the end user. It works okay but after running and you
return to the spreadsheet the screen is very slow to refresh as you
scroll around the worksheet.
The macro gives the user the choice of viewing a filtered set of
Hi Paul,
We just love to hear these inspiring words from you...These are
absolutely great wordsYou are not only excel expert but an
inspiring mentor as well.
Keep guiding us.
Thanks.
Ayush Jain
On Nov 1, 8:34 pm, Paul Schreiner wrote:
> I've always said:
> What good is having skills if you
EnableEvents = FALSE
will cause the events to be turned off.
When it is off, changes will NOT cause the event handler macro to run.
That sounds like what you wanted.
But your description sounded like you might want OTHER event macros
to continue to run.
I guess I'll need a more detailed descrip
I have a code to copy some data from sheet to another
In the end of this code
There is some lines to set up page layout
"page setup"
Header and footer
This part of code doesn't work when I run my file on computer without
printer installed
And give me an error
The question is
How ca
I want to add a macro to the workbook that occurs when a worksheet is
changed. To be clear, I pass a macro workbook around to my colleagues
in order for them to have access to certain Macros. I'd like the
opening of that workbook to allow a macro that would occur even when
they change a worksheet
Ahh... got it.
I think I understand.
You have a macro "template" workbook
and "another workbook" open at the same time.
You'd like events in the second workbook to execute
the event macros in the "template" without adding
the event code in the second workbook...
I don't think you can do that.
The
HI,
Require you help in resloving the below issues...,
1. Linking the Sql Temporary table to Excel Spreed sheet(Note: i don't
have permission to creat tables as i am working on production server)
2. Require Macro for extracting the Compressed file, i have got the
macro but the user needs to selec
Hi Folks,
i have a querry in excel i need top three dates from a column for u r
reference go through my attachement and help me.
Thanks in Advance to all experts
mynampati
--
--
Some important links for excel users
Hi,
Your sample sheet gives insufficient and contradictory info.
Column B has a header which says "USED HERE LEFT FUNCTION" but there is no left
function used there - the data is just entered as text, and the length of text
varies, which means that the left function probably wasn't used.
Column
21 matches
Mail list logo
