How to execute/open .bat or .vbs file using VBA in Office 2011

Question

Hi,

I have an Macro Enabled excel file on a shared folder that contain a VBA program which executes on workbook open event. This Macro updates a MS Access file using ADODB connection.

Is it possible if I can open this workbook from MAC office 2011 VBA (using .bat or .vbs) and will do the same fx as window and wouldn't give any error?

Thanks

Rajiv Dixit

Answer 1

No there is no MS Access equivalent for Mac and doesn't use .bat files that exclusively a PC thing.

The only way is if you are using Parallels or Boot Camp to call up a Virtual Machine  and have Windows 7 or 8 loaded plus the necessary software.

Answer 2

As Phil pointed out, there is no Mac version of Access. However, Excel can read and update Access files on a server using drivers from Actual Technologies: http://www.actualtech.com/product\_access.php

Your explanation is very ambiguous. It sounds like you want to open the Windows created Excel file and have it work on the mac. this is pertty unlikely depending on how the Windows foile was created. But, you can, as mentioned above, create  Mac Excel file which references an Access database.

Explain your problem in more detail, and perhaps we can help further.

Answer 3

The short answer is, "No. You cannot."

ADODB connections are two-way. With ADODB You are able to use table manipulation commands such as add record, delete record, add column, delete column, etc.

Excel on the mac supports read-only operations. You can perform select, order by, group by, paramter queries, etc but you can not do table manipulations.

A work-around might be to have an Excel file in the shared directory that VBA could manipulate from within Mac Excel, but I've never tried such a feat. If you could figure out the file paths you might be able to do this.

Answer 4

The short answer is, "No. You cannot."

ADODB connections are two-way. With ADODB You are able to use table manipulation commands such as add record, delete record, add column, delete column, etc.

Excel on the mac supports read-only operations. You can perform select, order by, group by, paramter queries, etc but you can not do table manipulations.

A work-around might be to have an Excel file in the shared directory that VBA could manipulate from within Mac Excel, but I've never tried such a feat. If you could figure out the file paths you might be able to do this.

Hi Phillip, Bob, Jim,

Thanks for your help and try to understand my query though I couldn’t explain it clearly at many points.

So it’s like, I have a batch file in a shared folder which is on Window machine. When we open or execute this batch file, it opens an Excel file which is also on the same window shared drive. In this excel file there is a Macro/VBA program that executes automatically when workbook open (On Workbook_Open event). This Macro/VBA program updates an Access file which is also on the same window shared drive using ADO Connection.

As mentioned above I have a batch file, Excel file with Macro/VBA Program and MS Access in a shared folder which is on Window machine. So my question is, Can I open or execute this batch file from MAC machine using Macro/VBA Program written in an MS Excel file (MS Office 2011)? I am sure it can be done using shell command from window machine instead of MAC.

Thanks

Rajiv Dixit

Answer 5

The Mac can not open and process the batch file.