Re: $$Excel-Macros$$ while using activex controls, i have been facing attached snpshot message

Hi It is first time you are facing this problem? Are you running code first time? Did you try changing file name & re- run macro? How many excel file are open while you are running this code? How many Instance of excel are running? How many parallel application are running? What is your vers

Re: $$Excel-Macros$$ Need help with Run Time Error 424 "Object required"

cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 11:09 PM, Rob Flott wrote: > > Vabz...Thank you very much for the explanation and fix...it works... > > Rob > On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: > >> hi >> >> You

Re: $$Excel-Macros$$ pdf file rename

Welcome Chintan -- 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, Urgen

Re: $$Excel-Macros$$ pdf file rename

Many many thanks to all of you. Regards, Chintan On Tue, Dec 16, 2014 at 10:42 PM, Vaibhav Joshi wrote: > > Good one ashish!! > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 16, 2014 at 9:33 PM, Ashish Kumar > wrote: >> >> Hi Chintan, >> >> PFA >

Re: $$Excel-Macros$$ pdf file rename

Thanks Vaibhav Bhai. On 16 December 2014 at 22:42, Vaibhav Joshi wrote: > Good one ashish!! > > + > *I did not do this for you. God is here working through me for you.* > > > -- 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 F

$$Excel-Macros$$ Re: [5]

What kinda buttock name ya got there WillieWanker? On Monday, December 15, 2014 6:56:40 AM UTC-5, black panther wrote: > > Click here to see this full message >

Re: $$Excel-Macros$$ Need help with Run Time Error 424 "Object required"

Vabz...Thank you very much for the explanation and fix...it works... Rob On Friday, December 12, 2014 12:53:25 AM UTC-8, Vabz wrote: > hi > > You will get error if no value is added in list box. > > add line "on error resume next" in beginning to avoid this error.. > > cheers > > + > *I

Re: $$Excel-Macros$$ pdf file rename

Good one ashish!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 9:33 PM, Ashish Kumar wrote: > > Hi Chintan, > > PFA > > > Regards > Ashish > > -- > 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

Re: $$Excel-Macros$$ Re: pdf file rename

Its cool bro.. + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 7:30 PM, Mandeep Baluja wrote: > > Kindly find the solution. > Regards, > Mandeep Baluja > LearningZmyPassion > https://www.linkedin.com/profile/view?id=312532939 > https://www.faceb

Re: $$Excel-Macros$$ Urgent help

Mr. Aptech... Check this.. Goto Input sheet, Pres Alt + F8 to run macro.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:54 PM, Rakesh kumar wrote: > > I want all, whatever the is available on sheets. > > On Tue, Dec 16, 2014 at

$$Excel-Macros$$ Re: while using activex controls, i have been facing attached snpshot message

Hi Sir, i tried to copy all the code and controls into new workbook still i have been facing the same problem please guide me in this regard , thanks lot On Monday, 15 December 2014 18:10:46 UTC+5:30, renuka chari wrote: > > Dear Experts, > > please solve the enconter problem

Re: $$Excel-Macros$$ pdf file rename

Hi Chintan, PFA Regards Ashish -- 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 P

$$Excel-Macros$$ Re: pdf file rename

Kindly find the solution. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Tuesday, December 16, 2014 6:08:11 PM UTC+5:30, chintz wrote: > > Hello Friends, > > I have a lots of files(.pdf) in one folder

Re: $$Excel-Macros$$ Re: pdf file rename

Hi You can try this if you are using outlook. Select all file in folder & right click on send it to mail recipient. Now all files will be added to OL mail & in body you will have all files names. Just copy & paste it to your excel file & filter it out!! or check this VBA http://www.xl-central.

$$Excel-Macros$$ Re: pdf file rename

I am beginner in VBA and don't know how to create macro code . On Tuesday, December 16, 2014 6:08:11 PM UTC+5:30, chintz wrote: > > Hello Friends, > > I have a lots of files(.pdf) in one folder.How to get .pdf files > name only in excel sheet and rename desired name what i entered in > other colum

Re: $$Excel-Macros$$ pdf file rename

Do you have any experience in Excel VBA? It would be fairly simple to write a macro that lists the files in a folder. then, create a column that has the new name and have another macro rename the file. but implementing it requires that you know a little about VBA. Paul --

$$Excel-Macros$$ pdf file rename

Hello Friends, I have a lots of files(.pdf) in one folder.How to get .pdf files name only in excel sheet and rename desired name what i entered in other column in excel sheet. ex: old name desired name SALEINV_Part100.pdf.pdf33

Re: $$Excel-Macros$$ Urgent help

I want all, whatever the is available on sheets. On Tue, Dec 16, 2014 at 5:47 PM, Vaibhav Joshi wrote: > > ok, do you want both or unique one? > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar > wrote: >> >> it was

Re: $$Excel-Macros$$ Urgent help

ok, do you want both or unique one? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:43 PM, Rakesh kumar wrote: > > it was just sample output. > > On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote: >> >> there is 2 raw of data but your outp

Re: $$Excel-Macros$$ Urgent help

it was just sample output. On Tue, Dec 16, 2014 at 5:19 PM, Vaibhav Joshi wrote: > > there is 2 raw of data but your output doesn't contain 68 & what about > repeated number 65 to 67? > > + > *I did not do this for you. God is here working through me for you.* > > On Tue, Dec 16, 2014 at 5:03

Re: $$Excel-Macros$$ Urgent help

there is 2 raw of data but your output doesn't contain 68 & what about repeated number 65 to 67? + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 5:03 PM, Rakesh kumar wrote: > > HI frinds, > i want split cells value in diffrent row using macro

$$Excel-Macros$$ Urgent help

HI frinds, i want split cells value in diffrent row using macros, please see the attechment. Please do it urgent basis if any one can. -- Thanks £ Regards Rakesh Kumar +91-9650303464 <#> -- 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

$$Excel-Macros$$ Re: copying data from one workbook to other

Bold doesn't mean anything I said I highlighted the thing in bold which is require to mention Second thing used range can work on that wb.Sheets("sheet1").UsedRange.Copy Destination:=ThisWorkbook.Sheets(2).Range("A1") you can use activate a cell and then paste into it. On Tuesday, December 1

Re: $$Excel-Macros$$ Re: Excel Macro to add rotated picture in Cell Comments

Hey Zafar, You can try this code... Hope this helps / you can also share any alternate method you have found Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 15, 2014 at 6:23 PM, Vaibhav Joshi wrote: > > Yes, you need to rotate picture first & th

Re: $$Excel-Macros$$ Distribute numbers to names

Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 16, 2014 at 12:56 PM, Haresh doley wrote: > > oh my god, its working !! from morning i am breaking my head. Thanks a lot > Vaibhav. Tricky solution. :) > > Regards, > Haresh > > > > On Tue, Dec 16, 20

$$Excel-Macros$$ Re: copying data from one workbook to other

Mandeep, 1. how to bold any word in vba code window? wb.Sheets("sheet1").Range("B6:g6").Copy Destination:= Workbooks("nameanddate.xlsm").Sheets("sheet1").*Range("A1")* 2. in this code, we can not use "UsedRange" property ? 3. in this code , we can not tell to paste to activecell? (is it

Re: $$Excel-Macros$$ Distribute numbers to names

Vaibhav Bhai, SUperb Solution. Regards Ashish -- 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