Search results

You're a Genius It worked perfectly (code below) DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ztransposed", sfile 'Set xlapp = New Excel.Application Set xlapp = CreateObject("Excel.Application") xlapp.Application.Visible = True...

Still fails I have also tried a few things trying to get it to close since i posted. it still fails, this is my code now. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ztransposed", sfile Set xlapp = New Excel.Application 'Set xlapp =...

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

Figured it out I figured it out... SELECT RQQTY_275 AS TRAV_QTY,PARTNO_201, RQDATE8_275 FROM FRH_MRP.PSK02275_OPEN WHERE RQDATE8_275 <= TO_CHAR(SYSDATE, 'YYYYMMDD')

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 figured it out. SRange is declared as a range Set SortRange = ActiveSheet.Range("A1", "O773") SortRange.Sort Key1:=ActiveSheet.Range("H1"), _ Order1:=xlAscending, Header:=xlYes, OrderCustom:=1, _ MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal...

What did you have SRange declared as? I had it as a string ex: SRange = "A1:P151"

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