I am having the toughest time opening existing workbooks in excel from within an access module. I can open a new workbook but I cannot open an existing workbook.
I am trying to apply formatting to several worksheets within several workbooks. My original vba code to transfer data to multiple sheets is a loop (transferspreadsheet procedure within Access module). My toughest problem is applying the formatting into the Excel worksheets and workbooks, once created, using script within the Access module.
Do I need to write code in my Access module to open each excel workbook and apply this formatting to each worksheet (and how)? ... Or can this formatting occur without me opening each workbook and be included within my loop for the transferspreadsheet procedure? Thanks.
I am trying to apply formatting to several worksheets within several workbooks. My original vba code to transfer data to multiple sheets is a loop (transferspreadsheet procedure within Access module). My toughest problem is applying the formatting into the Excel worksheets and workbooks, once created, using script within the Access module.
Do I need to write code in my Access module to open each excel workbook and apply this formatting to each worksheet (and how)? ... Or can this formatting occur without me opening each workbook and be included within my loop for the transferspreadsheet procedure? Thanks.