$$Excel-Macros$$ buy cheap muchroom online

2020-09-09 Thread Tony Fritz
https://fresh-cannabis.com/ WE HAVE HIGH GRADE HYBRID, SATIVA AND INDICA STRAINS. https//fresh-cannabis.com Good quality products. Good and affordable prices. Fast and Reliable delivery -Tracking Available! Various shipping option (Overnight and Airmail). No Prescription Required

$$Excel-Macros$$ Buy Cannabis oil, medical muchrooms, marijuana, hash oil CDB oil, edibles, carts and vapes https://fresh-cannabis.com

2020-08-18 Thread Tony Fritz
https://fresh-cannabis.com/ WE HAVE HIGH GRADE HYBRID, SATIVA AND INDICA STRAINS. https//fresh-cannabis.com Good quality products. Good and affordable prices. Fast and Reliable delivery -Tracking Available! Various shipping option (Overnight and Airmail). No Prescription Required

$$Excel-Macros$$ Buy Cannabis oil, medical muchrooms, marijuana, hash oil CDB oil, edibles, carts and vapes https://fresh-cannabis.com

2020-08-15 Thread Tony Fritz
https://fresh-cannabis.com/ WE HAVE HIGH GRADE HYBRID, SATIVA AND INDICA STRAINS. https//fresh-cannabis.com Good quality products. Good and affordable prices. Fast and Reliable delivery -Tracking Available! Various shipping option (Overnight and Airmail). No Prescription Required

$$Excel-Macros$$ Cannabis oil, medical muchrooms, marijuana, hash oil CDB oil, edibles, carts and vapes https://fresh-cannabis.com

2020-07-23 Thread Tony Fritz
https://fresh-cannabis.com/ WE HAVE HIGH GRADE HYBRID, SATIVA AND INDICA STRAINS. https//fresh-cannabis.com Good quality products. Good and affordable prices. Fast and Reliable delivery -Tracking Available! Various shipping option (Overnight and Airmail). No Prescription Required

$$Excel-Macros$$ Ketamine-based drug approved for treating severe depression in US at https://rotexvails.com/

2020-07-22 Thread Dr tony Peter
Buy liquid ketamine online, Liquid ketamine suppliers, Liquid ketamine, ketamine Liquid, Get liquid ketamine, Our website link: https://rotexvails.com/ Wickr us at.. Tonyfritz Our email..:cont...@rotexvails.com Call Text & WhatsApp us at..:+1 (909) 683-1245 Good quality products. Good and af

$$Excel-Macros$$ Liquid ketamine suppliers, Liquid ketamine, ketamine Liquid, Get liquid ketamine,

2020-07-18 Thread Dr tony Peter
Buy liquid ketamine online, Liquid ketamine suppliers, Liquid ketamine, ketamine Liquid, Get liquid ketamine, Our website link: https://rotexvails.com/ Wickr us at.. Tonyfritz Our email..:cont...@rotexvails.com Call Text & WhatsApp us at..:+1 (909) 683-1245 Good quality products. Good and af

$$Excel-Macros$$ Buy Cannabis oil, medical muchrooms, marijuana, hash oil CDB oil, edibles, carts and vapes https://fresh-cannabis.com

2020-07-18 Thread Tony Fritz
https://fresh-cannabis.com/ WE HAVE HIGH GRADE HYBRID, SATIVA AND INDICA STRAINS. https//fresh-cannabis.com Good quality products. Good and affordable prices. Fast and Reliable delivery -Tracking Available! Various shipping option (Overnight and Airmail). No Prescription Required

$$Excel-Macros$$ Methamphetamine

2020-07-06 Thread Dr tony Peter
Buy liquid ketamine online, Liquid ketamine suppliers, Liquid ketamine, ketamine Liquid, Get liquid ketamine, Our website link: https://rotexvails.com/ Wickr us at.. Tonyfritz Our email..:cont...@rotexvails.com Call Text & WhatsApp us at..:+1 (909) 683-1245 Good quality products. Good and af

