Visual Basic conversion to Applescript

[TomKC]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel A company sent me an Excel file that has embedded VB code that allow the data fields to be uploaded into a front-end of a website.

Since Office 2008 does not have a VB Engine I would like to know if it's possible to convert/write this same function in Applescript in order to make this function when using the Mac.

The three functions are "Import New Data" Export Data" (.xlsm file format) plus "Reset".

There is also a field that has two radial buttons associated with it (i.e. Yes/No) to determine how the input information is routed.

The company said if I can figure out someway to get the Applescript to work they would have their engineers Map it into their system.

Any thoughts?

 

[John McGhie]

Well, the response they gave you is fairly typical.

Generically, you can do almost anything in AppleScript that you can do in
VBA.

However, it's often laborious, and it means you have to re-create the
program because AppleScript and VBA do not go about their tasks in the same
way.

It can turn into a lengthy and expensive coding job.

Better, I think, to spend seventy bucks on a copy of Parallels and drop a
copy of Windows 7, and a copy of Office 2010 onto your Mac.

Trust me, you will ultimately spend a lot less money, and a lot less time!

Hope this helps

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
A company sent me an Excel file that has embedded VB code that allow the data
fields to be uploaded into a front-end of a website.

Since Office 2008 does not have a VB Engine I would like to know if it's
possible to convert/write this same function in Applescript in order to make
this function when using the Mac.

The three functions are "Import New Data" Export Data" (.xlsm file format)
plus "Reset".

There is also a field that has two radial buttons associated with it (i.e.
Yes/No) to determine how the input information is routed.

The company said if I can figure out someway to get the Applescript to work
they would have their engineers Map it into their system.

Any thoughts?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[Bob Greenblatt]

Well, the response they gave you is fairly typical.

Generically, you can do almost anything in AppleScript that you can do in
VBA.

However, it's often laborious, and it means you have to re-create the
program because AppleScript and VBA do not go about their tasks in the same
way.

It can turn into a lengthy and expensive coding job.

Better, I think, to spend seventy bucks on a copy of Parallels and drop a
copy of Windows 7, and a copy of Office 2010 onto your Mac.

Trust me, you will ultimately spend a lot less money, and a lot less time!

Hope this helps



--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

You forgot to add the cost of a version of Windows and Office to the
$70. Even with these additional expenses, I agree that the total cost
will be several orders of magnitude less than the cost of creating an
AppleScript version of the VBA.

 

[TomKC]

Thanks for the frank and honest answer. It was what I was expecting, just not what I was hoping for.