Excel vba
 

Wanted to know if there is a code that pulls the settings on an excel
spreadsheet - column, fonts, page margins, header - into a vba code?
I have an excel spreadsheet already setup, but I need the code so I can
embed into MS Access application.

TIA!
Bob

Excel vba
 

Try using the macro recorder. start recording and go to format cells, go to
page setup, etc... see what the code looks like when you are finished
recording.

"B" wrote:

Wanted to know if there is a code that pulls the settings on an excel
spreadsheet - column, fonts, page margins, header - into a vba code?
I have an excel spreadsheet already setup, but I need the code so I can
embed into MS Access application.

TIA!
Bob