Search results

I have code I wrote that automates an Excel application and MS Graph via an Event Procedure in Access (this is all done with Office 2000). Whenever I run the code, I watch the Excel application open, the first sheet is populated with the data, and then I watch it automatically generate the...

Hi. I am trying to export a query I stored as a String in VBA (SQLstr) into Excel. However, it gives me the following error: Could not create spreadsheet. Error: 3061 Desc: Too few parameters. Expected 2. The code I am using is as follows (with unimportant stuff left out): Dim db As...

When manipulating an Excel application from Access (that is, open a .CSV file, make some changes, save changes, close excel application), how does one stop the save confirmation box from popping up? Otherwise, is it possible to have the VBA code automatically select yes to the confirmation box...

I am trying to open an excel file as a delimited file using VBA code (so I can perform some automated manipulations on the file from Access before importing the data into a table). The issue I am having is with using the file open parameters (with the exception of Origin, which Access VBA...

I have an Access 2000 database I created with Event Procedures attached to the On Click Event line in Command buttons' Properties menu. This, so far, is not unusual. However, the Event Procedures on my buttons suddenly started associating themselves strangely. Without making any changes to...