Applescript and Windows applications

[Whalabi]

I was wondering if someone can help me create an Applescript program to copy a set of 500 figures from an excel spreadsheet column into a table on Quickbooks running under Windows on a Bootcamp partition (VMWare Fusion).
The only way it can work is to copy each cell, then paste it in its corresponding table in Quickbooks; go back to the spreadsheet, copy the following cell, go back to QB, tab + tab, pate the figure, back to Excel, etc.
Thanks

 

[robbieduncan]

I'm 99% sure that AppleScript can't talk to Windows applications (even if they are running in a virtualised Windows environment on a Mac).

 

[Whalabi]

I'm not surprised.
I guess I can open the Exel file under Windows. But is there a Windows application out there that can do the same as Applescript?

 

[balamw]

You can probably do it in VBA in Excel for Windows.

However I'd suggest focusing on exporting the pictures into a format that QuickBooks understands. PNG or GIF for example.

You could do that entirely in OS X and then worry about importing to QB separately.

B

 

[Whalabi]

I hate to say this, but I'm not familiar with Windows at all. What's VBA?

 

[robbieduncan]

I hate to say this, but I'm not familiar with Windows at all. What's VBA?

Visual Basic for Applications.

 

[balamw]

Something like this: http://www.ozgrid.com/forum/showthread.php?t=21918&page=1

B