Sorry, I don't have another guess.

Does the code work in a brand new workbook's project?

I bet it does, so there's something bad going on in that original workbook.

James8309 wrote:

On Jul 1, 9:53 pm, Dave Peterson wrote:
Did you create any subroutines/functions called Open?
Did you name any of your modules Open?

James8309 wrote:

Hi everyone,

one of my line in my VBA code is ;

Workbooks.Open Filename:="G:\ReportFiles\ReportTemplate.xls"

and I do not understand why this line creates "Invalid Procedure call
or argument"

Please help

thank you,

--

Dave Peterson

Nope :(

--

Dave Peterson