Dear Shahzad,
Please try it..
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
Reference Is Saved
'Declare Vari
Dear group,
Is there any way to convert the PDF file to excel by MACRO.
Regards,
Aamir Shahzad
--
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)
Thanks Ashish. Good work.
But this UDF doesn't satisfy Criteria 3 i.e.
Criteria 3 --> Sorting order will be from B --> J.
(a) if you see in your solution file Row 6 & 7 (Name G & A) has count 4,
but Row 7 (Name A) should come first then row 6 (Name G), as Row 7 has
first highlight in Column C
Hi Paul,
I think the solutions given by Sam and Me are correct for your question and
fulfil your requirments. So please reply wat is wrong with our solution for
not use.
Regards
Prince
On Thursday, March 7, 2013 6:09:14 PM UTC+5:30, Paul Schreiner wrote:
>
> Thanks David,
>
> I subscribed to
Hi David,
You Did everything Correct except the way you are accessing the public
variable. For Accessing the public variable from Another work book you need
to add the reference of that work book into your current work book
then only you can use that variable in your current work book. For more
Hi Ayush.
I think it is a good initiative that will help us to recognize the person
who put their quality of time in delivering the answer with the quality.
Regards
Prince
On Thursday, March 7, 2013 9:24:58 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> Thanks for your active participati
I am in need of help in creating a fairly complex macro that will
sync/update changes from two sheets in one workbook to one sheet in another
workbook. However, only certain cell data is needed, not the entire column
or row.
The macro would run from the destination workbook and search by the
Hi all
I am using excel 14 (Part of Office Pro Plus 2010) on Win 7 Pro 32 bit. A
fairly standard setup.
The help file says
Public
Variables declared using the *Public* statement are visible to all
procedures in all modules in all applications unless *Option Private
Module*is in effect. In that
Hi everyone!
To begin with the post I would like to start sayin that I'm sry for any
english mistakes. Going ahead: I've a budget sheet that I would like to
insert an expense made on a credit card and, inform that that expense is
divided in, for example, 3 months, and that the sheet do the arr
sir,
pl accept my apology i m begineer in the group, and not familier with excel
progarmming too.
i need customer recoed database.
Thanks
NIK.
On Thu, Mar 7, 2013 at 11:10 PM, xlstime wrote:
> Hi Nik
>
> first of all please use proper subject line and which type database format
> you want i
Hello all,
I am wondering if I can be helped in this. I have two sheets 'Main' &
'Consumed' B col. of both sheets have Lot ID.
A macro should be written to see in Lot qty Cell D2 of sheet consumed,
check its lot ID in B2. Then go to Main sheet and trace the qty of that
lot in that sheet and s
Hi! everyone,
My name is Bruno Pitombeira, I live in Fortaleza - Brazil and I'm 30 yrs
old. I work as a financial supervisor and it's great to be among other
Excel lovers!
Em sexta-feira, 8 de junho de 2012 16h21min59s UTC-3, Ayush Jain escreveu:
>
> Hey all new and current posters,
>
> Welco
hi try this attached file
I have created a simple UDF to count cells in a range which are having fill
color red and once you have count. You can simply sort it
Regards
Ashish
On Thu, Mar 7, 2013 at 3:55 PM, Amit Gandhi wrote:
> Hi Experts
>
> I have an excel data and I want to sort data based
Hi Nik
first of all please use proper subject line and which type database format
you want i..e... Finance or customer record database type
please specify
.
Enjoy
Team XLS
On Thu, Mar 7, 2013 at 10:26 PM, nm wrote:
> Sir,
>
> i m into real estate business and want
Sir,
i m into real estate business and want to create a data base.
1) want to have a data base for my business with all the detail and where i
can also add some field as per my requirement.
2) further i want to use the said data base for my website too, i m planing
to have my website ( if any on
Dear members,
Let's keep this post to recognize the forum members who have helped you in
solving problem or has shared any knowledge in the forum.
Let see who recognize first here.
Thanks.
Regards
Ayush Jain
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(
That's probably for the best.
I know I appreciate the recognition (I even printed the certificate and have it
on display!)
but then, it makes me somewhat... skeptical? when I see people that post
answers that are NOT well thought out or tested. (like: a user asking how to
delete the contents of
Dear members,
Thanks for your active participation and taking this group to new heights.
This is to inform you that we are stopping the 'Most helpful Member' award
for the below reasons :
1) The award is based on only quantity of the posts and not the quality of
the posts. It is not possible fo
Visit this link to donload templates
http://office.microsoft.com/en-us/templates/address-and-phone-list-TC010196212.aspx
On Thu, Mar 7, 2013 at 10:43 AM, Kenil Gala wrote:
> Hi group,
> DO ant one have a telephone directory template where i can save my
> personal and bussiness phone nos. with
Hi Amar,
change cells with range
Sub Macro1()
Range("a:a").Replace What:="0", Replacement:="", LookAt:=xlWhole,
SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False
End Sub
On Thu, Mar 7, 2013 at 7:04 PM, Somnath Khadilkar wrote:
> Still Prob
> ==
Still Prob
R/ Prince, I just 'recorded a macro just clicked in some cell G8 and
stopped recording] and put your code in it., On exec. it says error,
you may pl have a look
Sub Macro1()
'
' Macro1 Macro
'
Sheet1.range("$A1$AZ1048576").clearcontents.
'
Range("G8").Select
End Sub
Thanks David,
I subscribed to the newsletter and purchased the book.
Now to see what new realms I can visit!
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all th
Dear Ashish,
Code is Good one,but if anyone want delete Zero or Zero Value cell only
from specific column then how to modified code
Pls suggest code
Regards
amar
On Wed, Mar 6, 2013 at 8:51 PM, ashish koul wrote:
> Hi Manjunath
>
> try this
> Sub Macro1()
> Cells.Replace What:="0", Replaceme
Yes. macros in open office are totally different from those in MS
Office as are the object models.
On 07/03/2013, anubha gupta <13gupta.anu...@gmail.com> wrote:
> I am using open office not MS office could it be an issue
>
> On Thursday, March 7, 2013 11:17:46 AM UTC+5:30, anubha gupta wr
Hi Experts
I have an excel data and I want to sort data based on below criteria using
Macro. pls help me here.
*Column B to J has data which is to be sorted as per Highlighted CELLS *
Criteria 1 --> Highlighted cells should come first.
Criteria 2 --> Row which has more highlighted cells from B t
Sent from my iPhone upknjkhm
Hmm mn
Lllppojv mllokollw Clopping pp
VXvx@,z
B joke kknnkkl
--
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 RUL
26 matches
Mail list logo
