auto insert column when sheet is opened

I have an outside program that feeds measurement results into Excel. The programming of this outside software only allows the insertion of data into one column of a worksheet, Column C. Currently, we need to manually open the excel sheet, insert a new column, and close the worksheet between measurment runs. My question is whether there is a way to program excel to automatically insert a column when this outside program opens or closes the worksheet? Any insight on this subject would be very much appreciated.

Mike

Hello Mike,

Welcome to the Forum!

If I understand your post, the data is always posted into column "C", correct? One other question. What version of Excel are you using?

Sincerely,
Leith Ross

Yes, the data is always put in column C. We are currently using excel 2003. Thank you for trying to help,pulling our hair out here

Hello SMUGGLINGSTONES,

Once installed, this macro will insert a new column in column "C" and shift the old column "C" to the right whenever the workbook is opened. Change the sheet name in the code to match yours.

Please Login or Register  to view this content.

How to Save a Workbook Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on any Worksheet's Name Tab
3. Left Click on View Code in the pop up menu.
4. Press ALT+F11 keys to open the Visual Basic Editor.
5. Press CTRL+R keys to shift the focus to the Project Explorer Window
6. Press the Down Arrow Key until ThisWorkbook is highlighted in blue.
7. Press the Enter key to move the cursor to the Code Window
8. Paste the macro code using CTRL+V
9. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

Works Great! Thanks a Bunch! I owe you one!

Mike