Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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
 
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.
Click to expand...
Now, it says my database is read-only.. how do i change that?
 
Back
Top