203 reputation
18
bio website
location
age 32
visits member for 3 years, 2 months
seen 6 hours ago

6h
accepted Typing to navigate to file in Windows Explorer when characters repeat
1d
asked Typing to navigate to file in Windows Explorer when characters repeat
2d
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}
2d
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}"!!!
2d
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/…
2d
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"?
2d
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.
2d
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.
2d
revised 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?
edited tags
2d
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.)
2d
asked 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?
Jan
1
asked Zoom in on Excel 2010 print preview
Dec
19
awarded  Yearling
Dec
19
awarded  Teacher
Dec
19
answered VBA code to change the selection of a drop down list (combo box)?
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
awarded  Editor
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