Applescript and Windows applications

Discussion in 'Windows, Linux & Others on the Mac' started by Whalabi, Oct 13, 2010.

Most Liked Posts
  1. Whalabi, Oct 13, 2010

    Whalabi macrumors newbie

    Joined:
    Oct 13, 2010
    #1
    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
     
    share
    + Quote Reply
  2. robbieduncan, Oct 13, 2010

    robbieduncan Moderator emeritus

    robbieduncan

    Joined:
    Jul 24, 2002
    Location:
    London
    #2
    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).
     
    share
    + Quote Reply
  3. Whalabi, Oct 13, 2010

    Whalabi thread starter macrumors newbie

    Joined:
    Oct 13, 2010
    #3
    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?
     
    share
    + Quote Reply
  4. balamw, Oct 13, 2010

    balamw Moderator

    balamw

    Staff Member

    Joined:
    Aug 16, 2005
    Location:
    New England
    #4
    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
     
    share
    + Quote Reply
  5. Whalabi, Oct 13, 2010

    Whalabi thread starter macrumors newbie

    Joined:
    Oct 13, 2010
    #5
    I hate to say this, but I'm not familiar with Windows at all. What's VBA?
     
    share
    + Quote Reply
  6. robbieduncan, Oct 13, 2010

    robbieduncan Moderator emeritus

    robbieduncan

    Joined:
    Jul 24, 2002
    Location:
    London
    #6
    Visual Basic for Applications.
     
    share
    + Quote Reply
  7. balamw, Oct 13, 2010

    balamw Moderator

    balamw

    Staff Member

    Joined:
    Aug 16, 2005
    Location:
    New England
    #7
    share
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page