,
Check the following link
http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601.
it might be of some help to you
Regards,
VIJAYKUMAR
On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote:
I have attached a sample file
Thanks Ashish Jee
Both the codes are working fine for one picture, but what if I wants to
insert to picture instead of one?
Thanks
Pravin Gunjal
-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Fri, Jun 7, 2013 at 8:02 PM
Subject: Re: $$Excel-Macros$$ Insert
Hi,
I want to convert the date =Today() to this format : DD.MM.
Formula =Today() 6/14/2013 In next cell, it should display as :
14.06.2013
Sample file is attached. Thanks.
Regards
Pravin Gunnjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
I want to convert the date =Today() to this format : DD.MM.
Formula =Today() 6/14/2013 In next cell, it should display as :
14.06.2013
Sample file is attached. Thanks.
Regards
Pravin Gunnjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Dear Mr Vijay,
Thanks for it. I tried the same but it's not working. I am using 2007
version.
Example:
When I paste any link to word its displaying correctly as :
https://login.yahoo.com/config/mail?.intl=us
but when I hit on enter button it's getting changed as : {HYPERLINK “
I have date in this format : *DD.MM.* (with dot) and require it as : *
DD-MMM-* (with hyphen).
For example : I have* 01.04.2013* and want it to be displayed as *
01-APR-2013*
Kindly give me the formula. Thanks
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
@googlegroups.com
Select cell, right click, format cell, custom type DD--.
You can use text(cell,DD-MMM-) also.
Thanks
On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal isk1...@gmail.com wrote:
I have date in this format : *DD.MM.* (with dot) and require it as : *
DD-MMM-* (with hyphen
Thanks Prabhu Vaibhav,
I am trying to paste any link in a new file only and even though it's
happening; I don't know why.
There might be somewhere setting is changed.
Regards
Pravin Gunjal.
-- Forwarded message --
From: VBA VABZ v...@vabs.in
Date: Sat, Jun 22, 2013 at 5:06 PM
Dear Ahmed,
Thanks it's working fine.. Nice to see you here after long time..
Regards
Pravin Gunjal.
-- Forwarded message --
From: Ahmed Honest ahmedhon...@gmail.com
Date: Sat, Jun 22, 2013 at 5:51 PM
Subject: Re: $$Excel-Macros$$ Date format to be changed
To: excel-macros
Thanks Mr Vijay. Now I could see the links which I had copied from browser.
Regards,
Pravin Gunjal.
On Sun, Jun 23, 2013 at 2:12 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:
Respected Pravin,
You remove the chech box for internet under Autoformat tab and also under
Auoformat as you type
*May I know how to take a screenshot with the shape given below. Thanks.*
[image: Inline image 1]
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
But how it's getting changed automatically?
-- Forwarded message --
From: koul.ash...@gmail.com
Date: Mon, May 6, 2013 at 4:31 PM
Subject: Re: $$Excel-Macros$$ 8 become 0
To: excel-macros@googlegroups.com
**
Change the format of cell to text or add ' in front of number
Sent on
, in this
situation. Thanks in advance.
*With regards,**
**Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Hi Anoop
I do not want to restrict my folder from unnecessary access instead I want
it to be used by others.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Anoop K Sharma aks.sharm...@gmail.com
Date: Thu, Jul 4, 2013 at 5:36 AM
Subject: Re: $$Excel-Macros$$ Files / Folders
Hi Anoop,
Thank you for valuable information. Is there any option to create a
back-up / auto up-dation in some other location, and not in the same folder.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Anoop K Sharma aks.sharm...@gmail.com
Date: Thu, Jul 4, 2013 at 1:28
Can I get some more suggestions on this topic.. Thanks.
Regards
Pravin Gunjal.
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Jul 4, 2013 at 2:14 PM
Subject: Fwd: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com
Thanks everyone for your valuable reply. I will try with it to get the good
result.
Thanks again.
Regards
Pravin Gunjal.
De Premor d...@premor.net
viahttp://support.google.com/mail/bin/answer.py?hl=enctx=mailanswer=1311182
googlegroups.com
7:11 AM (11 hours ago)
to excel-macros
To keep
,
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Thu, Jul 11, 2013 at 11:01 AM
Subject: Re: $$Excel-Macros$$ Files / Folders Sharing Query - reg.
To: excel-macros@googlegroups.com
Why didn't you write your own code, i was send enough sample code
*Dear Premor,*
* *
*Please accept my sincere thanks for doing so much of work for me..*
*
*
*Regards*
*Pravin Gunjal.*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Jul 11, 2013 at 11:29 AM
Subject: $$Excel-Macros$$ Files / Folders Sharing Query - reg
And what about if the value is same in both columns.
-- Forwarded message --
From: priti verma pritiverma1...@gmail.com
Date: Mon, Jul 15, 2013 at 5:28 PM
Subject: Re: $$Excel-Macros$$ Challanging queri
To: excel-macros@googlegroups.com
HI rupali ,
good job
On Mon, Jul 15,
Hi DP
I too applied the same condition (pl see the green background in same
sheet), but the result shown is different.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Jul 15, 2013 at 7:30 PM
Subject: Re: $$Excel-Macros$$ Challanging
to the head quarters only.
Regards,
VijayKumar
On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi, I need to extract the data from one sheet to multiple sheets based on
column A.
That means the separate sheets must be created Head Quarter wise with
it's total line. And Row
post the file at group.
-- Forwarded message --
From: Kaushal Kumar kaushal.anal...@live.com
Date: Wed, Jul 17, 2013 at 5:54 PM
Subject: $$Excel-Macros$$ Un hide a workbook
To: Excel VBA Group excel-macros@googlegroups.com
Dear All,
When I am opening an excel file it seems it
It's awesome.
-- Forwarded message --
From: Anonymous singhoram...@gmail.com
Date: Wed, Jul 17, 2013 at 5:57 PM
Subject: $$Excel-Macros$$ Re: Help Required
To: excel-macros@googlegroups.com
Hi All,
I've found a more simpler way to get the time in hrs and minute..
And yes i've
Dear Lerner
Not Understood.. Because it's getting updated in the file sent by me.
Regards
Pravin Gunjal.
-- Forwarded message --
From: excel lerner exceller...@gmail.com
Date: Sat, Jul 20, 2013 at 10:15 AM
Subject: Re: $$Excel-Macros$$ formula required to update values form one
2013 07h29min47s UTC-3, Pravin Gunjal
escreveu:
Hello,
I would like to translate this attached PDF texts (words) in to English to
work out on it. I tried my best but couldn't get the exact result. Can
someone help me out and inform, how to do it. Thanks in advance!
*With regards
You can change as follows :-
=ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0)
Regards
Pravin Gunjal.
-- Forwarded message --
From: SAJID MEMON sajidwi...@hotmail.com
Date: Tue, Aug 6, 2013 at 2:10 PM
Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE
Hello,
Can I get help from you to remove extra space / enter from column C in
the attached sheet. Pl do the needful.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re: $$Excel-Macros$$ Extra Space Enter
/2013 17:49, Pravin Gunjal menulis:
Thanks DP for your immediate response.
Could you please inform the meaning of this formula for my understanding.
Regards
Pravin Gunjal.
-- Forwarded message --
From: De Premor d...@premor.net
Date: Mon, Aug 26, 2013 at 4:08 PM
Subject: Re
Dear Team XLS
Is this a secure email? as i got some security warning.
Please confirm.
Regards
Pravin Gunjal.
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Thu, Aug 29, 2013 at 5:58 PM
Subject: $$Excel-Macros$$ Very important document
To:
Good day,
Please view
-- Forwarded message --
From: veeru che1indi...@gmail.com
Date: Fri, Aug 30, 2013 at 8:15 PM
Subject: Microsoft Excel Re: vlook up button for single click
To: microsoft-office-2...@googlegroups.com
no one solved my problem?
On Monday, August 19, 2013 12:40:44 PM
)
.
Enjoy
Team XLS
On Fri, Oct 18, 2013 at 10:59 AM, Pravin Gunjal isk1...@gmail.comwrote:
*Hi,*
* *
*I want to take the values from Apr to Mar sheets from “BT” column in
this sheet.*
*I have used this formula “=Apr!BT4”, but if I use this formula then I
need to change the month
*May crores of lamps lighten up your life,*
* With endless happiness, richness,*
*Health wealth forever,
Wishing you and your family a very **Happy Diwali.***
* *
*[image: image005.jpg]*
* *
*With regards,**
**Pravin Gunjal**
***
*Veritaz Healthcare Ltd, Hyderabad*
*
*
*Contact
This also can be used: =COUNTA(D2:D15)
Regards
Pravin Gunjal.
On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes rbar...@hcsgcorp.com wrote:
You are a GENIUS!!!
On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Are you looking for this?
=COUNTIF($D$2:$D$15,S
Hello,
Is there any new updates on this subject? As periodically it's changing.
Please suggest a good company and let me know what are all the accessories
and other facilities should I check before buy.
Look forward to hear from all experts.
Thank you,
Regards
Pravin Gunjal
Greetings!
I am having a data containing a word called ACTIV. And would like to
highlight only this word out of the cell with a *specific color (BLUE) *and
*BOLD*
(only this word and not other words in the same cell)
Could you please help me on this issue.
Regards
Pravin Gunjal
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent
Thanks Ravinder
Also would like to do it *BOLD*. Pl help.
On Thu, May 8, 2014 at 4:32 PM, Ravinder ravindervbacli...@gmail.comwrote:
Pfa for your solution
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Pravin Gunjal
*Sent:* Thursday, May
Dear Vabz
It can be moved by a button.
On Tuesday, May 13, 2014 12:35:15 PM UTC+5:30, Vabz wrote:
what is trigger for moving?
On Tue, May 13, 2014 at 12:22 PM, Pravin Gunjal isk...@gmail.comjavascript:
wrote:
Dear Friends,
I would like to update the data from sheet viz. Sales
you.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Hello,
I have attached an excel file. The data is already entered in this file.
The Qty column must be multiple of Pack column. If it is correct then
it should display: Correct otherwise Incorrect in Result column.
Hope you would help me. Thank you.
Regards
Pravin Gunjal.
--
Are you =EXP
Hi,
I wanted to convert the dates in this format *DD.MM.*
Now it is not in system's date format ( MM/DD/ ) and it is displayed as
DD/MM/ or as D/M/.
Kindly help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
Dear Pramod,
Thank you for your reply. But I found it is not giving result for all
cells.
Please do the needful.
On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh pramod...@gmail.com wrote:
Hi
Pravin Gunjal,
PFA
Hope This will fine for you..
Warm Regards
Pramod
VBA Developer
, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
I wanted to convert the dates in this format *DD.MM.*
Now it is not in system's date format ( MM/DD/ ) and it is displayed
as DD/MM/ or as D/M/.
Kindly help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
This is working perfectly as per my requirement.
Thanks.
Regards
Pravin Gunjal.
On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS excel-macros@googlegroups.com wrote:
Hi Pravin ...
You can go to Format cell and custom the format of the date which ever
result you
Hello,
I would like to email the attached data once for all in a single click from
column A to H to the respective customers as per email id mentioned in
column I.
Kindly help me on this matter. Pl find attached test file for the same.
Thank you in anticipation.
Regards
Pravin Gunjal
attached test file for the same.
Thank you in anticipation.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
those divisions parties which comes under Veritaz
Both
Likewise if I select the drop down in Hospin sheet, then the party list
should come which comes under of Hospin Both division.
Thank you,
*Regards, Pravin Gunjal.*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Any idea on this !!
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Thu, Jul 3, 2014 at 11:03 AM
Subject: Drop Down Option - reg.
To: excel-macros@googlegroups.com
Hello,
I have three sheets in the attached file.
I have created a name manager in master
with any of the background colors.
Kindly do the needful. Thank you,
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1
a solution to overwrite the data second time in
the same sheet: Party Wise Hope the matter is clear. Thank you in
anticipation.Sub Paryt_Wise()'' Paryt_Wise Macro' Pravin Gunjal''
Sheets(Pending CN).SelectSheets(Pending CN).Copy
Before:=Sheets(1)Sheets(Pending CN (2)).SelectSheets(Pending
*Hi Paul :* If I add this code in my code it creates new sheet and deletes
immediately. Pl look in to this.
*Hi Ashish :* Your file is creating new sheet every time but I want the
same sheet to be overwritten with changes.
Thank you,
On Thu, Nov 13, 2014 at 7:46 PM, Ashish Kumar
Thank you everyone.
On Fri, Nov 14, 2014 at 5:42 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Pravin,
PFA!!
Edit your data in Pending CN and Highlight the row which you want to paste
in Party Wise and hit the macro.
Regards
Ashish
--
Are you =EXP(E:RT) or
Hi
I am working with it and observed that while opening the window for batches
it's taking much time. Can we do something for it.
On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Thanks. Pravin ...!!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Thanks.
On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi,
Hardly it's take 3 second for showing Batch Details.
Did you checked the count of Batch Data which was in the user form. The
Count is more than 5000. It's heavy..!!
Yes We have two more
Hi Good Evening
I am working with foxpro and unable to save DBF files in excel 2007 while
saving it's asking to save in current formats of excels.
Can you tell me is there anyway to overcome from this issue / any solution
because I do not have 2003 version and having only 2007.
Thanks,
Pravin
Hi,
Please help me out on the above subject.
Thank you
Pravin.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
[image: Inline image 1]
Hi,
Suddenly I am getting the above error while opening the excel file and
macro is not running.
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
.
Thanks,
Pravin Gunjal.
On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
That usually is a problem with References.
try these steps:
Stop execution of macro
in VB Editor, select Tools- References...
you'll find several libraries selected.
But you might see one
Good Morning,
It's fantastic...
On Mon, Jan 19, 2015 at 9:13 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Dear Pravin jee
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this
Dear Ashish jee
Its fine and working good as per requirement. Thank you.
But it would be much better, if any pop-up will appear here in Batch column
to select the batches out of many. In pop-up if we type any starting
letter then only those batches should appear which contains that typed
*Hi, Can I expect a reply from anyone..*
On Friday, January 16, 2015 at 4:13:20 PM UTC+5:30, Pravin Gunjal wrote:
Hi,
I have attached an excel file contains 4 sheets..
I am entering mu data in fourth sheet viz. GRRN Entry -which has connected
with first three sheets.
*What I want
It's *Lot Number (column D)*
On Sat, Jan 17, 2015 at 5:28 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
which field you want to pick as batch in GGRN sheet from Batch sheet.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join
don
On Sat, Jan 17, 2015 at 5:55 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Share the password ...?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Thank you so much.
This is what I was looking for...
On Tue, Feb 17, 2015 at 10:31 AM, Mandeep Baluja rockerna...@gmail.com
wrote:
check this worksheet event.
regards,
Mandeep
On Monday, February 16, 2015 at 7:49:23 PM UTC+5:30, Pravin Gunjal wrote:
Hi Mr Paul
The user name of excel
can,In all the ways you
can,In all the places you can,At all the times you can,To all the people
you can,As long as ever you can.” - John Wesley*
-
*From:* Pravin Gunjal isk...@gmail.com javascript:
*To:* Excel Macros excel-...@googlegroups.com
*Hello Friends,*
*I need to have a file which may record the Login Logout time of
computer. I am using Windows XP.*
*Thanks in anticipation.*
*Regards*
*Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook
Sheet
under CHQ filed before Ambika Agencies. So the No. will come as 1 in main
sheet in cell : C5.*
*I hope it is possible. Kindly help me out on this subject. It can be
very very helpful for me in day to day activities. Thanks a lot in
advance.*
Regards
Pravin Gunjal
--
Are you =EXP
Hi Vabs
Set rng = Application.InputBox(Select cell/range for which you want to
update chq no., Type:=8)
For the above function can we make following cells by default:
*C4 to C21*
*F4 to F21*
*I4 to I21*
*O4 to O15*
Because I want the result to be come in these cells only.
Regards
Pravin Gunjal
), Range(D4:D21),
Range(G4:G21), Range(J4:J21), Range(M4:M15))
ᐧ
On Wed, Jan 14, 2015 at 5:44 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Vabs
Set rng = Application.InputBox(Select cell/range for which you want to
update chq no., Type:=8)
For the above function can we make following cells
Hi,
The user name to be picked up by formula in the column *L* once the value
is entered in column *K*
I have entered few names manually. Please help.
*Regards, Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
, Vaibhav Joshi v...@vabs.in wrote:
Hi
pl send code to test on, also what is your MS office version?
On Thu, Feb 5, 2015 at 2:07 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi
I tried this one and un-ticked MISSING from libraries and tried to Save
As the file with existing.
Then it says
Hello,
Can anyone help me to modify save DBF files in Excel 2007.
Pravin.
On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote:
Hi,
I tried working on it but could not do the same.
Could you please explain me how to do it or is there any other solution
for which I i would like to give next C serial then I would
type C in cell D8 and then then next number 1327 must come in E8
automatically.
Hope you understand the requirement. Please do the need.
Thank you,
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi Vabs
Thank you much. It works good as required.
Pravin.
On Tue, Mar 17, 2015 at 1:51 PM, Vaibhav Joshi v...@vabs.in wrote:
Check this...
Cheers!!
On Tue, Mar 17, 2015 at 11:35 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hi,
I have an excel format 2007 for daily data entry
Hi,
I tried working on it but could not do the same.
Could you please explain me how to do it or is there any other solution for
this. Please do share.
Thank you
Regards
Pravin Gunjal
On Tuesday, February 3, 2015 at 9:45:31 PM UTC+5:30, Paul Schreiner wrote:
That usually is a problem
Hi Vabs
Any updates on this please.
Regards
Pravin Gunjal
On Wednesday, February 11, 2015 at 5:00:32 PM UTC+5:30, Pravin Gunjal wrote:
Hi Vabs
Following is the code:
Function savedbf() As Boolean
Dim filename As Variant
Dim temp As Variant
Dim currentFile As String
Dim
,As long as ever you can. - John Wesley*
-
*From:* Pravin Gunjal isk1...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Wednesday, February 18, 2015 7:21 AM
*Subject:* $$Excel-Macros$$ Computer Login Logout Time Record
*Hello Friends,*
*I need
Can anyone help me on this issue plz.
On Oct 21, 2015 3:26 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
> Hi Mandeep
>
> The code you have replaced in this mail has to be replaced in other
> sheets also of the same file.. file is attached for your immediate
>
Hi
Greetings!
Getting an attached error while opening files of VBA.
Kindly help me to resolve the same.
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https
one manual entry in row no. 7.
Could you please help me out to fulfil the requirement.
Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussex
Hi Friend
could you plz helm me out on the issue.
Thanks in advance.
Regards
Pravin Gunjal
-- Forwarded message --
From: "Pravin Gunjal" <isk1...@gmail.com>
Date: Oct 26, 2015 4:02 PM
Subject: VBA to pick up current date in last column
To: "Excel
Hi Friend
pl help me out to replace a macro in all sheets of the same file. Or any
other solution may welcome.
Thanks
Pravin Gunjal
On Oct 22, 2015 1:09 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
> Can anyone help me on this issue plz.
> On Oct 21, 2015 3:26 PM,
Dear Mandeep
Thank you so much.. it works fantastic.
Can you tell me one more thing, how to modify the vba code in all sheets...
Regards,
Pravin Gunjal.
On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rockerna...@gmail.com> wrote:
> check this out !!
>
>
>
>
>
Hi,
Greetings,
I have used a simple macro in an attached file
But while pasting or deleting the data in multiple cells, getting following
error:
Run-time error '13':
Type mismatch
Kindly help me out on this. Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hi,
Greetings,
I have used a simple macro in an attached file
But while pasting or deleting the data in multiple cells, getting following
error:
Run-time error '13':
Type mismatch
Kindly help me out on this. Thank you,
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT
Hi,
I am getting an above mentioned error message while running any macro on my
computer, while the same macro could run in other computer.
Could you please help me out on this. Thanks,
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
os.html
>
> On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal <isk1...@gmail.com> wrote:
>
>> Hi, Can anyone help me on this subject?
>>
>> On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal
>> wrote:
>>>
>>> Hi,
>>>
Hi, Can anyone help me on this subject?
On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal wrote:
>
> Hi,
>
> I am getting an above mentioned error message while running any macro on
> my computer, while the same macro could run in other computer.
>
> Cou
Hi Expert,
Can i get a macro which can remove all existing macros from a file on certain
date..
Kindly share the same. Thanks.
Regards
Pravin Gunjal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Hi any update on this plz.
On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
> Hi Expert,
>
> Can i get a macro which can remove all existing macros from a file on
> certain date..
>
> Kindly share the same. Thanks.
>
> Regards
&g
BE.activeVBProject.Vbcomponents
> vbcom.remove Vbcomponent:=_
> vbcom.item("Module1")
> End sub
>
> If you find any difficulties please let me know
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal" <isk1...@gmail.com> wrote:
>
>> Hi Expert,
>>
>> Can
Yes exactly. On specific date.
On Dec 24, 2015 3:53 PM, "jayaraj metta" <jayaraj.me...@gmail.com> wrote:
> Hello Pravin Gunjal,
> Do you want to delete modules in a project using a macro?
> Can you please elaborate it ?
> On Dec 23, 2015 7:45 PM, "Pravin Gunjal&qu
Hi
I have some macro in file and suppose i want to remove them after 4 days.
So is there any such macro available which can work on my requirements.
Thanks
Pravin Gunjal.
On Dec 24, 2015 5:53 PM, "jayaraj metta" <jayaraj.me...@gmail.com> wrote:
> "Existing macro on c
Thanks for reply. The path and file is unique. One sheet was hidden at the
time of screenshot taken on other computer.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Wed, Jun 8, 2016 at 5:14 PM, B Sharma <sharma@gmail.com> wrote:
> Hiii Pravin,,
> From your s
Hi Experts,
May I have any solution on this subject please.
On 30 May 2016 16:55, "Pravin Gunjal" <isk1...@gmail.com> wrote:
> Dear Friend,
>
> Greetings!
>
> I have 3-4 computers in shared network. In one of them there is an excel
> file which contains data
t;).Cells(NumRow, "C").Value
>
> If (Dict_Data.exists(RecID)) Then
> Sheets("Sheet1").Cells(NumRow, "E").Value =
> Dict_Data.Item(RecID)
> Else
> Sheets("Sheet1").Cells(NumRow, "E").Value =
computers & access, but other can't access mine
though it is shared. Kindly help. Thanks,
Following is the screenshot:
*With regards,*
*Pravin Gunjal*
*Mobile: 77100 *
*97250*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offi
Hi,
Greetings!
I want the data in *column E (Sr.No.)* of sheet1 from sheet2, if column B,
C & D are matches in both sheets. PFA file.
Look forward for good formula. Thanks,
Regards,
*Pravin Gunjal*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TI
101 - 200 of 229 matches
Mail list logo