Recent content by msk7777

Thank you so much! That was the issue. I was able to get the code correct! Public Sub ModifyExportedExcelFileFormats(sFile As String) Dim xlApp As Object Dim xlSheet As Object Dim myrange1 As Object Dim myrange2 As Object Dim myrange3 As Object Dim lastRow As Long Dim Cell As Range Set...

Thank you so much for your help everyone! Sorry for the delay in response but I have been trying all your suggestions, however, I am not getting any to work. sxschech - I'm a tad bit confused as to why I am referring to my database table when I'm trying to count the rows of the spreadsheet...

namliam - thanks for leading me to review Squid's post further. Let me start by saying that I am self-taught in regards to VBA and may be overlooking something so please forgive me in advance. I previously used this code in another database where the columns and rows were static. Now I am...

I will do my best to not get further agitated and will politely state that I am 39 years old and have been out of school for a very long time. I simply posted my question to get help on my work database. If you reviewed any of my previous posts you wouldn't have just considered me a waste of...

Thanks for replying, however, I'm afraid that isn't what I am asking here. This request involves a query that has already been exported to Excel. I am attempting to format that spreadsheet after the export is complete.

I have the below code (borrowed) that reformats a query that was exported to excel. I need to define a range that would be all the data on the spreadsheet. Each output of this query changes so it needs to find the range. Can anyone help me adjust my Set of "myrange1" since all the definitions I...

THANK YOU!!!!!!!!!!!!!! This is now working just as I needed it too! I was thinking two weeks ago this would never get done but now it works! Thanks you so much....and Minty too!

yes sir that is the same form.

It looks like we are headed in the right direction! Yes, we need to next pass each office name (and the date parameters) in the follow query: SELECT ClaimsBatchMasterUNIONQuery.PolicyNumber AS [Policy Number], ClaimsBatchMasterUNIONQuery.DOB AS [Patient Date of Birth]...

Yea you had : Set GetRecordset = CurrentDb.OpenRecordset(SQL) I changed it to Set GetRecordset = CurrentDb.OpenRecordset(sSQL) No errors & I see in the intermediate window all the office names.

Ok that killed that error, now I get a compile error: Variable not defined. Debugging highlights : Private Function GetRecordset() As DAO.Recordset

Mark when I run it I get an error : The Microsoft Office Access Database engine cannot find the input table or query". Make sure it exists and that its name is spelled correctly. Debugging points to: Set GetRecordset = CurrentDb.OpenRecordset(SQL)

It does make sense and as soon as I have a second to test this I will do that for you. Give me a little bit and I will respond with what I found. Thanks again Mark!

Ok I will try to catch you up sir. The code we just finished creates a query that pulls a list of dental office names that had claims entered into the data base between the date parameters entered on the form. The next step would be to add on to that code so that for each dental office name...

Minty was helping me in stages. If you reference his post: Apologies I was intent on getting your recordset correct - we haven't covered the looping bit yet. (always break tasks like this down into "simple" steps. Get the selected data right , then work with it.) Unfortunately - I'm pretty...