$$Excel-Macros$$ Convert XLS to XML

Hi Gurus, I need a macro to convert the content of the file into xml format and the converted file should get saved on desktop in .xml format. Sample file attached. Please help! -- Regards Iqbal Merchant -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread

$$Excel-Macros$$ I want to do or learn VBA coding and MACRO

Dear All, I don't know anything about macrosand about programming or VBA to create and use macros.  But I want to do or learn seriously. Can anybody help me related this. Related basic book or rule or anything plz guide me how can I proceed.   Regards LAKSHMAN 9582279261 -- FORUM RULES (934+ m

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Thanks Noorain, I got the problem solved!! 2011/12/9 NOORAIN ANSARI > > Dear Darwin, > > Please see attached sheet. Hope it will help you.. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.

Re: $$Excel-Macros$$ Sumproduct for multiple criteria lookup

Dear Darwin, Please see attached sheet. Hope it will help you.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Dec 9, 2011 at 8:03 AM, Darwi

$$Excel-Macros$$ Sumproduct for multiple criteria lookup

Dear group, I have got an excel file getting sales volume of different customers in buying different services on a daily basis. I want to use sumproduct formula to get the sales volume buying services on a monthly basis. However, the desired results are not found. Please help. -- Darwin Chan da

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

Dear Haseeb I am surprised of your wonderful command "Alt+0160 in Find What box: and click Replace All " can you brief that what is the meaning of 0160 with Alt command & is there further more commands available in excel. Regards, Aamir Shahzad On Wed, Dec 7, 2011 at 10:54 PM, Haseeb Avarakkan

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish Yes , that's what i had thought, seems a good idea. Thanks for the help once again.. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 23:18:02 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com in that c

Re: $$Excel-Macros$$ $$ excel - macro $$

Minor correction to mine Sub UpdateMasterFileSAS() Set ss = Sheets("source sheet") Set ds = Sheets("destination sheet") slr = ss.Cells(Rows.Count, 1).End(xlUp).Row dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr + 1, 1).Resize(slr,

Re: $$Excel-Macros$$ $$ excel - macro $$

in that case u can type the staring date of month manually in cell a2 in destination file before you run the macro rember date fromat should be same On Thu, Dec 8, 2011 at 11:11 PM, gargee singh wrote: > Hi Don > > Thanks for your time and help , one fellow group member helped me with > t

Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture

Thanks Noorain. Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 8 Dec 2011 23:01:08 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as pictu

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Don Thanks for your time and help , one fellow group member helped me with the code and it seemed to work fine. Thanks and Regards, Gargee Singh From: dguille...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ Date: Thu, 8 Dec 2011 11:24

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish I had just one more question and i just thought about it that is for the first of every month the destination workbook would be blank as no data would have been consolidated and this code doesn't work.Please help. Once again thanks for all the help. Thanks and Regards, Gargee Singh

Re: $$Excel-Macros$$ Macro to Paste excel cells to powerpoint as picture

Dear Joseph, Please try through below link.. http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-1.html On Thu, Dec 8, 2011 at 10:45 AM, wrote: > Hi Macro team, > > I have a lot of tables in excel that I need to paste on powerpoint. Please > help me. > > Thanks, > Joseph > Sent on my Bl

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish, Thanks for such quick reply and time. This is fantastic :) .Completely meets my requirements. Thanks and Regards, Gargee Singh Date: Thu, 8 Dec 2011 22:51:54 +0530 Subject: Re: $$Excel-Macros$$ $$ excel - macro $$ From: koul.ash...@gmail.com To: excel-macros@googlegroups.com o

Re: $$Excel-Macros$$ $$ excel - macro $$

Try this Sub UpdateMasterFileSAS() Set ss = Sheets("source sheet") Set ds = Sheets("destination sheet") dlr = ds.Cells(Rows.Count, 1).End(xlUp).Row sr = Application.Match(ds.Cells(dlr, 1), ss.Columns(1), 1) ss.Cells(sr, 1).Resize(100, 7).Copy ds.Cells(dlr + 1, 1) End Sub Don Guillett SalesAid Sof

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Don, Thanks for the reply and i dont have a code ready , i tried a lot but nohing seemed to work and please find the attached sheet. Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data.Source

Re: $$Excel-Macros$$ $$ excel - macro $$

It would be helpful to post your code and/or file (if allowed) Don Guillett SalesAid Software dguille...@gmail.com From: gargee singh Sent: Thursday, December 08, 2011 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ $$ excel - macro $$ Hi experts I urgently need help wi

RE: $$Excel-Macros$$ $$ excel - macro $$

Hi Ashish, Thanks for your reply.Please find the attached sheet.The source sheet is what the source data will look like and the destination sheet is where i want the consolidated data.Source sheet has data till 8-dec -11 and destination sheet has data only till 5-dec-11 so i want the code to co

Re: $$Excel-Macros$$ $$ excel - macro $$

