On 12/16/05 11:13 PM, "Bill Vlahos" <[EMAIL PROTECTED]> wrote: > I've seen some programs export it directly into Excel without going > through a file on disk. How is that done? I assume on the Mac I could > use AppleScript but how would I do it on Windows?
Your task seems rather uncomplicated as you have described it (below). I can build a quick demo stack to show one technique I use, but it will be Mac only since it uses Applescript. If doing this in Windows, I would build a workbook (or template) with at least one Visual Basic script that would read the tab-delimited text data file and do the fancy work. Most likely, I would also do the fancy work in VBA on the Mac rather than learn all the Applescript equivalents. Rev would 'trigger' the running of the XL script using Applescript and the magic would commence. If the destination workbook required more than one option for which VBA script to run, I would make the first line of the data file a value that would tell the workbook which to execute. I am sure there is a Visual Basic option in Windows to do this, but I have not done this in over 5 years and cannot remember how I did it. The major difference to note is that there is VBA (for applications like Excel) and there is VB that works in Windows between apps. Hope this helps. Jim Ault Las Vegas On 12/16/05 11:13 PM, "Bill Vlahos" <[EMAIL PROTECTED]> wrote: > > On Dec 14, 2005, at 9:02 AM, Jim Ault wrote: > >> Couple of questions: >> 1) is this one table, or several? > One table. I might do several but if I can do one then I can do several. >> 2) is is continuously updated, or a one-time publish? > One-time publish. >> 3) does the format vary each/several times? > Not really. Essentially tab delimited fields. >> 4) does the dimension of the table change? > It might. > > Bill Vlahos > >> >> Jim Ault >> Las Vegas >> >> On 12/13/05 5:20 PM, "Bill Vlahos" <[EMAIL PROTECTED]> wrote: >> >>> I have a table in an appliation which I want to export to Excel. I >>> can fake it out by simply saving it as a text file with the .xls >>> extension and when the user double-clicks it, Excel will open it up. >>> >>> That will fake it out but won't do any fancy Excel things like set up >>> tabbed categories, etc. >>> >>> Is there a better way to do this export? >>> >>> I've seen some programs export it directly into Excel without going >>> through a file on disk. How is that done? I assume on the Mac I could >>> use AppleScript but how would I do it on Windows? >>> >>> Bill Vlahos _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
