Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Hi Mahesh, Grete It is working.But i am getting runtime error"53" (File not found message) and debug report is highlighting the below code. Kill sPath & sFname & ".xls" Note: It is creating file also on the given path. Regards, Prabhu -- -

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Hi Prabhu Try Sub Mtest() Dim sPath As String, sFname As String, fname As String Dim OutApp As Object, OutMail As Object fname = ThisWorkbook.Name sPath = ThisWorkbook.Path & "\" sFname = "Statement as on " & Format(Date, "mm-dd-") & ".xls" With ThisWorkbook Sheets(Array(ActiveSheet.Name, Act

Re: $$Excel-Macros$$ xls to Pdf in VBA error

Hi Noor, It is working.. If i needs to create PDF only for active sheet then how to change the above VBA code. Plz help regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for ti

Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***

Hi Mahesh, Thanks it is working now.. Can you help me , if the same file needs to be an attachment in a new outlook mail with the subject name has to be the file name, instead of saving in particular location. Regards, Prabhu. -- ---

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi Friends, I think topic got changed. Actually i have attached a pivot file, when is double click the numbers a new sheet is appearing. But in that sheet all numbers are shows in date format!!!. Plz help to know the reason and how i can get Numbers in numbers format and date in date format??

$$Excel-Macros$$ Re: Freeze panes in an Excelsheet Control on a userform

Try this http://www.excelfox.com/forum/showthread.php?125-FreezePane-In-A-Userform-SpreadSheet-Control-11.0 Regards, Sam Mathai Chacko On Sep 1, 2:29 pm, John Holland wrote: > Would there be possibility to  freeze panes in an Excelsheet Control > on a userform? I can find certain VBA-code t

Re: $$Excel-Macros$$ extracting data from a datasheet

Hi Please attach sample data *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote: > I made an userform with Empno, Name, Design, DOB textboxes with the > save command. I am able

Re: $$Excel-Macros$$ extracting data from a datasheet

Can you attach the sample file On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote: > I made an userform with Empno, Name, Design, DOB textboxes with the > save command. I am able to save the data. Now, I need code for > updating the already contained data in a datasheet. > > How to retrieve dat

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Write the correct problem in subject section, like "pivot, conditional formatting, lookup function,". and then elaborate the problem as clearly as u can, and also if possible attach the sample sheet. Regards, Waheed. On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema wrote: > Sir, > I totally co

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Sir, I totally confused to put my query in group ID. pls tell me the procedure On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed wrote: > Plz put all ur queries n replies to the group id. So that everyone > will try n learn, that is wht our objective. > > Thnx > Waheed. > > On Thu, Sep 1, 2011 at 4:

Re: $$Excel-Macros$$ **Pivot Table Doubt**

*If two geographical data match in two sheets, then add/copy/replicate unique id/code* Hi guys, this is my problem. I have a geographical data (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a UNIQUE GEOGRAPHICAL CODE that

RE: $$Excel-Macros$$ Re: Need macro to split the files

Hi Dear How to reach your website. Pls give addres.. thanx -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Frederic LE GUEN - MVP Excel Sent: Wednesday, August 31, 2011 1:58 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-M

$$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

Would there be possibility to freeze panes in an Excelsheet Control on a userform? I can find certain VBA-code to manipulate properties of this Control, but not the Freeze Panes method. Thanks for any suggestions, JH -- --

$$Excel-Macros$$ extracting data from a datasheet

I made an userform with Empno, Name, Design, DOB textboxes with the save command. I am able to save the data. Now, I need code for updating the already contained data in a datasheet. How to retrieve data from datasheet basing the Empno and update (command button). Pls provide code. -- -

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Plz put all ur queries n replies to the group id. So that everyone will try n learn, that is wht our objective. Thnx Waheed. On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales wrote: > Thank you very much! > > Hope we could get in touch soon for future problems on Excel. Thank you! > > O

$$Excel-Macros$$ Re: Query

Dear Venkat I have second condtion that i want payout amount datewise. I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using On Aug 31, 10:15 pm, shashi wrote: > Dear Excel Guru's > > I want an urgent help on

$$Excel-Macros$$ Fwd: Dynamic Ledger

-- Forwarded message -- From: Ananta Sapkota Date: Mon, Aug 29, 2011 at 3:24 PM Subject: Dynamic Ledger To: excel-macros@googlegroups.com Hi Everyone I want to make dynamic ledger in excel with control button. Moreover I want to add new party from by clicking new button. In thi

Re: $$Excel-Macros$$ **Pivot Table Doubt**

Hi, Right Click on the pivot table, select Pivot Tabel Options, move to 'Data' tab and then Uncheck- "Enable Show Details". For the date format i think its working fine in both rows n columns. Regards, Waheed. On Thu, Sep 1, 2011 at 7:55 AM, Prabhu wrote: > HI All, > Plz find the pivot table sh