Reply to thread

Message: [QUOTE="Dick Kusleika, post: 8063547"] Layne I'm pretty sure you can do that stuff straight from Excel with a reference set to the Access Object Library. Since you have a command line that works, you might want to try something first. In VBA there is a Shell statement that basically mimics the command line. You would use it like Shell "C:\Program Files\Microsoft Office\Office11\msaccess.exe 'C:\Documents and Settings\Administrator\My Documents\Test Directory\Excel Access Test Db.mdb" /Excl /X Macro1'" However, you have to get the syntax just right particularly with regard to the double quotes. I'd give you some advice on that but I can never remember how to do it just right and have to relearn it every time. I'd guess it should look like the one above, but I can't be sure. Let me know if that doesn't work and you need help with an Excel macro that does the same as the Access macro. [/QUOTE]