Skip to content
  • Home
  • About
  • Links
  • Posts
  • Donate

Powershell Administrator Blog

Those who forget to script, are doomed to repeat their work

Tag: Run Excel macros

Open Excel file and run macro

Posted on 20/12/201714/12/2017 by Powershell Administrator

I needed a way to open an Excel file and run one of the macro's inside the file to do some calculations and import some data then save the file as a new file, with the name of the previous month and its year added to it, to differentiate it from the original file. Make … Continue reading Open Excel file and run macro →

Tagged Open Excel file, Run Excel macrosLeave a comment

Recent Posts

  • Document rds environment
  • Azure Resource Inventory
  • Get-ServiceCredential
  • Get list of intune managed devices
  • Move witness disk in SQL cluster
  • Move images based on dimension
  • Add user(s) to group(s) – GUI
  • Get Remote Desktop Services info
  • Copy AD group members
  • Exchange powershell .Value.toMB()

Recent Comments

  • Eric on Download SolarEdge solar production data and save to csv
  • Powershell Administrator on Download SolarEdge solar production data and save to csv
  • Powershell Administrator on Exporting all scheduled tasks

Categories

Tags

.NET Active Directory Automatic Documentation Excel export to csv Get-Process Invoke-Webrequest non-default Notepad++ updater Powershell RDS Report SQL Text-to-speech Windows Services

Archives

OcinO – Powershell

OcinO – Powershell

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 41 other subscribers
Create a website or blog at WordPress.com
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    Powershell Administrator Blog
    Join 41 other subscribers

    Have a WordPress.com account? Log in now.

  • Powershell Administrator Blog
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar