Search Result

BeachBummin · Feb 9 '12, 11:18 PM

Hello,

I have a listbox populated with a series of queries. I am trying to write code so the user selects the query from the list and clicks and export command button.

Code:

Private Sub cmdExport_Click()
Dim strQuerySelect As String
Dim lstQueryBox As ListBox

strQuerySelect = lstQueryList.Value

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, strQuerySelect, "C:\Documents

...

Feb 22 '06, 06:05 PM

I try to use this command to import a spreadsheet

"DoCmd.Transfer Spreadsheet acImport, 8, tablename & " -tbl", DIR &
"Book2.xls" , True"

and it errors out. If I try to import that same spreadhseet with menu
commands directly it works fine. The Docmd.transfers preadsheet command
has always worked for me in the past, I will admit the excel file I'm
importing is...

Nov 13 '05, 04:58 AM

Hello, I'm getting an error with a Docmd.Transfers preadsheet line of
code:

DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel2000,
"tblTest", pathAndFilename , True

The above line works perfectly fine, but when I change the table name
argument (tblTest) to the name of a query, it fails and gives the
following error:

Runtime error 3275
Unexpected error from external...

Search Result

Referencing listbox value in export code

DoCmd.TransferSpreadsheet

docmd.transferspreadsheet unexpected error