can you attach the sample file and send it to the group id excel-macros@googlegroups.com On Thu, Dec 8, 2011 at 9:54 PM, gargee singh wrote: > Hi experts > > I urgently need help with a code. > Though I have tried a lot of options just couldn't get the accurate code. > > This is what i need to

$$Excel-Macros$$ $$ excel - macro $$

Hi experts I urgently need help with a code.Though I have tried a lot of options just couldn't get the accurate code. This is what i need to do --* copy data from one workbook and paste in another workbook at the next blank row (since there will be some data in the destination sheet which i can

Re: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell

Sub Quotize() Dim var As Variant Dim rng As Range Const lngColOffset As Long = 0 'Use 0 if you want to overwrite the cell value Application.ScreenUpdating = 0 Set rng = Range("B1:B10") var = Application.Transpose(rng.Value) For Each rng In rng With rng.Offset(

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Please find the attached file. I have used the below formula to solve. =SMALL(IF(D2:D11<=G2,D2:D11),{7,6,5,4,3,2}) Regards, MARIES. On Thu, Dec 8, 2011 at 5:40 PM, NOORAIN ANSARI wrote: > Hi Renuka, > > Can you more explain your query.. > > > Thanks & regards, > Noorain Ansari > *

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

Hi in Noorain's code, i would make the following change to the line that starts the same: Sheet1.UsedRange.Copy Sheets(Sheets.Count).Range("A1") then delete sheets created with sheet names from dates in sheet1 and it should work Don's code is more straightforward, something new I have to learn to

Re: $$Excel-Macros$$ hi can you solve this

Hi Renuka, Can you more explain your query.. Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Thu, Dec 8, 2011 at 6:56 PM, Renukachari Kasee wrote: > > *

$$Excel-Macros$$ hi can you solve this

*(¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks & Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪* * * *P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, redu

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

1.. Sub Macro1() Dim sFile As String sFile = "S:\Office Documents\Purchase Orders\" & ActiveSheet.Range("F5").Text & ".pdf" If Len(Dir(sFile)) Then If MsgBox("Purchase order number already used, Verify and correct purchase order number", vbOKOnly) = vbOK Then Exit Sub

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

Thanks a lot! Works perfectly! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don

Re: $$Excel-Macros$$ choose column when running macro

Easy enough but let's try to fully automate. Why skip a21?? Are you saying you want to copy/paste values to B if there is nothing in B or to C if there are values in B, to D if values in C??? Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: trawets Sent:

Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook

aw,gee... Don Guillett SalesAid Software dguille...@gmail.com From: Susan 1 Sent: Wednesday, December 07, 2011 11:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula or macro to add names to sheets in one workbook Great Macro Don! Very helpful for my task... I reall

Re: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell

reply to me with your file. dguillett1 @gmail.com Don Guillett SalesAid Software dguille...@gmail.com From: ajinkya natu Sent: Wednesday, December 07, 2011 8:38 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Single Quotes at the Start and End of the data in a cell Hello All,

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

Dear Prabhu, Please try through below Code. Sub OnlyforActivesheet() On Error Resume Next sh = ActiveSheet.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="\" & sh & ".pdf", Quality:=xlQualityStandard, OpenAfterPublish:=True On Error GoTo 0 End Sub On Thu, Sep 1, 2011

Re: $$Excel-Macros$$ Excel to PDF

Dear Abdulgani, Please use this one, and Change your path as per your requirement... Sub exltopdf_converter() On Error Resume Next flname = Application.GetOpenFilename(MultiSelect:=True) For Each flnm In flname Workbooks.Open Filename:=flnm sheetname = ActiveWorkbook.Name ActiveWo

Re: $$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error "expected end of statement"

Hi! Thanks! I'm actually on Mac Office 2011 and it has a save as PDF option. That might be it, but I can't find a plug-in for mac... -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

Dear Rikiko, Please use this one.. *Sub ExportPDF() Sheets(1).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="\Sales.pdf", Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ choose column when running macro

Hi I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in

$$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets("OOF2_EIF").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly app

Re: $$Excel-Macros$$ Re: saving command button not functioning

thank you very much Kishan On Thu, Dec 8, 2011 at 11:37 AM, Kishan Reddy, K < kishanreddy.kethire...@gmail.com> wrote: > Please add the following code. > > rst.update > > after assigning values to the fields > > Also instead of using rst.fields(0), --- you can use > rst.fields("fileno") which wi

$$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error "expected end of statement"

Hi! I'm new to VBA and I'm trying to start out by creating a pdf out of my worksheet. This is my code: Sub PrintWorkbookPDf() ' ' PrintWorkbookPDf Macro ' ' Keyboard Shortcut: Option+Cmd+u ' ActiveWindow.SelectedSheets.ExportAsFixedFormat Type:=xlTypePDF FileName:=“sales.pdf” Quality:=xlQua