Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
2 10
Newest
 Curious
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 61 votes cast
Aug
17
answered Who was the last modifier of a file on a mapped network drive?
Aug
14
comment How to change Control-Y behavior in Excel-VBA's IDE
Related: stackoverflow.com/questions/7497347/…
Jul
20
comment Insert Hyperlink in word to an excel file that will open read-only when clicked?
@BenSampica I am familiar with VBA though only really with Excel.Not sure how to implement something like this is Word.
Jul
17
asked Insert Hyperlink in word to an excel file that will open read-only when clicked?
Jun
9
awarded  Curious
Apr
20
comment Excel - keyboard shortcut to double click on format painter
@CharlieRB Recording a macro didn't help. I think the macro recorder copies writes code to apply the formatting once you do so, while clicking on format painter in anticipation of applying formatting doesn't register any written VBA code.
Apr
17
asked Excel - keyboard shortcut to double click on format painter
Feb
24
awarded  Promoter
Feb
18
asked How to change Control-Y behavior in Excel-VBA's IDE
Feb
18
revised Is there a “Shift” version of Scroll Lock?
added 54 characters in body
Feb
18
asked Is there a “Shift” version of Scroll Lock?
Feb
9
awarded  Notable Question
Jan
30
accepted Typing to navigate to file in Windows Explorer when characters repeat
Jan
29
asked Typing to navigate to file in Windows Explorer when characters repeat
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.