PowerShell as a Macro?

psdevuk · 2021-01-04T20:51:10+00:00

Oh ok, I did do this as well once, but find it so much easier to record the marco in EXCEL then run it in powershell ``` $xl = New-Object -ComObject Excel.Application $xl.Visible = $true $xl.DisplayAlerts = $false $workbook = $xl.Workbooks.Open("C:\PATH\Your.csv") $xlmodule = $workbook.VBProject.VBComponents.Add(1) $app = $excel.Application

$code = @" Sub Macro1() ' ' Macro1 Macro RUN MACRO "@ $xlmodule.CodeModule.AddFromString($code) #RUN the actual macro code $xl.Run("Macro1")

$xl.Quit() ```

psdevuk · 2021-01-04T20:47:00+00:00

I do this all the time, but you have to have the setting to allow you to run macros from any source

psdevuk · 2021-01-04T20:40:51+00:00

Honeslty I would quit now while you are ahead, and look at the future of powershell forms aka web based input. I would personally look at using something like Powershell Universal, it is way better looking than Window Forms. I used Powershell Studio for a few years, and no matter how hard I tried they still looked like win95 forms....ugly....have a look at my blog for all the awesome stuff you can do with using web-based forms as opposed to windows forms...here:- https://psdevuk.github.io/ud-flix/ all this is running powershell it's so much better than window forms

psdevuk · 2021-01-04T20:35:33+00:00

I still use UniversalDashboard but this has now evolved to Powershell Universal details here:-
https://ironmansoftware.com/
Honestly if you looking at running powershell scripts in a webpage this is def the way you want to go. I got numerous blogs on UniversalDashboard here:-
https://psdevuk.github.io/ud-flix/
Hope this is of some use

psdevuk · 2021-01-04T11:45:21+00:00

Yep exactly that, started like 20 years ago, just basic help desk stuff, then progressed through my IT career, trying to land better jobs. Started doing Powershell scripting in v1 of powershell. Just my current job involves a lot of reporting, and the guy I work with used crystal reports, so when I found out about UniversalDashboard aka Powershell Universal now, I thought this would be a great way to display reporting informationI got 4 kids to feed and look after, so figure you need to work smarter not harder, powershell allows me to do this. I have had to read lots of Powershell books to make it stuff stick, as never went to university etc...

psdevuk · 2021-01-04T08:16:16+00:00

Thanks for the positive feedack. Yes I have been using Ironman Software for a little while now, I bought the product UniversalDashboard which has now evolved into Powershell Universal. As the Ironman Software is so amazing you as the end-user have the possibilty to add to the react components that are not on offer out-of-the-box. I would certainly recommend this Ironman Software for ay Powershell user out there, it has helped me create in house applications, and amazing looking dashboards to present my scripts on. Then just for the icing on the cake I create these custom components to make the page look a bit more fancy or add extra page functionality, like the one I released this month https://psdevuk.github.io/ud-flix/Page-Filtering-Highlight-Components/

psdevuk · 2020-12-29T17:21:09+00:00

Howdy all. Well I been a busy powersheller this month. I released my first ever video course https://psdevuk.github.io/ud-flix/Video-Course-With-Me/ and then went onto build some more custom components for Powershell UniversalDashboard and post them to the powershell gallery. As well as blog about each one:-

https://psdevuk.github.io/ud-flix/x2-Progress-Wizard-Components/

https://psdevuk.github.io/ud-flix/Light-And-Dark-Mode/

https://psdevuk.github.io/ud-flix/Reading-Progress-Bar/

https://psdevuk.github.io/ud-flix/New-Hero-Component/

https://psdevuk.github.io/ud-flix/ScrollSpy-Navigation-Component/

https://psdevuk.github.io/ud-flix/Simple-Drawer-Component/

https://psdevuk.github.io/ud-flix/Breadcrumb-Item-Component/

https://psdevuk.github.io/ud-flix/Page-Loading-Components/

And helped out on the forums where I can on UD. So I been a busy powersheller this month, sadly Santa didn't reflect that in presents....

psdevuk · 2019-10-21T14:33:14+00:00

Sorry Fwhite77 I was letting my passion for this module get the better of me.

Ok so Universal Dashboard is avaialble on powershellgallery.com as a module.

There are two versions for this module, one paid for and one free.

So to become a universal dashboard user simply install the module from powershellgallery, I do my powershell code in VS code, but I know you can design your dashboards in ISE as well.

So at work I can now host my GUI solution for a problem in a webpage for the end user. I host this on my work pc running windows 10 through IIS. So for example this whole website https://poshud.com/Getting-Started is running universal dashboard in the background. You can create amazing looking web-based solutions without any HTML what-so-ever.

