$$Excel-Macros$$ Extract images from PDF files easily.

[Zeeshan Sid]

Looking for the best way to extract the images from a PDF file? With the 
new PDF extractor tool, you can easily extract images from PDF 
 file. 
The tool can extract photographs and other graphical data from PDF files 
without any data alteration and data loss. It is 100% secure and does not 
cause any data manipulation while extracting the images.

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/f09c9b0f-e7d1-4b1d-bf21-3c140ca7710co%40googlegroups.com.

$$Excel-Macros$$ Re: Excel Password Recovery

[Zeeshan Sid]

There are several ways by which you can recover the password of an 
encrypted Excel file. 
For more info:- 
https://www.sysinfotools.com/blog/restore-password-protected-excel-files-without-software/

>
On Friday, July 3, 2009 at 5:01:11 PM UTC+5:30, debas...@gmail.com wrote:
>
>  
> Dear All, 
>  
> I have an Excl file  which is password protected. Unfortunately I forgot 
> the passward.  is there any way to recover the password ?
>  
> Kindly suggest,
>  
> Thanks and Regards ,
>  
> Debashis. 
>

-- 
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/98e202ea-9597-4b81-a3d0-f72b68236ea8o%40googlegroups.com.

$$Excel-Macros$$ Re: significance of sign in formula

[Sid Guevara]

Dear Shantanu,

Siti Vi is quite right, you do need Ctrl+Shit+Enter to enter the array
formula.  Also, you could simplify your formula a little by using a
double minus for the SUMPRODUCT, and do away with the IF. Minus minus
(--) converts SUMPRODUCTs TRUE/FALSE values to 1s and 0s.  So you get:

=SUMPRODUCT(--($G9:$AS9=BV$3)*($G$9:$AS90),$G$4:$AS$4)

Hope this helps,

Sid.


On Oct 12, 7:59 am, shantanu chouhan chouhanshanta...@gmail.com
wrote:
 Dear all experts

 i am using a sheet where a cell containg a formula

 cell:{=SUMPRODUCT(IF(($G9:$AS9=BV$3)*($G9:$AS90),1,0),$G$4:$AS$4)}

 where if i duble click or delete this sign {} the out come is

 cell:#VALUE!

 shatanu
 please help me out

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

$$Excel-Macros$$ Re: significance of sign in formula

[Sid Guevara]

Oops, I forgot to mention, if you type the formula as I wrote it;
=SUMPRODUCT(--($G9:$AS9=BV$3)*($G$9:$AS90),$G$4:$AS$4) and then
press Ctrl+Sfit+Enter, Excel automatically adds the braces {} to
denote an array formula.  DO NOT type them yourself, or it will be
interpreted as text...

On Oct 13, 9:22 am, Sid Guevara sid.gueva...@gmail.com wrote:
 Dear Shantanu,

 Siti Vi is quite right, you do need Ctrl+Shit+Enter to enter the array
 formula.  Also, you could simplify your formula a little by using a
 double minus for the SUMPRODUCT, and do away with the IF. Minus minus
 (--) converts SUMPRODUCTs TRUE/FALSE values to 1s and 0s.  So you get:

 =SUMPRODUCT(--($G9:$AS9=BV$3)*($G$9:$AS90),$G$4:$AS$4)

 Hope this helps,

 Sid.

 On Oct 12, 7:59 am, shantanu chouhan chouhanshanta...@gmail.com
 wrote:

  Dear all experts

  i am using a sheet where a cell containg a formula

  cell:{=SUMPRODUCT(IF(($G9:$AS9=BV$3)*($G9:$AS90),1,0),$G$4:$AS$4)}

  where if i duble click or delete this sign {} the out come is

  cell:#VALUE!

  shatanu
  please help me out

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

$$Excel-Macros$$ Re: Sort and then extract digits from 7 to 25

[Sid.]

Hi Skanda,

It probably looks something like this (you may have to tweak the Row/
Column values depending on the overall structure of your worksheet)

Sub Select_Char7to25()
'
'
Application.Goto Reference:=R6C2
Range(B6).Select
ActiveCell.FormulaR1C1 = =MID(RC[-1],7,19)
Application.Goto Reference:=R1000C2
ActiveCell.FormulaR1C1 = =MID(RC[-1],7,19)
Selection.Copy
Range(Selection, Selection.End(xlUp)).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub

Kind regards,

Sid.

On Aug 1, 4:49 pm, Skanda skanda.pokkun...@gmail.com wrote:
 Hi All,
   The report that I generate is sorted on column S and then it is hidden
 using VBA code.After the sorting is done I want to display only characters
 from 7 to 25 from row b6 to B1000.
 Eg.  PM 00  New York,NY. We need to diaplay only  New York,NY.How to
 do this programatically?

 Thanks,
 Skanda.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Question re: cell comments and validated lists

[Sid.]

That's it exactly!  Many thanks Dave,

Sid.

On 1 Aug, 13:32, Dave Bonallack davebonall...@hotmail.com wrote:
 I forgot to say that the drop-down is in C1

 Regards - Dave.

  Date: Sun, 1 Aug 2010 01:36:25 -0700
  Subject: $$Excel-Macros$$ Question re: cell comments and validated lists
  From: simon_mc_webs...@yahoo.co.uk
  To: excel-macros@googlegroups.com

  Good Evening Gurus,

  I have a quick question (the answer to which has probably been staring
  me in the face all day!).

  Is it possible to make a selection from a drop down validated list and
  have the associated comment attached to the cell in that list 'follow'
  the selection to the target cell?

  For example, if I have a drop down target cell validated from a list
  of four items, each with a picture comment attached. How can I get
  the item chosen in the target cell to acquire the pictorial comment
  from cell chosen from the list, and change dynamically when a
  different value is chosen?

  Any thoughts?

  Thanks in advance,

  Sid.

  --
  --
  Some important links for excel users:
  1. Follow us on TWITTER for tips tricks and links 
  :http://twitter.com/exceldailytip
  2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
  3. Excel tutorials athttp://www.excel-macros.blogspot.com
  4. Learn VBA Macros athttp://www.quickvba.blogspot.com
  5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com

  To post to this group, send email to excel-macros@googlegroups.com

  
  HELP US GROW !!

  We reach over 7000 subscribers worldwide and receive many nice notes about 
  the learning and support from the group.Let friends and co-workers know 
  they can subscribe to group 
  athttp://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com


HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe