Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Search results for query: *

  1. Washingtons

    Exporting access file to excel file with VBA

    I'm trying to export my access database to excel without overwriting what was already on the file. My query is called Combined Data Query and I'd like it pasted on the first worksheet of an Excel file called Stoplightchart.xls Can anyone write the code for me or point me in the right...
  2. Washingtons

    VBA Looping with AutoFilter!!!

    I need to create a document that searches for a criteria in autofilter, copy & pastes that into another sheet, uses autofilter to search for another criteria, copy & pastes that, etc 128 times. Any ideas for how to do this using a loop. This is for work & I need help ASAP!!!
  3. Washingtons

    Procedure too large--help!! VB Novice

    I'm extremely new to Visual Basics and instead of learning how to use it, am trying to record an extremely long macro. It told me my procedure is too large and I'm only 1/4 of the way done with my macro. I have no idea how to begin using visual basic and need any help I can get to either shorten...
Back
Top