Thank You ghudson for this excellent code !!
I had "9-subscript out of range" like some of the others. I added a second argument to the function for the sheet's name
Public Sub ModifyExportedExcelFileFormats(sFile As String, sSheet As String)
and changed...
Hi, My name is Mark and I've been using this forum to help me out a bunch. I thought I would join in on the discussion now that I am comfortable using Access. I am pretty much a self taught user because of great forums like this one!!!
Thaks