Showing related tags and posts accross the entire site.
-
Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...
-
I am trying to avoid using sendkeys in one of the application. The code is simple and I am just trying to copy page setup from one worksheet to second using a hack. It selects 2 worksheets and activates the worksheet from which I want to copy the page setup and sends the keys to the page setup dialog...
-
Dear forum users and bloggers, I would be really greatful if you could help me with the following matter. I need to assign the "freight payer" which is either the sending or in some times the receiving plant, e.g. OT for Ontario etc. I have two columns "sender" and "receiver"...
-
Dear All , i was trying to execute this code and found that the code would just run fine the first time i run it and sometimes not , the error it throws is as follows ..........................i tested the printers and they were just working fine.......... any guesss? Thank you all for your suggestions...
-
I have created a multi-level custom shortcut menu in Excel 2003. I can use: Application.CommandBars.ActionControl.Caption to find out what selection has been chosen but I also want to know what selections were made further back up the hierarchy that got to the selection in the first place.
-
This Macro will create a series of 12 files in the same Directory as this file is stored It is recommended that you create a new empty folder, save a copy of this file in that folder, and then run the macro. Each new file will be named Jan.xls through to Dec.xls Within each file, there will be an individual...