Skip,
I've actually "inherited" the programming from a co-worker who's on maternity leave, so most of the VBA is foreign to me. Typically, I deal with Microsoft Access, and I am not too familiar with Excel and Word.
Here's the lowdown:
The original macro is in an Excel spreadsheet...
Hello,
I have an existing template document requiring a 4" x 6" page format. A macro runs within the Word document with User prompts to format tables, titles, etc. to suit the 4" x 6" format.
At the end of the code, I would like to import a new file as the first sheet in...
Would I need to link the two tables with a common field and then create a report based on a query or a subreport. I've kind of stalled here with what to do.
If you want a quick and dirty solution, then create 2 new macros:
MenuBar (1st Macro Name)
Macro Name Action
&File AddMenu
Action Arguments
Menu Name &File
Menu Macro Name MenuBar_File
MenuBar_File (2nd Macro Name)
Macro Name Action
Exit RunCommand
Action...
Hello,
Per the crude example, I'm attempting to format a report that will automatically sum the values from one column [TaskTime], and expand the field [Duration]in another column to suit the summed time (in 1 hour increments).
| Duration |...
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.