How do I substitute any part of Macro code with content from a cell in Excel (e.g. a password that the user writes in Cell A5).
How do I substitute any part of Macro code with content from a cell in Excel (e.g. a password that the user writes in Cell A5).
Please Login or Register to view this content.
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
not what I meant, I want to used the content of some cell as replacement for some content in a Macro
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
use a password from some cell that the macro clears automatically (know how to), so the password is not in the macro itself, but you have to enter it every time. Its
SendKeys ("PASSWORD") for example
PASSWORD should be content from cell A5
Hard to be more specific than this with your brief requirement, but of course you can use cell content in code:
Surely it would be nicer to use an inputbox, or better still a userform, to capture manual input of a password, though?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks