Word VBA >> Mac, Visual Basic Compatability

by Blake » Mon, 26 Jul 2004 22:45:05 GMT

I have a template I have automated with VB. Somebody in
our marketing department wants to use the template to
create a report. However, our marketing department uses
Macs. Will my template work on a Mac?

Thaks for any help.


Word VBA >> Mac, Visual Basic Compatability

by Howard Kaikow » Tue, 27 Jul 2004 04:52:27 GMT


I am posting this again because I do not see the first posting.


prior







Word VBA >> Mac, Visual Basic Compatability

by anonymous » Tue, 27 Jul 2004 15:04:43 GMT

In most ways, it will work on a Mac.
I work with a Mac and a PC.
But, if you use ini-files, it won't work.




Similar Threads

1. visual basic editor for word OS X for mac / integration with ENDNOTE - MS Word Support

2. visual basic 6.0 Pro compatability issue

My question is whether Visual Basic 6.0 Professional will run on the
XP pro operating system?  I purchased the VB professional package
a while back, and was using Win98 back then.

Are there software patches necessary, and if so, what are their names,
and where might I find them.

Thanks 


3. Visual Basic 6 and Access Compatability

4. Test VBA Code for Mac Compatability

I was given the following code by Dave Peterson which is suppose to 
delete the same columns on every sheet within a workbook.

Unfortunately, when I run the macro it doesn't behave as it should.  
Dave feels that the code should work on a Mac and doesn't understand why 
it doesn't.

So we're wondering if anyone else has the same problem, or whether the 
code runs as it should on other Macs.

Here's the code I'm using...

Option Explicit
Sub deletecols()
Dim sh As Worksheet

For Each sh In ThisWorkbook.Worksheets
  sh.Range("a1:c1,m1:q1").EntireColumn.Delete
Next

End Sub

When I run it, it deletes columns starting from Column S (I have data 
from Columns A to Column Z on three sheets), not the columns stated in 
the code (Columns A to C and Columns M to Q).

And when I change the range to the following, I get the corresponding 
results:

Range("a1:c1")  ---> Columns X, Y, and Z deleted

Range("a1")  ---> Column Z deleted

Anyone else get the same results?

5. Converting Word basic macro to Visual basic - MS Word&VBA

6. MAC OS Excel 2008 Visual Basic Programming

Hi All

 

I have designed a application in MS Excel 2008 on Windows XP using Visual 
Basic Application (VBA).

Each and every thing is going fine on my side.

My client is using MAC OS and MS Office for MAC. When i deployed my 
application to Client end one serious problem comes arise.

 

The problem is that when my client is opening this project he is getting it 
into the Design Mode.

 

He is unable to select from drop downs, enter values to text boxes........

 

Please help me guys. I put my all the efforts.

I think now its the time to put your efforts.

 

I will be very thankful.

 

Please give me a suggestion.

 

Thanks and Regards

7. Visual Basic Excel Mac

8. Visual Basic Problem with Excel 2004 on Mac Pro

I have recently changed from a G5 to a Mac Pro (Dual Core Intel Xeon).
Clean installation of the operating system, fresh installation of
Microsoft office, all updates installed using the automatic update
features of the system and of microsoft office. Most things run fine.

However, Excel has become quite unstable and crashes rather frequently.
Most of these crashes I cannot link to any particular action or event.

However, one sequence of events reproducibly leads to a crash: If I try
to edit a label in a user form, excel crashes.

Suspecting a problem with the installation or with the Excel workbooks
I works on, I have done all I could think of:

Office removed, all office-related preferences removed, Office
reinstalled from CD and updated to the most current state (Microsoft
Excel 2004 for Mac Version 11.3 (060914)).

Test:
I generate a new workbook (from scratch, no custom template)
I open the visual basic editor, and select "User Form" from the
"Insert" menu to generate an empty user form.
I select the label tool ("A") from the tool box and define a label area
on the userform
As soon as I try to enter any text for this label, either within the
field on the Userform or in the appropriate field in the "Properties"
window, Excel crashes.

On my G4 Powerbook, I experience no problems with the same actions.

            Does anyone have an idea what could be wrong?