Re: $$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-24 Thread tony . kilduff
mma appears to break up the word Share. Not that I understand the code at all, but I would have expected something like Mode = Share Deny Write, *NOT* Mode = Sha.re Deny Write. Is this format sacred? Tony On Tuesday, February 24, 2015 at 7:16:31 AM UTC-8, Paul Schreiner wrote: > There

$$Excel-Macros$$ Importing data from Access changes worksheet name

2015-02-23 Thread tony . kilduff
orkbooks.OpenDatabase Filename:= _ "G:\Work Program\2015\Temp.accdb", CommandText:=Array( _ "qry_TimesheetData"), CommandType:=xlCmdTable, ImportDataAs:=xlTable Running Excel 2010 under Win7 Thanks (BTW, if there's a clever way to get the data from the DB I'm

$$Excel-Macros$$ Excel VBA to loop through rows and delete blank lines

2012-07-25 Thread Tony O
I am working on a spreadsheet with Excel 2007. I have the vba code to delete a line: Selection.Delete Shift:=xlUp I want to delete all rows that have the cells in column A that are blank and column B and column C for just those rows. I'm thinking that the code should look something like this,

Re: $$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

2012-05-07 Thread Tony Wu
ar to you. Thanks, Tony On Saturday, May 5, 2012 9:04:18 AM UTC-4, bé trần văn wrote: > > > > 2012/5/4 Tony Wu > >> Hello, >> >> I have a file needs to import data from another spreadsheet, that sheet >> will have different file name everyday, I want to

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-07 Thread Tony Wu
not make it. Can you help with? Thanks, Tony On Monday, May 7, 2012 3:16:06 PM UTC-4, Maries wrote: > > Hi Tony, > > I have done by formula... Just check the sheets cells. There is no Macro > codes inside. > > Regards, > > MARIES. > > On Mon, May 7, 2012 at 5:

Re: $$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-07 Thread Tony Wu
Sorry ... I didn;t see the Macro in the attachment. thanks, Tony On Saturday, May 5, 2012 9:23:46 AM UTC-4, Maries wrote: > > Hi, > > Check the attachment. > > Regards, > > MARIES. > > On Fri, May 4, 2012 at 12:27 PM, Tony Wu wrote: > >> Hello, >

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

2012-05-04 Thread Tony Wu
please help? Thanks, Tony On Friday, May 4, 2012 10:20:48 AM UTC-4, Tony Wu wrote: > > It works, thanks a lot!!! > > > On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: >> >> >> Hi >> >> PFA >> >> >> *Regards,* >> *L

$$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.

2012-05-04 Thread Tony Wu
Hello, I have a file for the forecast demand, some parts have substitution, what I need is if the part has substitution, the original demand will be added to the new part and original demand will be zero out, please see the attached file for reference. Thanks, Tony -- FORUM RULES (986

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

2012-05-04 Thread Tony Wu
It works, thanks a lot!!! On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: > > > Hi > > PFA > > > *Regards,* > *Lalit Mohan* > *https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation> > > >

$$Excel-Macros$$ How to populate a browse window to select a file and capture the filename with full path?

2012-05-03 Thread Tony Wu
aster" Workbooks.Open Filename:= _ "C:\Users\twu\Documents\Database\Item Master\Item Master 2012-04-12.xlsx" How can I keep "C:\Users\twu\Documents\Database\Item Master\Item Master 2012-04-12.xlsx" as a string? Thanks, Tony -- FORUM RULES (986+ members al

$$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

2012-05-03 Thread Tony Wu
My logical is trying to use "iserror(vlookup(...),0) to see if the logical is false, if so, copy the cell value to sheet "A", but don;t know how to translate that into VBA language ... Need your help. Thanks, Tony -- FORUM RULES (986+ members already BANNED for violation) 1

$$Excel-Macros$$ Excel spell out word from number

2011-04-20 Thread Tony O
I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- Some important links f

$$Excel-Macros$$ Excel checkbox macro

2011-04-19 Thread Tony O
I would like to add a checkbox in column A for an Excel spreadsheet. When the checkbox is checked, you can type in columns B, C and D. If it is unchecked, the cells are locked. Ideally, I would like columns B, C and D to be grey if they are unchecked. How would I go about doing this? --

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

2009-11-10 Thread Tony from Work
position of the field I need In G1 there is my formula. Does it exist a way to have the sumproduct formula in column d incorporated in the formula in G1? I tried with Array format but didn't worked Many thanks for your kindness, Antonio. On 9 Nov, 12:23, Dilip Pandey wrote: > Dear Tony

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

2009-11-09 Thread Tony from Work
First of all many thanks to Dilip and Deepak for the answers!!! Sadly they don't solve my problem, what I exactly need is one formula that sum the value only of the first 14th values, and ignore any further value. This is a sample of my worksheet: A B C Time

$$Excel-Macros$$ Where can I learn about ActiveX Libraries?

2009-10-12 Thread Tony Bender
I have an Excel based application that references Microsoft ActiveX Data Objects 2.8 Lib. I am about to push this application out to multiple users within our company, but some of them only have Microsoft ActiveX Data Objects 2.5 Lib. Will my application run properly if a user has an older versi

$$Excel-Macros$$ Is there code that when and Excel file opens it closes any open PowerPoint files?

2009-10-08 Thread Tony Bender
I have an Excel application that enables the user to export an Exccel chart directly into PowerPoint. The macro to do this works fine provided PowerPoint was not already open. I am trying to figure the VB code so when the application opens it automatically closes PowerPoint - if in fact PowerPoi

$$Excel-Macros$$ Re: Problems re-opening userform

2009-10-08 Thread Tony Bender
me to repspond. Tony Bender --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2.

$$Excel-Macros$$ Re: Problems re-opening userform

2009-10-08 Thread Tony Bender
me to repspond. Tony Bender On Oct 8, 5:03 am, Paul Schreiner wrote: > You should set a breakpoint and > try to step through your macro to see what's going on. > > Which file has the ExitApp macro? > Is it in the Rpt1.xls file? > > If it is, then once the activework.close l

$$Excel-Macros$$ Problems re-opening userform

2009-10-07 Thread Tony Bender
I have an application consisting of a report menu and the corresponding templates the menu points to. The menu is a UserForm (UF1) and resides on a separate workbook (Wkbk1). When the user opens Wkbk1 it automatically opens the UserForm (UF1). The user then selects a report template from one of

$$Excel-Macros$$ Re: initiate macro when mouse hovers over a shape

2009-10-01 Thread Tony Bender
Thank you, yes this works great On Sep 30, 9:13 pm, Tony Bender wrote: > I have an Excel application and on my 'front end' I would like to > generate a pop-up note when the user hovers over a 'shape'.  (This > would be similar to how a comment appears when the u

$$Excel-Macros$$ initiate macro when mouse hovers over a shape

2009-09-30 Thread Tony Bender
understand the code I'd need to write to do this. Thank you, Tony Bender --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text

$$Excel-Macros$$ Help importing multiple .txt filew with delimters

2009-07-24 Thread Tony
FilesInPath <> "" FNum = FNum + 1 ReDim Preserve MyFiles(1 To FNum) MyFiles(FNum) = FilesInPath FilesInPath = Dir()

$$Excel-Macros$$ Re: Is there a "GetOpenFileName() for directories?

2009-02-23 Thread Tony
idea, I'll consider this closed. Tony On Feb 19, 10:30 am, Tony wrote: > Hi all, > > I want to allow the user of my macro to see and navigate through the > directory structure and to select a target directory that the macro > can.  I was hoping there was something "like&q

$$Excel-Macros$$ Help with navigating the group

2009-02-20 Thread Tony Kilduff
y post and any responses? Tony --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google

$$Excel-Macros$$ Is there a "GetOpenFileName() for directories?

2009-02-20 Thread Tony
code such a function from scratch, but I'm not sure I'm up to that. Was never slick at this and now I'm rusty on top of that. Looking for the easy way out. In Excel 2002 under XP. Thanks, Tony. --~--~-~--~~~---~--~~ Visit the blog to download E

$$Excel-Macros$$ Make a cell a control that launches macro when clicked

2008-09-11 Thread Tony Bender
Is there a way to set a cell so when the user clicks on it, it launches a specified macro? If so can you show me how it's done? Thank you, --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this