Search results

Hi all, I am trying to convert a pdf file to excel without any installation of software since my company policy does not allow to install any external software. Problem one: could open the pdf and copy to excel, but only copies the first page and not the rest. Problem two: to bypass problem...

What version of excel are you using? For me it worked fine with excel 2016.

save the file as ".xls" that should work fine. .SaveAs filename:=Path & fname & "_" & Terminal & ".xls"

Hi there, I am looking for potential solution to one of my problems: Problem: Huge mailbox sizes which need to be reduced. Idea: create a VBA code to automatically delete the oldest emails from said folders once the overall mailbox size reaches 30GB, deleting emails from archival folder...

Is there a potential that chandoo.org would come as a mobile application as well to have more easier access to the forum?

@bosco_yip , the formula is quite interesting. How does the "-" symbol make the formula get the value?

Rohit, do you have the macro and using it for the copy paste OR you need the syntax for one? Also probably did you try to change the format of the column?

I does not sound quite clear to me, probably an example should suffice..

Congrats Hui!! Many more to go....:)

Wulluby, Have you mentioned a specific selection before the formatting? would it be possible for you to mention the whole code?

iRasim, Basically, the above code that you have mentioned will add pagebreaks between each rows. For instance, you selected that A1:A5 so that will add page breaks to all the rows between A1:A5. It completely depends what range you select, however this will not be as per criteria rather its...

Ok, so firstly you will need to add a userform, to do that below is the procedure: 1. Goto the visual editor(alt+F11) - insert - userform 2. If you are not able to see the toolbox then goto View-Toolbox 3. From the toolbox add a combo box & a textBox alongwith two buttons. 4. Caption the...

Yes Amit, this can be done using the workbooks.open module You have to add a userform to this module to track the user ID & password and then if valid credentials then pass the details to column K. Let me know if you require any help in building the macro code.

Hi Aurum, I didnt had a look at your/Somendra's attachment, but as per what I understand from a list of True/False values you wish to get the desired ones only. So if you are ok with using VBA, here is the code you can try (Some tweaks might be required): Sub blanks_del() Dim drc As Long drc...

Hi John, I am not fairly sure if I follow you, do you mean you want the counts in Cell AF14? Or do you want to to get the position of the first number from the Col.Q?

Hi BK LAAL, Considering that your date field is in cell A1 and you wish to do this in excel itself, you can use the below: =IF(TEXT(A1,"mm-dd-yy")=TEXT(NOW(),"mm-dd-yy"),"TODAY",IF(TEXT(A1,"mm-dd-yy")=TEXT(NOW()-1,"mm-dd-yy"),"YESTERDAY",TEXT(A1,"mm-dd-yy"))) Please let us all know if this...

I had tried this earlier, this is not changing colors but a regular progress bar..trying referencing it... Option Explicit Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Const PI = 3.14159265358979 Sub DemoProgress1() Dim intIndex As Integer Dim sngPercent As...

Thanks and wish you the same....:cool:

Thanks Sachin and Deb....those formulas work great... @deb: Nice signature....:)

Hi Luke, Was just going thru my old threads and have a small query on the above mentioned by you... Say we are not sure about the instances but want to capture the text after the last instance? Example: (Mike/Alpha/Charlie/Foxtrot) :here I want to capture only after the text after the last...

SirJB7 has rightly mentioned that you should declare response as "variant". @SirJB7 : Can you emphasize on the use of option explicit? Even I am not aware of its advantages...:)

Works fine for me.. Have you copy pasted the whole code? Or just a bit of it?

Hi Kevin, Try using the below: Sub Sheet_Nm() response = InputBox("Name of the Sheet?", vbOKCancel) If response = False Or response = "" Then MsgBox "Invalid Name" Exit Sub Else ActiveSheet.Name = response End If response = "" End Sub

=IFERROR(SUMIF(Sheet2!$A$1:$A$3,Sheet1!D2,Sheet2!$B$1:$B$3)-(SUMIF($D$2:$D2,D2,$F$2:$F2)),-(F2)) Works fine and give the correct results...

I like the new Tip above the commenting window...this will remind the people to add the VB code in the correct window for right presentation...Good update...