I have looked at many examples and have yet to find the solution to adding a column in Excel via a vb script. Need some expert help on this one. The code below is a small snippet of a larger problem but this is where it fails. The 5th line starting "selection" fails with and "Expected statement" error but i can't find a solution. All I want to do is open the spreadsheet, go to column B and insert a column. Simple but I can't get it to work. If I record a macro I basically get the same code and it works as a macro but not in a VB script. What am I missing?
Set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks. Open strSourceFileName
Set objSheet = objExcel.ActiveWorkbook.WorkSheets(1)
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc.
In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …