Recent content by Etherington

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 |...