Any help on this would be very much appreciated: I would like to open a text in access via EXCEL VBA, and save the file as Comma delimited format. I have the following code below: it produces the following error message: Expect Function or variable:
Dim objXL As New Excel.Application
Dim...
I would like to send the results of my recordset (i.e Access records) to Excel but everytime i send it to Excel, it opens a new Excel application. Can anyone tell me how to send it to Excel without launching another Excel applicationand how to launch/open Excel if it's not running already. for...
is there anyway to find out if a query has a parameter(s) programmatically. for a example, i have several queries and i wanna check the queries first before passing a parameter(s) to the query.
any idea will be useful.
Mrxdotcom