Excel vba

  • Thread starter Thread starter B
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

How do you embed Access Report in Excel? 3
How to write a VBA program to load the webpages automatically 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Alt codes 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Running MS Access From Excel VBA: Communication Between Processes? 2
How To Use External VBA Custom Function In Excel ? 1
Excel/VBA Coding Help 4

Back
Top