Search results

I have an excel macro that all it does is export a table into excel, turns the field names to 90 degrees, copies the chart as a picture and exits. This macro will run several times in a given session. The problem is that on the second run it dies on "with Rows("1:1") The error is "Method 'Rows'...

I have a table on an ODBC connection where all the dates(RQDATE8_275) are in the yyyymmdd format I am trying to make a pass through query to retrieve the records with dates before today. With this code I get a missing right parenthises error. SELECT RQQTY_275 AS TRAV_QTY,PARTNO_201...

I am having trouble with a macro code that is run from access onto a worksheet in Excel. The part I'm having trouble with is when I try to apply a sort. I get a runtime 91 error. SRange does work to select the right area. the error comes on the sort Set xlapp =...

I'm trying to use VBA to send an e-mail through outlook. When outlook opens all my HTML formating goes away. It adds in my page breaks, but it will not add in any coloring or font changes. I have checked and my mail format is HTML, I have tried using WORD as my mail editor and not using WORD as...

I have links to files in a table "bob" What I want to happen is when I push a command button it will send these links in the body of an e-mail. I could put the rest of the body in a template if that helps but the messege will go basiclly like this. **messege*** LINK **Messege** LINK **Messege...

Ok forgive me I'm a newb. I curently have a query in access that I'm trying to make a button to automatically send the results of this query to excell. When I run the code (below) it gives me a compile error saying user defined type not found on the highlighted portion Private Sub...