その業務、効率化できてますか？ こんにちは。私は(株)SHIFTで主に社内教育を担当している根岸です。 私は社内で主にExcelの研修にかかわらせていただいています。 私自身は業務で毎日Excelを使っています。 Excelの教育に携わることで自分のExcel知識も深まり ...

社内システム利用や様々な資料作成等でまだまだ利用用途のある Excel,Access等Office製品とそのVBA・マクロがあります。 私自身の経験としては、システム開発企業に属し、VBA機能の 開発(大小さまざま)、内製Excel・Accessからの機能置換開発、社内資料、 社内 ...

Microsoft first announced plans to retire the Visual Basic Scripting language in 2023, giving developers and organizations ample time to prepare. The company is now reiterating ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...

Do you want to automatically download and save attachments when you receive new emails on Microsoft Outlook to a certain folder? Well, if you ever wondered how, this post will show you how to download ...

<br><br>If that's not clear, here's a screenshot of what I mean. I happen to be viewing that in Excel 2007 but they're using E2k3. This grouping/"outline" is an Excel thing.<br><br>This was generated ...

Rem @license MIT (http://www.opensource.org/licenses/mit-license.php) ' Call ブックのフォントを指定フォントに変更(ActiveWorkbook, "メイリオ ...

at work, i made up a vbs file that serves as our login script. it basically just maps various network drives. some are defaulot for everybody, and others are decided by simple if/then statements based ...