Macro

[Henk]

When I was trying to record a macro in my personal macro workbook, I got the
error that the personal workbook is not open and I should have it open. How
do I resolve this?

 

[Jim/Chris]

This is an Access newsgroup. Try going to an Excel group

Jim

 

[Marissa Davies via AccessMonster.com]

I created a macro to export data from access to an excel spreadsheet. I used the TransferSpreadsheet Action and filled in the arguments accordingly. When running it, I get the following error:

"The microsoft jet database engine could not find the object C:\<lists the path here>"

Everything is spelled correctly in the path name, and the folder it points to contains the database.mdb file which I am trying to export from..

What am I missing? Do I need to do something else to create an object instance of the database I am trying to export? If so, how?

Please help... any ideas appreciated...
-Marissa

 

[Marissa Davies via AccessMonster.com]

I fixed that error, I think...

Forgot to place the path-name in "uotes" when defining it. Now, it says my database is read-only.. how do i change that?

-M

 

[Chris Reveille]

Even if your database is read only you should be able to
export.

Is your database located on the network? Is it on a cd or
did you copy it from a cd.
Check the properties in windows explorer and uncheck the
read only box.

Chris

-----Original Message-----
I fixed that error, I think...

Forgot to place the path-name in "uotes" when defining it.

Now, it says my database is read-only.. how do i change that?