Search results

  1. C

    Using VBA to sort through a range for first cell with error

    Hi all, I am working on an Excel project for work in which I need to write a macro that, among other things, searches through a range of cells and returns the first cell that has a #DIV/0 error. That range calculates a division of cells within a pivot table. If the pivot table has 5 rows of...
  2. C

    Moving cursor after copyfromrecordset

    Hi all, I currently have an Access macro that uses CopyFromRecordset to copy query data to a specific cell in an Excel sheet. I now want to automatically run an Excel macro that manipulates that data. How do I move the cursor from A1 to the first cell of the new data, as that’s where my excel...
  3. C

    Exporting query to excel using vba

    Hi all, I’ve written a pass-through query and an autoexec macro that runs said query and exports it to excel on startup. Is there a way to export the query data to an existing excel file at the bottom of the existing data? All I’ve been able to find is exporting it to a new file or a new...
  4. C

    Query data pull takes FOREVER

    Hi all, I run an Access query every week that pulls data from a table that is linked to an external warehouse. The query selects a ton of data, but it takes about 40 minutes to execute. Is there any way to speed that up, or is it a bandwidth issue?
  5. C

    ODBC error on pass-through query

    Hi all, I’m trying to automate a query that requires a security login and password through ODBC. The internet said to use a pass-through query and showed me how to do the ODBC Connect Str in the Property Sheet. I saved the password to the string, but when I run it, it returns an error saying...
  6. C

    Parameter query automation

    Hi all, I’m new to forums so I’ll give it a shot. I have an existing parameter query that pulls data from a db. I want to create something to automatically run that query and automatically fill in the needed parameters. Eventually I will be putting all this into task scheduler to run this query...
Top Bottom