Re: Comparing two excel sheets,the never ending quest

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Well ke...@xxxxxxxxxxxxxxxxx

Everything has a price doesn't it.

For starters - tell me if you know enough to install the AppleScript
Perl module into your local version of Perl.

This lets you read and write to Excel and match and manipulate data in
Perl.

If you get this far...

Email me a representative sample of the workbooks and tell me how much
you'd pay for a solution by Monday.

As to why engineers of Excel haven't made this possible? Well, there's
the budget issue of creating a new VBA compiler, theres the fact that
most Mac Excel users aren't power Excel users, there's the fact that
you can run Excel for Windows using Parallels on a Mac, and there's
the fact that Microsoft has other higher priority projects, and
there's the fact that real power users can figure out how to get the
job done using AppleScript.

.



Relevant Pages

  • Re: Applescript in Excel 2004
    ... your "Customer Contacts" file will show an extension if it has one. ... Unlike the Test Drive for Office v. X, which did have both AppleScript and ... > Subject: Re: Applescript in Excel 2004> ... >>> CopyObject Sheet "Customer Contacts" ...
    (microsoft.public.mac.office.excel)
  • Re: Excel 2004 Applescript help
    ... > applescript sytax for this Office vs. the earlier versions, ... > Has anyone had a decent amount of experience, and success, with Excel ... What you can do is quite your Script Editor, quit Excel 2004, ... if you use Apple's Script Editor you even need to log out and in. ...
    (microsoft.public.mac.office.excel)
  • Re: Extract Data from Excel-files
    ... > Finally I get to use perl at work! ... > I am to facing the following problem: ... Each of these subfolders contains a number of Excel-files ... > I am unsure what versions of Excel were used creating these files, ...
    (perl.beginners)
  • Re: auto dial
    ... > done in Perl. ... Do you actually mean an Excel spreadsheet .xls file, ... It looks like Modem::Vgetty may be able to interact with a voice modem, ... good documentation and we can answer concrete questions, ...
    (perl.beginners)
  • Re: Applescript
    ... talking about Applescript... ... I am trying to convert a user defined VBA function from Excel 2007 ... I can do the titles but not the numbers on the axis. ... tell active chart ...
    (microsoft.public.mac.office.excel)