I haven't worked with VB for a long time but I would like to read through and excel document in VB checking all the fields, formatting the various fields and saving they document.
A built-in Excel macro may be the way you want to go. I am actually working on the same thing. I'm able to perform about everything I want to in the macro (change page orientation, margins, fields widths, etc) but I don't know how to call this macro from the VB code. Right now, I'm just having the user run the macro each time with a shortcut command.
I'm not sure if the rest of the information you know or not but here I go. You begin creating your macro by creating a new Excel document. Save it as a template. Then start recording your macro from the tools menu bar. Just follow through all the steps you want the macro to do and then press the stop button. Then save it again. Then it's up to you where exactly you want to save this macro.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.