Search results

Wow thanks Chihiro. Yeah, my company's BEx is ancient. Yeah I probably don't have the skillset... Is there any way to know where this library is? I don't have any .COM addins active in excel, it's just the BEx XLA file. now that is installed with an EXE so there could be relevant files anywhere...

Hi All, I have some need for an explanation of how VBA I use daily works. This is a very old system from SAP, a VBA plugin. within the code, it creates an object: Set pAddin = CreateObject("com.sap.bi.et.analyzer.addin.BExConnect") I gotta say I'm very confused by that line above...

You are the best! Thank you thank you thank you!

Hi Chihiro, thanks, I copied the formula and that seems to work, but it seems my old BI doesn't have the invoke custom function option.... I guess I try insert it as a regular column? but this doesn't work:

Hi all, I need to get a fuzzy match going, the twist and issue is, I have power BI 2016 (work, can't update it!) which means the fancy fuzzy match feature is unavailable. I'm not great at this... Can someone please help me out with sample? I more or less want to look up a load of names from...

Thank you for this Chihiro! Really useful. I think I know where to go from here.

Hi all! Just wanted to ask, is it possible to have user forms that are not square? You know how you go into VBA, create a new user form and bam, it's an ugly grey rectangle. Is it possible to say, have a PNG image? or make the form background and edges invisible? Can I have buttons that are...

Hi John, Oh I was just playing with sumproduct, nice use of Column() there! This is exactly the rainbow I was chasing. Thank you sooooo Much!

Hello, I'm looking at a problem where I have a table of data, months as columns up top an a few categories in rows, some repeating that I need to sum. It's best visualized by example attached (I borrowed this from the Chandoo Vlookup book, coloured in bits I added in to show why my problem is a...

I hate to be that guy, but your Microsoft already has that functionality. Simply select all the files, right click with mouse and select 'print'.

Only got to test this today, Works perfectly, thank you p45cal ! You're a hero

Hi, Me here with the annoying macro again. Sorry! In file attached (borrowed from internet) there is a macro that produces a new option for right click menu. Qs1. How can I rename these, currently Macro 1, Macro 2 and Macro 3? I tried editing the STRMacroName and that works but produced more...

! Okay. That's new. Thanks for trying it out. I'll test it on a different computer. Appreciate the help!

Hi Narayan, I did try that, I don't think it works. See attached, I pulled a pivot table there, for me I don't see the macro list option when I right click into that pivot table. Bizarrely, the menu still works on cells outside the pivot.

Hi, I'm looking to replicate this: https://www.atlaspm.com/toms-tutorials-for-excel/toms-tutorials-for-excel-customizing-your-rightclick-menu-to-list-run-macros/ There is a sample workbook there at the bottom of the page. But it's Excel 2003, I work with 2010! However, I need the above to work...

I'll give you some pointers if you're open to it :) Primarily, your data visualisation is not the best, you could use reading up about it, looking up good examples of charts and dashboards? Plenty on Chandoo. 1. You use secondary axis A LOT. I'd almost never show the secondary axis. It is very...

Hi Tauqeer, This is because, I suspect, your chart is still pulling in the N#As with the 0 values. Simple fix is to go into your primary vertical axis, and set the minimum over 0. Make it a fraction, 0.1 for instance. It won't be noticeable, but any marks and labels and ticks below 0.1 won't show.

Try this (column G)

That's the dream, thanks G.

Hi G, Thank you for the response. I will look out for those ghost files. The files are heavy-ish, 4000-5000KB each (two files total). Thing is this is a work laptop and it is very badly built - it has a very powerful CPU but only 8gb ram, most of this is used by various programs I can't turn off...

Hi, I have MS office 2010, 32 bit, windows 7. I have a presentation file that has maybe c.20 charts that connect to two excel files located on a network, pulling charts and tables (these are excel-linked chart objects). I need to update this regularly. It takes a minute or two to just update...

=IFERROR((O8-M8)/O8,"")

Is there no way though to just not change view but keep the selects? TBH I know it's out of ordinary but I sometimes allow the macro to scroll around, tends to aid understanding. For the most part though, I'd just like to add a small tweak to existing macros either I or others wrote that I...

Hi, Is there any way in VBA to select a cell but not change the display, so to say if my display for the resolution and size is showing be columns A:Z with A1 being in top left corner (I physically can't see AA1 on my computer screen), but I do range("AA1").select or .activate, it moves the...

Hi Chihiro, Yeah, well there isn't much to show but funnel charts and waterfall charts look slick but don't demonstrate the change in composition. It is a bit unusual, that's why I struggle to come up with anything, but I thought someone might've done it before in some clever way. I might just...