Recent content by Jewlrose

That fixed it!! Many thanks.

I'm sorry- I don't know. I am very new to VB. I have it being called from a macro and don't know how to get it to highlight which line of code it breaks down at. The Macro is just a RunCode macro where the function name (arguments) is the following...

I will post the code at the end. I found some coding to save data from a query to a particular worksheet in a particular excel file. It was working fine, but I was trying to find a way to make it close the excel file and application after. Every time I tried to edit it, I ended up with the...

I stopped trying to edit the module and instead used a macro to call the module, as was the original module's intent (I later discovered). --Bob Larson @ microsoft.com

Got it working!

As a note, if I put quotes around the second reference to the file path (strPath = strFilePath) so that it reads: strPath = "O:\TargetFolder\2012\myfile.xlsx" , that works fine. However, if I put quotes around it in the first reference (strFilePath As String), it gives me the following error...

I've done some programming in other languages, but am a complete newbie when it comes to VBA. I needed to send a query to a specific sheet within excel (so it wouldn't save over the entire workbook each time) and found a module online to do so. As I cannot link the site, I will include the...

I have data linked from access into my excel workbook. There are other files that pull from this excel workbook, but not directly from access. I would like to ensure that whenever I update information in access, it automatically updates the information in excel without needing to open the...

That worked perfectly!! Thank you so much!

Bob, Thank you so much for your reply, I'm not certain I quite understand. I currently have a query that merges and calculates information from multiple tables/queries and a report which displays the information in that query. That query currently limits the counties to a specific list of...

I have information for various counties in a table. I want the report to show 11 specific counties. Originally, I wrote this into the criteria section of the query (countyname = "county1" OR "county2" OR ... OR "county11"). However, I also want to have a sum of the data in the report header...

I figured it out. Two things: (1) As it was summary information, it needed to be placed in report header, not detail and (2) the source hadn't been selected, so it didn't know where to pull the information from. Fixed both, now it's working!

I have a table with the following information: OrderID RequestRecieved PackageSent Department The data in the fields is as follows: OrderID: A numeric id number RequestReceived: Date PackageSent: Date Department: One or two character initial (There are 7 departments in total) I am...