Recent content by sdell

Non of the formatting is working. What appears in another piece of code is an addt'l blank workbook opens while the main workbook opens. Kinda of strange. Is there code to suppress the blank workbook.

No. Just doesn't format.

So, this code that follows works fine. It runs a query and exports the data into Excel 2016. My problem is it does not format the data in Excel. It appears its not saving. I need help in formatting my output. I think i am missing a piece of code. Please help me. Silvana Private Sub...

Hi everyone I am a analyst at a Hospital in Philly. Trying to automate my data pulls in Access and exporting into Excel for distribution. Not a very savy VBA programmer, so need help and suggestions. So, this code that follows works fine. It runs a query and exports the data into Excel 2016...