Hello...
I am trying to add a range to the end of this DoCmd statement and you'd think it would be easy...not a chance for a newb as me..
yes, I have tried every possible combination I can think of and well, here I am.
As I'm sure you can tell, I'm simply trying to add the range to the strWorksheet variable
Code:
StrWorksheet = "Sales Grand Total Summary"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "TempSalesMTD", StrNewFileName, True, StrWorksheet & .Range("A4:K4")
Thanks for any help...