Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 9
Newest
 Promoter
Impact
~5k people reached

Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
One more tweak: The macro as is doesn't handle filenames/folders with spaces. This I believe is better: Send, excel{SPACE}/r{SPACE}"%clipboard%"{Enter}
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
This worked for me: "Send, excel{SPACE}/r{SPACE}%clipboard%{Enter}"!!!
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
ExcelFileName := %clipboard% ; plaintext is giving me an error message so far (though I'm quite new to ahk). I'm checking this out now: autohotkey.com/board/topic/…
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
Can you elaborate on "which you could then dump into the AHK script as ExcelFileName"?
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
I'm going to try edit 1 before edit 2, just because I'd rather not lose something I may have copied before opening the excel file.
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
Thanks this is a great start! I really want to be able to open any Excel file as read only, and would need the script to recognize what file I've selected in Windows Explorer (is highlighted blue) and what folder it's in.
Jan
28
comment Is there a way to record macros to do things I would normally do in Windows explorer? E.g. Open an Excel file read-only?
Because that option doesn't work and hasn't been fixed. (Try it out.)
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I have a different spreadsheet where if the user clicks a button and a bunch of conditions exist it will change the drop-down selection to reflect visually that something happened in VBA.
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I just made a new spreadsheet with a combo box, referencing 3 cells for selections options "1","2","3", and tried recording a macro of me changing my selection. And no code was recorded.
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@Raystafarian I googled a bunch and found details about changing the data validation, but didn't see anything about changing my selection.
Dec
19
comment VBA code to change the selection of a drop down list (combo box)?
@CharlieRB edited
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
Very interesting! Though I have other macros in the workbook that I'd like other users to use as well...
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
@RubberDuck But I only want it to beep for me, not for other users who open and save the spreadsheet.
Dec
10
comment Is there a way to include “workbook” event functions in my personal macros file?
@RubberDuck really just make it beep. I want to know when a (sometimes) long calculation is finished. This particular event function doesn't work from my personal workbook.
May
9
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
@Madball73 Yeah, that's what I've been doing. I wish there was an easier way.
May
8
comment Can I make Excel beep when a calculation is finished?
@techie007 I'm using formulas. I'll press F9 after a bunch of work and have to wait.
May
8
comment Can I make Excel beep when a calculation is finished?
@techie007 not VBA. Just functions in large Excel spreadsheets.
May
8
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
Hmm, not really what I was looking for, but thanks.
May
8
comment Can I get Copy and Paste to note transpose, exactly as happens in Cut and Paste?
@Excellll I suppose. But what If I wanted to simulate absolute references for just one quick copy and paste, and then leave them as they were?
Dec
8
comment How to add Hebrew vowels in Word 2010
I didn't see anything there about vowels (nekudot) though. I know they're supported in later versions of word because when I open up old files from previous versions they display fine.