Showing results for Microsoft Excel - Scripting Blog [archived]

Sep 8, 2010
0
1

Copy Data from One Excel Spreadsheet to Another with PowerShell

ScriptingGuy1
ScriptingGuy1

Summary: The Microsoft Scripting Guys show you how to copy data from one Microsoft Excel spreadsheet to another one by using Windows PowerShell.   Hey, Scripting Guy! I have this monster Microsoft Excel spreadsheet that I need to make changes to. Frankly, it kind of scares me, because we use this spreadsheet for just about everything. It ...

Scripting Guy!Windows PowerShellOffice
Sep 7, 2010
0
0

Use PowerShell to Remove Personal Information from Excel

ScriptingGuy1
ScriptingGuy1

Summary: Learn how to use Windows PowerShell to remove personal and other information from Microsoft Excel workbooks in this Scripting Guys article.   Hey, Scripting Guy! At times, I really hate where I work. It seems everyone is always scared. They are scared to say what they really think in meetings, they are scared to make decisions, ...

Scripting Guy!Windows PowerShellOffice
Sep 6, 2010
0
0

Save a Microsoft Excel Workbook as a PDF File by Using PowerShell

ScriptingGuy1
ScriptingGuy1

Summary: Microsoft Scripting Guys show you how to use Windows PowerShell to save a Microsoft Excel workbook as a PDF file.    Hey, Scripting Guy! There are some things I really enjoy about working for a small company. I am the only IT person, and as a result I get a chance to do everything. I work with the Exchange Server. I add users to ...

Scripting Guy!Windows PowerShellOffice
Apr 5, 2010
0
0

Hey, Scripting Guy! How Can I Search a Microsoft Excel Workbook for Links to Other Workbooks?

ScriptingGuy1
ScriptingGuy1

    Hey, Scripting Guy! I have a user in our finance department that asked me today about using a Windows PowerShell script to identify Microsoft Excel workbooks that have links inside them to other Microsoft Excel workbooks. Frankly, I am not exactly sure what she is talking about, but I do think it is great that she asked me about ...

Scripting Guy!Windows PowerShellOffice
Feb 19, 2009
0
0

Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

ScriptingGuy1
ScriptingGuy1

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went around and typed a lot of information such as ...

Scripting Guy!Windows PowerShellOffice