Search:

Type: Posts; User: jenyaUtd; Keyword(s):

Search: Search took 0.00 seconds.

  1. dataformat error power query when doing Excel.Workbook

    I have 5 files that have the same structure. (Num of columns, data tape etc...)
    I'm trying to load them from folder with Excel.Workbook ,in 3 of them the table extructed fine and in 2 I get error...
  2. Re: How to disable a pivot table from a data model, Excel 2016

    How I change the default settings , that the box of " add to data model" is unchecked by default!
  3. Replies
    0
    Views
    118

    problem when running my addinn

    hello,

    I am created a Userform with some VB code that do some operations that i need for my work and save the WB as an addin ( elam file), when I add it to my Excel and try to run it but the Excel...
  4. Replies
    2
    Views
    3,568

    Re: highlight rows and columns in excel add in

    I saw some add ins with this opption so it can be done at the Excel level, the problem for me is that I can't install whose addins at my work (can't install .exe)
  5. Replies
    2
    Views
    3,568

    highlight rows and columns in excel add in

    hello,

    i am looking for excel add in that highlights active rows and columns , it must be excel addin file and not ".exe"

    or a vb code that do this (i want it to work at all my workbooks and...
  6. Thread: Excel addins

    by jenyaUtd
    Replies
    3
    Views
    405

    Re: Excel addins

    Nothing specific, just looking for tools to make my life easier and quicker :))
  7. Thread: Excel addins

    by jenyaUtd
    Replies
    3
    Views
    405

    Excel addins

    Hello, I'm looking for useful addins for my work, the problem is that I can't install any exe files at my work, only add in Excel file.

    Many thanks
  8. Replies
    7
    Views
    332

    Re: autofilter dynamic criteria

    Did you mean "power bi"?
  9. Replies
    7
    Views
    332

    Re: autofilter dynamic criteria

    Sorry for the previous reply :( I've try the code in my work where I truly need it and it doesn't work, I guess is because the filler I try to apply is on a field of a pivot table. The PT is a BI...
  10. Replies
    7
    Views
    332

    Re: autofilter dynamic criteria

    Works perfectly,
    Many TNX!!!!!!!
  11. Replies
    7
    Views
    332

    autofilter dynamic criteria

    Hello all,
    I want to Create a sub of autofilter in VBA that will autofilter my range by a criteria that is written somewhere in my sheet,

    for example:
    I have a table:

    code|Pname|price|
    1 ...
Results 1 to 11 of 11