Actually I've been controlling the Excel object from Access, but I've been running into trouble with Access not understanding some of the Excel constants in my code. So I was looking to send a macro from my database into an Excel file and then run it. I need to be able to automate the transfer...
Beautiful,
thanks Alan it worked.
Drevlin,
Actually I already included the Excel library and it still didn't work. When I put the numeric values instead of the words it worked.
Thanks guys,
Mike.
Hi,
I have an Access database and I need to get data from an SQL Server database table using Access VBA. I need to be able to locate specific records and read the data only from certain fields. I don't need to edit or add records in the SQL table, just read it.
However, I don't know anything...
Hi,
Is there a way to somehow "export" an access VBA module into Excel, and then run it. I have a multiuser database that creates an Excel file in a user's computer and exports data into the spreadsheet. I would then like to change the formating of the spreadsheet (ie add some borders and...
Hi,
How do I add/edit borders in an Excel file using Access. I have code that export's data to an Excel file and then formats the contents. Everything works except it gives me an error when i try to create borders around certain cells. I used Excel's macro recorder to get the code for...