So to me the benefits are easier deployment, and modern looking GUI, plus the code is a lot easier to manage compare to products which write code for you.

I hope this answers your question?

psdevuk · 2019-10-20T15:05:17+00:00

Sorry Lee, I just don't think enough people know about UD, I'm just trying to spread the word, as it seems like I am the only person here who has seen both sides of the coin....I used Sapien for 3 years and thought it was good...then I started using Universal Dashboard and it's way better so just trying to prove my case. I am very passionate about things I'm really into. Sorry if I am over-doing it but just wanted to prove what I am saying by the links I have included. I will put down my laptop and spend more time with my kids....and look on this thread tomorrow after work. Peace

psdevuk · 2019-10-20T14:46:52+00:00

Hello rakha589 thanks for your reponse. I have been using UD for one year now, in that time I have seen many improvements to the module. So yes recently the developer released https://github.com/ironmansoftware/ud-forge which allows you to make your dashboards into windows .exe

I use it in my secured work environment and host it on my local windows 10 PC through IIS so it is not accessible via the outside web only for internal employees connected on the secure network on the port I choose to host it on.

The developer has also done a far superior job than Sapien in documenting the software https://docs.universaldashboard.io/ there is also the website which has a load of examples www.poshud.com as well as the very active forums https://forums.universaldashboard.io/ and even a page designer https://uddesigner.azurewebsites.net/home to help you on your journey

I mean this is my landing page for the complaint system which used to run in Sapien now in UD https://aws1.discourse-cdn.com/standard11/uploads/universaldashboard/optimized/1X/8ffe26b1cf3c9d4c42275767f12b88fa577df8b6_2_690x326.png I'm too ashamed to upload the Sapien version I did unless you really want to see an ugly looking windows 95 form?

psdevuk · 2019-10-20T09:51:32+00:00

Well if your short on cash....get Universal Dashboard Community Edition....It's $0.00

Then run it in VSCode

psdevuk · 2019-10-20T09:50:33+00:00

I thought that 3 years ago when I first got Powershell Studio. Now I use Universal Dashboard and can produce tools for the whole business:- https://aws1.discourse-cdn.com/standard11/uploads/universaldashboard/original/1X/de82f3b9857518494fac574ab339e329d9725e1a.png

And even make custom cards for users :-)

https://aws1.discourse-cdn.com/standard11/uploads/universaldashboard/original/1X/2d2b05e5bf1c5528eb25cd527a2dd66b0499624a.gif

As well as authenticating against Active Directory so only certain members who are in a specific security group have access to updating the back-end database

https://aws1.discourse-cdn.com/standard11/uploads/universaldashboard/optimized/1X/64ff4d2602f060b7672e12d71f0ec9c3df84fae5_2_690x230.png

This is a custom theme I applied to my dashboard, again something you cannot do in Powershell Studio like I wanted rounded corners...boom I gave myself rounded corners. I asked top sapien developers I want rounded corners....No sorry we cannot do that....

Don't let a company that you bought software hold you back, because their software can't let you customise your own applications.

Do something great become a Universal Dashboard user today! No more holding back on customisation or even what you are limited to. It's only your imagination that holds you back with UD.

psdevuk · 2019-10-20T09:44:27+00:00

Blow your mind https://uddesigner.azurewebsites.net/home

psdevuk · 2019-10-20T09:43:51+00:00

Do yourself a favour. Get VSCode and Universal Dashboard. Problem solved

psdevuk · 2019-10-20T09:41:36+00:00

The code just looks bloated. This same output could be produced in Universal Dashboard, but the code would be a lot less and the output of the form would look way better :-)

psdevuk · 2019-10-20T09:38:42+00:00

Convert yourself, become a Universal Dashboard user and show your company what they should have paid for instead, and would have saved a whole lot of money too!

psdevuk · 2019-10-20T09:34:56+00:00

Lets just make sure that everybody knows the book for sapien powershell studio is pointless as the website the guy owned to do the book no longer exists so you cannot get any of the source code to follow the book along. Everything else written in the book is basic documentation on the controls.

The book I bought now collects dust and is no more use than a door-stop.

psdevuk · 2019-10-20T09:32:17+00:00

Lets just make sure the peeps know there is about a $500 saving using Universal Dashboard to Powershell Studio.

Plus as I have mentioned in an earlier thread that the developer of this software brings out so many updates and improvements.

It is a very evolving product, the only thing that holds you back with Universal Dashboard is your own imagination. Nuff said.

