Search results

@Luke M thanks for liking it... @Debraj I rarely use word so hadn't seen this button at all.Thanks for sharing this. Looking at these options of MS Word, excel looks a 'poor cousin' of Word to me. Cheers Rudra

Hi, Are you looking for something like this? sDir = "E:\" & InputBox("Enter your Path", " Path Please") P.S. I have not tested your code. With Regards Rudra

Hi I don't know about subfolders but I use below code if I have to create multiple folders at once. Option Explicit Sub CreateFolders() Dim Cell As Range Dim MyPath As String Dim MyRange As Range MyPath = ThisWorkbook.Sheets(1).Cells(2, 1) Set MyRange = Range(Cells(3, 3), Cells(3...

Hi All, This is not a question but a trick I learned recently. I have to deal with such excel files which are converted from pdf or are downloaded from internet. Most of the times there will be line breaks within the cell(Alt + Enter or Chr(10)). When I was very new to excel,to clean my data, I...

Hi GK, Please go through this link. http://msdn.microsoft.com/en-us/library/office/ff838253(v=office.15).aspx. to Print Activesheet Sub PrintActiveSheet() ActiveSheet.PrintOut End Sub To Print All the Sheets of Workbook Sub PrintAllSheets() Activeworkbook.printout End Sub To Print Selected Range...

Thanks Hui, I had got the .chm file from that link only...Went through the links provided...did I forget to say thanks for that?...:)..Question to myself..."What did you understand?". My Ans: Have 2010 also installed in your system. You may write off my idea but ..I don't have to worry about...

Thank you SirJayBeeSeven.

Hi Friends, I have downloaded 'Excel 2013 Developer Documentation.chm".Is there anyway that if I press F1,excel should take me to local help not to internet as it used to be in earlier version of excel?I have placed this chm file in my desktop. Do I need to place it somewhere else? Thanks for...

Hi Ganesh, If you want saveas filedialog to open everytime you print the sheet, I would suggest you to use activsheet.printout. With Regards Rudra

Abhijeet you can use Nitro converter, this tool converts pdf to any format like excel,word,ppt or image. Or you can use Foxit PhantomPDF where you have an option to save as excel and others. But my favorite is nitro. With Regards Rudra

Hi you may modify this to meet your requirement. Function NumberOnly(Entry) For i = 1 To Len(Entry) ThisChar = Mid(Entry, i, 1) Select Case Asc(ThisChar) Case 48, 49, 50, 51, 52, 53, 54, 55, 56, 57 NumberOnly = NumberOnly & ThisChar End...

Hi All, Was just curious to know if I happen to learn any new trick, can I share it here? If yes how? With Regards Rudra

@ sirJB7, Thanks for your reply. *.* yeilded folders also, which I didn't want...is it a trick to April Fool me? I used wildcard "*" instead. Unfortunately this is lunch time so can't make coffee either..I almost fooled my parent by coming to this world on 2nd April. ::::Rudra.

FYI, It is Telegu and Kannada new year too.... Rudra

@iferror Thanks for your reply, I want to use VBA because I don't want to get into each SubFolder and look for certain files and copy them to different location.Regarding code you mentioned, I am getting Error @ ShowFolderList f1. With Regards Rudra

Hi All, After doing lots of googling I have come here. I am looking for a VBA code which should copy all the files from Folder and Subfolder to one location. It shouldn't copy the folder but only the contents. I got Ron's code but my requirement is slightly different. Wish you happy weekend. Rudra

Thanks Smallman, This works fine for me.I must say you are a master of 'Array'. With Regards Rudra

Abhijeet, You can not perform any calculation in this unless you add 0 to your result or multiply your result by 1.You may find =(TEXT(A1,"hh.mm"))+0 bit more useful. With Regards Rudra

@ Smallman, Thanks for your explantion.But I am not gonna slap myself because I know what and why I am asking this.I am well aware that we are in 2014. Why I asked this is afterall we are trying to find whose birthday is falling on today's date and year becomes irrelevant here (Original Post...

@Smallman, I have got few questions on this, would you mind to explain them? 1. what does Array(2, Date) mean? 2. I changed Cell(C6) of Sheet("New") to 3/26/2013 and macro didn't print formula next to this cell.Why? attaching file herewith With Regards Rudra

@iferror Good Formula

I think this can also be used... LastRow.Offset(1, 0).Value = Val(TextBox1.text) Rudra

Hi, My Version is here.. With Regards Rudra

@ All, Thanks for your suggestions. Special thanks to Vijay.vizzu for the links..I will go through them whenever time permits(am in office now). With Regards Rudra

Hi Vizzu, You seem to be guiding me to correct direction. I had already tried VBA code at the event of file opening and it was successful also, but in someof the systems macros are disabled,hence it failed.. You said,"Your code should force them to enable the macros ", how to do this? Usually I...