$$Excel-Macros$$ Print webpage to pdf file

2013-07-30 Thread mohd saber
HI All, Can you please help me out in solving the issue. I have few websites in which i have to enter few values and click on a specific button and once the data is loaded, need to take the print of the webpage in a pdf format with a specific name. we can take any website for doing so which has

$$Excel-Macros$$ help: can we automate chrome just like we do for internet explorer

2013-07-05 Thread mohd saber
Hi All, Can you please help me out in automating chrome from vba excel just like we do through internet explorer. i need to extract data and also print the webpage. i am able to do it through internet explorer. Can we do the same through chrome as i need it as the website supports chrome better

Re: $$Excel-Macros$$ @ character in Excel

2011-11-21 Thread mohd saber
hi, In Excel 2007 1. Click the Office Button, then click Excel Options 2. Click the Proofing category, and click the AutoCorrect Options button 3. On the AutoFormat As You Type tab, remove the check mark from Internet and network paths with hyperlinks 4. Click OK, twice, to close

Re: $$Excel-Macros$$ VBA Doubt

2011-09-07 Thread mohd saber
Hi Shankar, As far as i understand is that you want only the userform not the excel workbook. If this is the case you need to use VISUAL BASIC for preparing the form not vba which is inbuilt in any application. Please let me know if you need any clarification. Regards, saber On Wed, Sep 7, 2011

Re: $$Excel-Macros$$ problem with duplication of data

2011-09-07 Thread mohd saber
Hi Shankar, Please find the below updated data for the command file Private Sub CommandButton1_Click() ActiveWorkbook.Sheets(Employee Details).Activate Range(A1).Select Do If IsEmpty(ActiveCell) = False Then If activecell.value = txtfileno.value Then ActiveCell.Offset(0, 1) = txtname.Text

Re: $$Excel-Macros$$ VBA Doubt

2011-09-07 Thread mohd saber
Hi Shankar, Sorry to say that as far as i know there is no way regards, saber On Wed, Sep 7, 2011 at 8:02 PM, Shankar Bheema shankar.n...@gmail.comwrote: means sir, is there no way to do like Visual basic with VBA excel ? On Wed, Sep 7, 2011 at 7:46 PM, mohd saber md.saber2...@gmail.com

Re: $$Excel-Macros$$ VBA Code to extract data in row

2011-08-05 Thread mohd saber
hi Raghavendra, please find the attached file with the solution. On Fri, Aug 5, 2011 at 4:57 PM, Raghavendra raghavendra@gmail.comwrote: Hi , ** ** Can anyone suggest me VBA code to perform task as mentioned in the attached file. ** ** Regards, Raghavendra --

Re: $$Excel-Macros$$ Automatically Hyperlink

2011-06-07 Thread mohd saber
Hi Karan, please find attached file with the result. i have included one formula in the same sheet for your reference. thanks, saber On Tue, Jun 7, 2011 at 1:40 PM, karan 1237 karan1...@gmail.com wrote: Hello Experts, I need your assistance. I'v a workbook which has 4 sheet. I want to

Re: $$Excel-Macros$$ please help me Urgent

2011-06-07 Thread mohd saber
hi sukumar, please find attached. regards, saber On Tue, Jun 7, 2011 at 5:46 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, Students English maths sceience Grades suresha 45 80 90 90-100 A srinivas 25 36 60 80-90

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-07 Thread mohd saber
Hi Anil, Try this, Go to windows Explorer then ToolsFolder OptionsFile Types tab and select XLSX files from the list. Click on the Advanced button which will open up the Edit File Type dialog and you should see the Change Icon button on the top. Regards, saber On Tue, Jun 7, 2011 at 2:49 PM,

$$Excel-Macros$$ hi all

2010-07-08 Thread mohd saber
hi group, can anybody answer the queries of the questions asked in the group. Thanks, saber -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :