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

Powershell Administrator Blog

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

Tag: Open Excel file

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

  • Add user(s) to group(s) – GUI
  • Get Remote Desktop Services info
  • Copy AD group members
  • Exchange powershell .Value.toMB()
  • Change mailbox language
  • Get ACLs on non-inherited folders
  • Get AD RDS Profile information
  • [decimal] conversion has some unexpected behavior depending on culture settings
  • SetAccessRule fails “The trust relationship between this workstation and the primary domain failed.”
  • Passing user credentials to a remote computer

Recent Comments

  • Ed P on Download SolarEdge solar production data and save to csv
  • K0EN74 on Download SolarEdge solar production data and save to csv
  • Powershell Administrator on Download SolarEdge solar production data and save to csv

Categories

Tags

.NET Active Directory AD Automatic Documentation Error-Handling export to csv Get-Process Invoke-Webrequest non-default Notepad++ updater Powershell RDS SQL Text-to-speech version

Archives

OcinO – Powershell

OcinO – Powershell

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

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

Join 647 other followers

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: Our Cookie Policy