Our training courses
Azure C# Excel Microsoft 365 MySQL Power Apps Power Automate Power BI and DAX Python Report Builder SQL SQL Server VBA Macros

Other training resources
Blogs Exercises YouTube tutorials YouTube shorts Test your skills Consultancy Courseware Self-paced courses Newsletters Publications

Our training venues
London Manchester Across the UK At your site Online

Why we are different
Hundreds of published reviews Small class sizes Outstanding courseware Online classroom (Almost) no cancellations Wise Owl trainers only Genuine integrity Invoices after training 30+ years of Wise Owl Our top 100 clients

Details for DBlakeMAAT

DBlakeMAAT has participated in the following threads:

Added by DBlakeMAAT on 20 Nov 2021 at 15:04

Do you guys know if there is anyway of hiding from client tools programtically with VBA?  Whilst using the data model is not new to me as an early adopter of PQ & PP,  I am working on my 1st project in which i am generating all of the queries, relationships and measures programatically with VBA which is working amazingly, however not being able to hide from client tools has become a sticking point!

Regards

Dave

PS: have you looked at the Lamda function yet, it may make a good video, especially when you get into recursive Lamda!

Added by DBlakeMAAT on 18 Aug 2019 at 14:33

Hi Andrew

Love the way you teach and the videos, they are always my go to point and have allowed me to do some great things!

My question is on using User Defined Type Declarations with class modules (specifically property statements), I have a large number of private fields in my class module (SupplierASearchString, SupplierAWorksheet, SupplierBSearchString, SupplierBWorkSheet etc etc). I am thinking of trying to simplify this by using User Defined Types (UDT), thus allowing me to have a single Private Field per supplier declared using my UDT.

It would appear that you can not declare property statements for the individual elements of a UDT.  Not all of my elements are set at the same moment in the procedures that i am running, would this mean that UDT are probably not the best approach or am i missing something fundimental with regards to UDTs? 

 

Many thanks 

 

Dave Blake MAAT

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...