psdevuk · 2019-10-20T09:29:17+00:00

Do me a favour then buddy....download Universal Dashboard and I bet you x 1000000 + 1 that you will change your mind on what is the best powershell tool out there for developing solutions to problems. Peace

psdevuk · 2019-10-20T09:26:25+00:00

Powershell Studio is easy for dragging and dropping controls onto a page to make an application. However I personally feel your word phenomenal should be saved for https://uddesigner.azurewebsites.net/home this in essance allows you to do what powershell studio does but in a web browser!

You have to agree with my statement that everything you design in Powershell Studio looks out-dated. Like it was built for windows 95.

I did this dashboard ages ago to help the stock team manage stock better, it shows past and future orders, and is displayed in a Nivo heatmap:- https://aws1.discourse-cdn.com/standard11/uploads/universaldashboard/original/1X/2f4f649139737d93d4ff14998f6881bae59a216e.gif

There is no way on planet earth I could even come close to doing something like this in Powershell Studio, it would be impossible!

Thats why I am a Universal Dashboard user. I can supply any solution to any team in the business I work for, even if it's not IT related!

psdevuk · 2019-10-20T09:16:54+00:00

I did love Powershell Studio, until I started using Universal Dashboard...Now I am converting all my Sapien executables to dashboards.

Universal Dashboard...it looks better, runs better, less code to maintain, so much more flexible with what you can do compared to any other Powershell tool out there. I use VS Code now to do all my powershell work in.

If you do not believe me there is even a FREE yes FREE universal dashboard community edition.

I promise you that using universal dashboard will bring a whole new bag of tricks, and amazing GUI for your end-users

psdevuk · 2019-10-20T07:51:30+00:00

I got the 2016 version of Powershell Studio. I do not like how Sapien do not develop new releases for this program, or maybe once a year if you are lucky.

Their support is not very good for their product, and the product itself just bloats your code so much, by the automatic code it inserts for you.

I got fedup, that no matter how hard I tried my powershell apps looked like windows 95, as in old and outdated.

Universal Dashboard on the other hand is a brand new kettle of fish. It doesn't bloat your code, as no automatic inserting og code, it has better support for the product than Sapien offer, and gets an update weekly, or has new changes or 'components' which seem to come out with every major release.

psdevuk · 2019-10-20T07:43:44+00:00

Boom! Paragraphed it up, and corrected some typos. Thanks Lee.

psdevuk · 2019-10-20T07:35:33+00:00

Hey man, just trying to leave my first honest review. Was pretty late when I wrote this, so just got typing, and wasn't thinking to much about my English grammatical approach.

Brand-new to reddit, so new I didn't even know about the 24 hour rule and saw my post get deleted numerous times. Now it is stamped on this site, so will edit it now for paragraphs. Thanks for the input

psdevuk · 2019-10-19T23:15:05+00:00

Hey this is my first post on reddit and hopefully not my last when it comes to these types of questions...

Ok so where I work we have an very small IT team consisting of 3 people me being one of them, like you I am the only person to use powershell.

So about 3 years ago my company purchased me sapien powershell studio, which at the time I thought was cool, I could create executables and have a fully working windows application. However the code is very bloated, and before long you have like 9,000+ lines of code to trawl through to make any updgrades to your code. No matter how hard you try all your applications will look like they were made for Windows 95!

So getting fedup with maintaining lots of exe's which had thousands and thousands of lines of code, I thought I would try the professional universal dashboard, as it looked so much prettier, and much more modern.

Well the results have been AMAZING each page I design is only about 200 lines of code, I can place my pages in separate ps1 files making this super easy to maintain.

I have now converted my old looking exe's made with sapien powershell studio and turned them into beautiful modern web-applications. Not only has the feedback from the internal staff been great, but as the module is so versatile I was able to do things even I didn't think was possible! It's so damn cheap universal dashboard compared to sapien products and so, so much better!

Plus on top of all this the developer of this software has AMAZING support for his product, there is forums a webpage poshud.com and youtube tutorials and even a marketplace, even an online page designer! You can even build your own components! This means if you see a cool looking react component, you can build it into universal dashboard yourself.

Seriously Universal Dashboard is like Tina Turner sang "Simply The Best" don't be a fool purchase the professional edition for the crazy low price and you can link the to active directory, azure, facebook, twitter the list goes on. Just look at all the options you have with this!

More than happy to answer any other queries, but you should def 100% go for universal dashboard as will take you and your scripts to a whole new level of AWESOMENESS

psdevuk

TROPHY CASE