Problems with a section of VBA

[ARGK]

Hi Fellow Forum Members
I am having an issue with a portion of my VBA code. Here is the code:

Please Login or Register  to view this content.

res is a variable which contains the name of the resource assigned to a selection of tasks in a MS Ptroject Plan.
Basically what is happening is that I have a template which contains VBA code. When I paste data into the template it is formated by code prior to this section of the code and it works fine. However this portion of the code leaves a copy of the template open as a read only version of the template. So I end up with approximately 20 copies of the template open as read-only. I am using Excel 2010.
Any help would be appreciated.
Kind regards
Tony

[Bob Phillips]

Could you try closing it after saving it?

[G e r a r d]

I tried the code in al little test macro..

Please Login or Register  to view this content.

The file name res should contain path and file extention
Extention must be .xls due to FileFormat:=56

Works fine with me.
After executing the macro, Excel closes.
Maybe problem is in the res string..

gr.
Gerard

[ARGK]

Hi Gerard
Here is a copy of my code for clarity. It is failing on the highlighted part:

Please Login or Register  to view this content.

Tony

[Sbarro79]

I noticed, there is a colon missing in res path (I think it should be D:\TR Programme\), although I have completely no idea, if this solves the problem

[ARGK]

Hi Sbarro79
Well spotted .
However this does not resolve my issue .
Thanks
Tony

[Izandol]

Have you tested

Please Login or Register  to view this content.

as Bob Phillips has suggested?

[G e r a r d]

Maybe it is better to use .Text is stead of .Value

Please Login or Register  to view this content.

I cant see what is copied into the sheet, but understand that there is a file name pasted in Range("A2").

Also

Please Login or Register  to view this content.

res is empty so code will goto Finish
Can't see what finish does.

Maybe debug the macro by steppin trough using [F8] function key may give you insite where the code goes and variables contain.

gr.
Gerard

[ARGK]

Hi Guys
No idea what is different but his code appears to work fine:

Please Login or Register  to view this content.

Thanks for your help guys.
Tony

[G e r a r d]

It's on several point different to the code posted initial.....