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