AutoHotkey Community

Ok, so I did some more testing which resulted in new and even more confusing errors. I will try to be as complete as I can. I tried two different methods of calling the save function. The first was the method I have already posted, this is the complete code I was using during testing (hotkey was random, for testing):



This code was working earlier, though I don't seem to be able to recreate those conditions. Now every time I run it I get this error (Copied directly from the msgbox):


After fighting with that for a while, I took the code you posted to get the pwb, and tried using that.



The first time I run this, it saves the spreadsheet as well creates a new file, named RESUME.XLW, in my documents that appears to be a copy of the current spreadsheet. If this file is not deleted before running the code again, I get the error I posted last time. I don't really understand why.

You said to compare the previous and the current call. I noticed that the line I first posted (when responding to tank) uses pxlb, since I copied it from a block of code on page 1, where the pointer was created from this:



I take this to mean that the save method I am trying to call will only work properly when using the COM_AtlAxCreateControl instance, not either of the methods I was testing with. If thats the case, is there a way to call the save method using a pointer collected from either of the methods I used above?

I know this post is long, but I wanted give you what I had done. I know I am asking what probably seem like basic questions from someone who just wants a quick solution, but I really am trying to learn this, and I am grateful to all the help I've gotten on these forums (especially from the work you and tank have done).

Why aren't you using your created pointer?

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

I'm always puzzled how/why users are missing the obvious resources to learn from. As you seem to use Office 2007, the definite place you have to visit is 2007 Microsoft Office System.

in fairness Sean you must admit it is only recently that the MSDN has been so much more friendly. I remember a time (not but a few years ago) that much of it was like jibberish to all but the more skilled developer.

the very latest version of the msdn tho is very user friednly

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

I thought I had tried that earlier with the same result, but going back it seems to be working now.Thats the pointer that the example I was borrowing from uses, too, I don't know how I skipped it. I certainly feel foolish for spending so much time with the answer right in front of me. I guess that makes sense though, the workbook being the one with the save method and not the application. Its the workbook thats being saved.

@Sean, thank you for the link, I will definitely be spending time there this week.

Welcome to most of our lives when we started using COM.

By the way, there's also a CHM reference for Excel 2003 that you could download and read in addition to the website Sean referenced above. The core of what is required to access Excel hasn't changed much between the two versions so it won't hurt.

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

In the Excel.ahk code posted on the front page, the author has Excel_SetText accept Column references as letters. I was trying to use it in a loop, and instead of trying to get the next letter, I found it easier to modify the function to just accepts numbers for the column reference (in addition to letters).

Sean, thank you so much for that link. I have been using it quite a lot, and I've learned how to translate from at least a dozen methods into COM for ahk.

That is one of the single largest time savers ever.


For the curious, this was the hardest to translate, as the MSDN lists the method as "RefreshTable" which does not work. I took this command from Excel's macro recorder, which did work.

RefreshTable is a function of the interface PivotTable, not that of PivotCache which you're using.

BTW, AutoHotkey_COM has a built-in function to show the type of the object:

so this post means i don't need to learn MS VBA for excel?

if anything you need more to learn it since it will carry over and Sean or any one else for that matter isnt likely to document an objects methods properties and child objects

_________________
No matter what your oppinion Please join this discussion
Formal request to Polyethene

Here's a function for the Excel collection, it will save and close an Excel document. You can optionally specify the title of the document, if no title is specified the "active" instance will be saved/closed.

AHK:



AHK_L:

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

i think it should be more functions for excel as operations on chart. after all i can use formula of excel to get/calculate data.

If you have such functions you are more than welcome to contribute them. The people who have been and are contributing to this thread are doing so because the functions here are the ones they find the most use for. I rarely have a need to create charts so writing functions for something I would barely use doesn't make much sense.

_________________

Try Quick Search for Autohotkey or see the tutorial for newbies.

Dare I say ( especially with AHKL & COM_L ) that it's almost as easy to learn some basic VBScript/COM & use the Excel Object Model as it is to learn how to use a bunch of user created functions?

_________________

Recommended: AutoHotkey_L
Basic Webpage Controls