Hello there,

First let me say I am new to VBA programming and so if something I say is complete nonsense let me know or ask questions, I'm here to learn.

I've written a couple simple Macros for work, and have been given a more difficult project to master, and of course my first hurdle was hit head on right away.

The macro I need to write will be used on a document that is generated by an outside program: the other program opens Excel and essentially runs its own macro to setup the document with information from the outside program. My problem is that it does not allow me access to my previous macros or allow me to record to the Personal Macro Workbook: the Personal Macro Workbook does not open, and I get this error:

"Personal Macro Workbook in the startup folder must stay open for recording." I hit ok, "Unable to record."

I looked at the hidden workbooks and its right, this workbook is not there. So I'm looking for a way around this. We're a regulatory department so copying the generated information into a newly opened Excel workbook (giving me access to the Personal Macro Workbook) would be frowned upon, plus it messes with the formatting of the document.

Is there a way I can create this workbook as part of the macro? I thought about creating a new document and saving it in that form, but we have a background program that won't let us save Office documents just anywhere, they must be in a Document Management program, and it won't give me the option to save it in that form; plus there's the fact that if I can't record in the first place how do I make it create that file.

Any suggestions, hints, opinions?

Thanks