AutoHotkey Community

vallorian wrote:I'm tryding to do "random variable" like in example, but in result i need variable which i can use inside "text", like this:

1|RandCity|RandCity := |1|0|Function|||||
2|[Text]|Random city is %RandCity%... Next text...|1|0|SendRaw|||||

vallorian wrote:So is it possible to use function inside [Text] ?

1|[Text]|% "Random city is " RandCity() "... Next text..."|1|0|SendRaw|||||

pulover wrote:

vallorian wrote:So is it possible to use function inside [Text] ?

To use a function directly inside a command, you need to make the whole parameter an expression, like this:

Code: Select all

1|[Text]|% "Random city is " RandCity() "... Next text..."|1|0|SendRaw|||||

click-click wrote:I don't see a difference in icon size when choosing between small/large icons. Go to View -> Icons size -> neither large or small shows a check-mark and the size doesn't change after resetting layout and restarting .

click-click wrote:I actually liked the old toolbar icon-set better than the flat styled ones used now.

click-click wrote:Also, would it be possible to have an option to increase the font size for the app?

click-click wrote:I'm not sure if Macrocreator is DPI-aware or not.

click-click wrote:One more thing comes to mind. Is it possible to hide the start/stop/loop entries next to the toolbar(s) and the very bottom section (repeat, delay, etc.)? I've never used any of those functions and I did not find an option for hiding them..

vallorian wrote:Ok, How about multiple Functions/variables in one raw?
Is it possible?

1|[Text]|% "Random city is " RandCity() "... Today is " A_DD " of " A_MMMM "`, and another random city is " RandCity() "."|1|0|SendRaw|||||

vallorian wrote:ok, i will also send you few things i noticed in this new version.
And also i started correcting Polish translation in Lang File, so i will send you when I finished or E.g half-finished

vallorian wrote:PS: this version, crashes alot, is there any error Log?

roedtraad wrote:So I need to get som coordinates from MouseGetpos, as variables, and insert them later, right?

Guest wrote:Hi,

I started using MacroCreator and it is great tool. I have a question, given that I am still new to automation process at all, how I can connect specific Excel file, that contain data, to macro? I am working on project to connect, via macro, website PDFMERGE.COM to merge pdf files and in this excel file will be paths of files that I want to send to particular locations on the website. There will be unknown number of data like: in column A will be paths of files that contains the first page, in column B paths of files for the second page, column C for the third page and so on. How to make to go cell by cell? I suppose I have to use VBA code with prefix XL. according to tutorials you posted. If I am wrong, please tell me what to do. I will appreciate your help. Thanks in advance.

MARE19722 wrote:how I can connect specific Excel file, that contain data, to macro?

MARE19722 wrote:How to make to go cell by cell? I suppose I have to use VBA code with prefix XL. according to tutorials you posted. If I am wrong, please tell me what to do.

XL.ActiveCell.Offset(1, 0).Select ; moves the selection 1 cell down
XL.ActiveCell.Offset(0, 3).Select ; moves the selection 3 cells to the right
XL.ActiveCell.Offset(-2, -1).Select ; moves the selection 2 cells up and one cell to the left

Pulover wrote:Hi,

MARE19722 wrote:how I can connect specific Excel file, that contain data, to macro?

You can use the "Connect" button or a function, like ComObjActive() to connect to the most recent active excel instance, or ComObjGet(FilePath) to connect to a file.

MARE19722 wrote:How to make to go cell by cell? I suppose I have to use VBA code with prefix XL. according to tutorials you posted. If I am wrong, please tell me what to do.

You can use ActiveCell.Offset(y, x).Select to move the selection.

Code: Select all

XL.ActiveCell.Offset(1, 0).Select ; moves the selection 1 cell down
XL.ActiveCell.Offset(0, 3).Select ; moves the selection 3 cells to the right
XL.ActiveCell.Offset(-2, -1).Select ; moves the selection 2 cells up and one cell to the left

The Expressions window should be able to reproduce any COM expression example you can find on the forum. You can start here: https://autohotkey.com/boards/viewtopic.php?p=495#p495
If you have doubts about how to do something using COM, you should post on the Ask For Help forum as this is not about PMC specifically.

MARE19722 wrote:Hi,

Thank you for this tips. Could you please tell me, if I understood correctly, when I put function ComObjGet(FIlePath) In Expression/COM Interface, in the Expression window, it is connected? And afterward I have to write additional code, also in Expression window? Thanks in advance.

[PMC Code v5.0.1]|F1||1|Window,2,Fast,0,1,Input,-1,-1,1|1|Macro1
Groups=Start:1
1|ComObjGet|XL := "C:\SpreadSheet.xlsx"|1|0|Function|||||

Adorabla wrote:1. Maybe mentioned early'er -> Missing Drop-Down Menu

Adorabla wrote:2.

Adorabla wrote:3. Pressing the Button leads to a sudden Interface crash of PMC while a Macro line is marked and Continue Playback in PMC is selected.

Adorabla wrote:Editing Macro's was easy and fast without Hangups or Crash's