Re: $$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Anoop K Sharma
Hi Rob, Please have look at attached one... On Thu, Jan 23, 2014 at 6:48 AM, Rob Flott wrote: > > > On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: >> >> Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of >> names. This range will vary, and I have a Na

RE: $$Excel-Macros$$ Not able to set new URL

2014-01-22 Thread Ravinder
Pls provide some tick number of example excel file From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of mburkett Sent: Wednesday, January 22, 2014 8:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Not able to set new URL I have a procedu

$$Excel-Macros$$ Re: URGENT - Help regarding SaveasPDF Macro for Excel

2014-01-22 Thread chintz
you should try with two add on printer software adobe pdf printer or bullzip printer. Thanks Chintan On Thursday, January 23, 2014 9:22:29 AM UTC+5:30, Aatmik Muchhal wrote: > > My code is - > > Sub SavePDF() > ' pdf Macro > Application.ScreenUpdating = False > Sheets("Invoice").Select >

$$Excel-Macros$$ URGENT - Help regarding SaveasPDF Macro for Excel

2014-01-22 Thread Aatmik Muchhal
My code is - Sub SavePDF() ' pdf Macro Application.ScreenUpdating = False Sheets("Invoice").Select Range("A1:A52").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ "G:\SAMAYENT\Invoice\" & Range("A9").Value & " Order No# " & Range("F9").Value & " Invoice

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-01-22 Thread Stuart Baldock
Good day Ayush, Not sure if this Group is still operating --- I hope so! I have an Excel macro issue that is driving me nuts I live in Western Australia, am retired, love playing golf and woodworking. My family is married but no grandchildren - just a granddog - Cuba. I would like somebody t

$$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Rob Flott
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: > > Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of > names. This range will vary, and I have a Named Cell that identifies the > range. For example the range of names in one example is A3:A8. But in

$$Excel-Macros$$ Re: ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Rob Flott
On Wednesday, January 22, 2014 3:36:19 PM UTC-8, Rob Flott wrote: > > Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of > names. This range will vary, and I have a Named Cell that identifies the > range. For example the range of names in one example is A3:A8. But in

Re: $$Excel-Macros$$ ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Ricardo®
Hi Rob Flott, Can you share a sample file with some dummy data? tks. Basole 2014/1/22 Rob Flott > Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of > names. This range will vary, and I have a Named Cell that identifies the > range. For example the range of names in

$$Excel-Macros$$ ListFillRange Property of ActiveX ListBox

2014-01-22 Thread Rob Flott
Using MS Excel 2010 I have an ActiveX ListBox and want to load a range of names. This range will vary, and I have a Named Cell that identifies the range. For example the range of names in one example is A3:A8. But in another example that range could be A3: A21. I would like the ListBox to l

$$Excel-Macros$$ Not able to set new URL

2014-01-22 Thread mburkett
I have a procedure in Excel VBA that goes to a cell with a stock ticker and then launches a browser window with the Google Finance chart. For some reason it is pulling in the same ticker every time. The only way it will work is if I step through the macro rather than running from a drop down me

RE: $$Excel-Macros$$ Help required for PDF Stamp

2014-01-22 Thread Ravinder
Your query is not clear. Please explain more you need to edit any pdf or only create stamp like approved, rejected or else as pdf From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajeev Sent: Wednesday, January 22, 2014 12:03 PM To: excel-macros@googlegro