Check if your macro is disable
ALT + T M S
And enable all macros
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alogon
Sent: Jan/Sat/2012 04:05
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Why my Excel
Hi
Save your file in xlsm or xls format
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of alogon
Sent: Jan/Sat/2012 04:05
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Why my Excel procedure disappears?
Hello Excel
Hi Kaushi,
please find the below link.
http://www.mrexcel.com/tip107.shtml
On Sun, Jan 22, 2012 at 3:58 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi,
How to convert pdf file to excel without any pdf converters?
regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED
Rajan,
i Tried removing the sheets and tried executing this macro bt it is not
executing.
Please fix this...
Thanks alot for your help in this concern.
On Sun, Jan 22, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi Rekha
See the attached sheet..
Don’t delete
Thanks for the reply.
Mr Excel tip requires a software named as Able2Extract professional.
I don't want to use any software/converter.
I want VBA Code for conversion.
Please help me.
Regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Interesting. I post a solution which has one line,
Private Sub CommandButton1_Click()
Me.Cells(Rows.Count, 1).End(xlUp)(2).Value = Me.TextBox1.Text
End Sub
and this is what's being posted
Private Sub CommandButton1_Click()
Range(A4).Select
Selection.End(xlDown).Select
Hi rekha.
I clearly mention that don't delete the summarySheet..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rekha siri
Sent: Jan/Sun/2012 04:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fwd: Need help in building pivot
Try this Macro:
http://quickvba.blogspot.com/2010/12/import-pdf-in-excel.html
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of xlstime
Sent: Jan/Sun/2012 04:40
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Converting pdf
It's about adding single quotes.
Check http://www.excelfox.com/forum/f2/excel-application-onkey-parameter-285/
Regards,
Sam Mathai Chacko
On Sun, Jan 22, 2012 at 2:16 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi
Save your file in xlsm or xls format
-Original Message-
From:
Before making any macro, the question is, will Sheet1 have all the
twelve periods in row2., or that also has to be put with the
macro?
Instead of making volunteers do guess work, might be easier if you
EXPLAINED what EXACTLY is required.
Sam
On Sun, Jan 22, 2012 at 6:26 PM, chandra sekaran
Dear Candidate,
*Kindly do not change the subject line while sending your CV.
Location: Gurgaon
Designation: Business Analyst
Band: 28
Shift timings: 3.30 pm to 11.30 pm
Responsibilities:
The Client Management (CLM) Team is responsible for the management and
development of our existing
The sender of this email is registered with Naukri.com as Careernet
Technologies Pvt Ltd
Experience required for the Job: 2.5 - 8 years
Job Location: Bengaluru/Bangalore
http://apply.naukri.com/Apply/mn_Apply.php?applytype=singleApplyMode=1src
hi don
Thank for your reply,
it is working fine if i put Sheet2.B6 Value
Period: 04.2011
Sheet 2. Range M to O should be copy
Period: 05.2011
sheet2 rangeP to R should be copy
Now object Variable or with block Variable not setError Message
comes
Regards
chandru
My macro assumed that already had entered the Period: 04.2011, etc in the
destination sheet.( where the button is) and that the data came in on the FIRST
sheet in the file in the SAME format as the destination sheet.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: chandra sekaran
That code not working too.
Pls suggest.
Regards,
Kaushik Savla
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
Hi Don guillett
Thanks I understand your Code itis working Fine
Thank you very Much Don,
Regards
Chandru
On Sun, Jan 22, 2012 at 8:30 PM, dguillett1 dguille...@gmail.com wrote:
My macro assumed that already had entered the Period: 04.2011, etc in
the destination sheet.( where the
Dear Kaushik,
Please use below code, hope it will help to you..
Sub ImportPDFFileData()
'Author: Steve Lipsman
'Purpose: Import PDF File Data Into Excel Worksheet
'Other Requirement(s): 'Acrobat' Checked in VBA Tools-References
'Reference Renames Itself 'Adobe Acrobat 9.0 Object Library' After
Dear Nathan,
Problem #1 is that your MainProcedure has strLeter as the parameter name,
but you test for strLetra. strLetra would always be an empty string, So no
output, making it appear MainProcedure never gets called.
Quick Fix: change
Sub MainProcedure(strLeter As String)
to
Sub
Makes you wonder. However, sometimes solutions don't get received as shown.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Sam Mathai Chacko
Sent: Sunday, January 22, 2012 6:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to make
rajan i dint remove summary sheet and raw data sheet but still its not
executing.
only rest of sheets were deleted bt its opening bu list and stopping there
On Sun, Jan 22, 2012 at 6:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi rekha.
I clearly mention that don’t delete the
Hi Group,
How to use spin button with text box in a user form.
Attached is the sheet in which I need help
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Rajan i could able to find out the root cause.
i deleted sub delete module below and call delete function line
now its working fine
Thanks,
Rekha
On Sun, Jan 22, 2012 at 11:10 PM, rekha siri rekha.siri2...@gmail.comwrote:
rajan i dint remove summary sheet and raw data sheet but still its not
Nathan,
The REAL problem is as I mentioned in using the quotes. And if the
intent was just to show a message, you could remove the IF statement
also. Look at the simple lines of code below.
Sub UsedShortCutKey()
Application.OnKey ^+a, 'MainProcedure a'
Application.OnKey ^+b,
Private Sub SpinButton1_Change()
TextBox2.Text = SpinButton1.Value
End Sub
Sam Mathai Chacko
On Mon, Jan 23, 2012 at 12:01 AM, santosh subudhi
santoshkumar.subu...@gmail.com wrote:
Hi Group,
How to use spin button with text box in a user form.
Attached is the sheet in which I need
hi,
thanks but its showing
error in line
Dim appAA As Acrobat.CAcroApp
user defined type not defined alert is comming whn this program is run
with regards
raghu
On Sun, Jan 22, 2012 at 9:52 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Kaushik,
Please use below code, hope it will
Dear All,
Good Morning !!!
Appreciate your help on the query of below attached sheet.
Thanks in advance.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
Oops, Attachement.
On Mon, Jan 23, 2012 at 9:03 AM, Excel_Lover idforex...@gmail.com wrote:
Dear All,
Good Morning !!!
Appreciate your help on the query of below attached sheet.
Thanks in advance.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Attachment missing
On Mon, Jan 23, 2012 at 11:33 AM, Excel_Lover idforex...@gmail.com wrote:
Dear All,
Good Morning !!!
Appreciate your help on the query of below attached sheet.
Thanks in advance.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Dear Excel Lover,
Please see attached sheet..
try it..
=INDEX($H$6:$H$80,SMALL(IF($I$6:$I$80=1,ROW($H$6:$H$80),),ROW(A1))-5)
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
On Mon, Jan 23, 2012 at 11:20 AM, Talent Capital India
shrit...@talentcapitalindia.com wrote:
The sender of this email is registered with Naukri.com as Talent
Capital India
*Experience required for the Job:* 5 - 7 years
Apply
Dear Noorain,
Thanks for your reply,
but its not getting changed if I am changing value of Cell *E1*
I should be changed according to the value of E1.
Thanks for your understanding.
On Mon, Jan 23, 2012 at 9:30 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Excel Lover,
Please see
Thank you very much boss,
On Mon, Jan 23, 2012 at 10:11 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Excel Lover,
Please check and change value of Cell E1.
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
You are welcome dear
On Mon, Jan 23, 2012 at 12:48 PM, Excel_Lover idforex...@gmail.com wrote:
Thank you very much boss,
On Mon, Jan 23, 2012 at 10:11 AM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Excel Lover,
Please check and change value of Cell E1.
Thanks regards,
thank you sir
On Sat, Jan 21, 2012 at 9:55 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Private Sub CommandButton1_Click()
Dim lngDays As Long, lngActualDays As Long
On Error Resume Next
lngDays = Day(DateSerial(Year(TextBox2.Value),
Month(TextBox2.Value) + 1, 0))
Dear Experts
I attached a VBA form. How to save the data in charaterwise entered in that
form into the excel sheet ?
regards
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
35 matches
Mail list logo