Excel vba

B

B

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top