-
Hi, I have a huge problem: I have an Excel spreadsheet that links to Access database to pull data and use access table to render excel format with the data in it. But, when I hit Add/Modify button I receive this Runtime error 9 and debug mode send me to this code: Private Sub ADDC_Click() Call boot_rules...
-
Hi, I am in need of expert help and as I was browsing the nest I came across this site, so I joined. Well I have created a work book which pulls out data from the schools database and populate separate worksheets. Now I have field titles such us 'Tutor Group', 'Gender', 'Ethnicity'...
-
I have a sheet in which I enter a date and on another sheet I have dates list in column A and corresponding date to that date in the other columns. I what my macro to find the date entered and go to that cell on the second sheet. HELP
-
I have a workbook that I create from Access using the .CopyFromRecordset command and then create subtotals using the selection.subtotal GroupBy etc. This all works fine. I would like to format just the subtotal rows' font color and size but can not find the right code to accomplish this. Any help...
-
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.