Search results

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