[SOLVED] Activating Excel Template .xlt

I got and error that says "[Filepath] cannot be accessed."

It goes on to say, "The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding."

The workbook is not protected, but it is read-only because it is an .xlt file.

Is there another way to go about doing this?

I did. I had the whole filepath...I just shortened it when I was replying to you.

It is in there as "Lorencz/Users/amykate/Desktop/MacroTemplate"

Well, I tried it out in a new spreadsheet, so it is all by itself right now, so no other code is messing it up.

Please Login or Register  to view this content.

That's how it is exactly.

The file is MacroTemplate.xlt and it exists in Lorencz/Users/amykate/Desktop

Don't I need to specify the path somewhere?

So it works if both the file the macro is stored in and the template I am opening are in the same place (ie. Desktop), but I plan for the macro to be on my personal macro workbook in my Excel Startup folder and the template to be on my desktop, so how do I tell it where the file is?

Here is my updated code...

Please Login or Register  to view this content.

Originally Posted by shg

Please Login or Register  to view this content.

I am on a Mac, will that still work?

None of these ideas seem to be working at all. I just keep getting error after error.

Let me rephrase my question...

All I need is for it to open a workbook. Before I was wanting to activate the already open template, but now that I know I can just open it, that's even better.

The workbook is an .xlt file saved to my desktop (Lorencz/Users/amykate/Desktop) and the macro is in my Personal Macro Workbook in my Excel Startup folder (Lorencz/Applications/Microsoft Office 2004/Office/Startup/Excel).

I would appreciate it if the full code could be posted instead of a piece, so that I know I am not pasting that piece into the wrong part of the entire macro.

Thanks.

Please Login or Register  to view this content.

is highlighted

This is what I got...

Run-time error '1004':

'Lorencz/Users/amykate/Desktop/MacroTemplate.xlt' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed or moved, or deleted.

When I clicked debug, the line

Please Login or Register  to view this content.

is highlighted.

It does without the Lorencz in front of it, but I've tried it both with and without that and I still get the same error.

I had gotten it to work at one point with this code...

Please Login or Register  to view this content.

But, that required the template and the file in which the macro was stored in to be in the same place.

Would you have any idea how to edit this code? It works...just needs something added.

Well, I decided to compromise and just put the template in the startup folder because I usually don't need to access it much except when I am running this macro.

It isn't perfect, but it works.

If anyone else does have a fix, I'd be up to try it.

Thanks so much shg and royUK for all your help!

-Amy Kate

Please Login or Register  to view this content.

Using that code, I get the following error:

'MacroTemplate.xlt' cannot be accessed.

The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

When I click Cancel and Debug, the part in bold up above is what is highlighted.

Any ideas as to why?

It is definitely on the desktop. I always click the template type when I am saving, then go to where I want it saved. Also, I only have 3 things on my desktop, so I see it there.

I have tried that second code; however, that only works if both the template and the macro that is being run are in the same location and that is not the case because my macro is on my personal macro workbook in my excel startup folder.

I had it working fine with the code royUK provided

Please Login or Register  to view this content.

but like I said earlier, it just requires that they both be in the same location, which is alright, I guess. I just put the template in the startup folder and it worked, but I'd really prefer the template to be on my desktop.

Oh my goodness! You are amazing! You totally got it!

And that code is so much simpler than this other stuff too!

Wow, thank you so much!

Thank you to everyone who helped out as well.

This was definitely a learning experience for me.

:]

-Amy Kate