Search:

Type: Posts; User: GTO; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.24 seconds.

  1. Replies
    7
    Views
    338

    Re: Is this possible for vba read only

    Not sure when I'll log back on, so here is a try:


    Option Explicit

    Sub exampleOpenReadOnlyAndCopyWB()
    '// I simply created a subfolder where ThisWorkbook resides. Change to suit."
    Const...
  2. Replies
    7
    Views
    338

    Re: Is this possible for vba read only

    Yes. Please test the code, substituting a valid path and workbook name. I am not on an actual network but switched users and am confident it should run fine. Meanwhile, I'll try and type a basic...
  3. Replies
    7
    Views
    338

    Re: Is this possible for vba read only

    Thank you. Unfortunately I am limited to Excel2003 on another PC than this one, so could you detail what it is we want to copy before I try to write some example code?

    If you have the code to do...
  4. Replies
    7
    Views
    338

    Re: Is this possible for vba read only

    Hi there,

    What do you mean by "...input some data..." ?

    If the workbook is opened by another (unless it's a shared workbook) you cannot update it and save changes. That is writing and not...
  5. Replies
    17
    Views
    479

    Re: Overflow Error Puzzle

    You are most welcome and glad I didn't booger that up too awful! It's a lot to think about, least for me.
  6. Replies
    17
    Views
    479

    Re: Overflow Error Puzzle

    :biggrin: Glad we were able to help.
  7. Replies
    17
    Views
    479

    Re: Overflow Error Puzzle

    Greetings Jack,

    The short answer is yes.

    Most of the articles or threads I've read seem not overly clear to me, on a subject that is a stretch for my knowledge level (What's really going on...
  8. Replies
    17
    Views
    479

    Re: Overflow Error Puzzle

    I agree with Rick. Unless specifically needed (E.G. for an API), I would use Longs. To tack onto what Rory hinted about as to execution speed, Longs process quicker than Integers. Here's a cheapie...
  9. Replies
    8
    Views
    576

    Re: Run VBA when cell equals a value

    ken1921:

    In the worksheet's module, try:

    Option Explicit

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Count + Target.Column + Target.Row = 3 And...
  10. Replies
    26
    Views
    1,040

    Re: open last active workbook

    If I have one or more other workbooks open, the window to the one with focus becomes active after opening the 'utility' wb. I have tested opening the utility wb thru Excel and thru Win Explorer. I...
  11. Replies
    26
    Views
    1,040

    Re: open last active workbook

    At least in my testing, yes.
  12. Replies
    26
    Views
    1,040

    Re: open last active workbook

    You are most welcome and no worries, it didn't occur to me until trying a couple other ways... on top of which I tried activatePrevious a good half-dozen times before re-reading the help...
  13. Replies
    26
    Views
    1,040

    Re: open last active workbook

    Greetings All,

    I may be misreading the goal, but if it is simply to activate the last active workbook (prior to the 'utility' wb being opened), then would this work?

    In ThisWorkbook module of...
  14. Replies
    5
    Views
    304

    Re: Use MsgBox to name selected file.

    Presuming you only have one or two workbooks (in addition to the 'Master' workbook) open, a MsgBox would seem reasonable; maybe something like:

    In a Standard Module:


    Option Explicit

    Sub...
  15. Re: Application.OnTime.... Calculate every 200 milliseconds. Is there a way?

    I am unfamiliar wit RTD or at least am not thinking of what it is an acronym for. Logging out, and may be missing something, but why not store the return in a variable instead of the cell?

    Have a...
  16. Re: Application.OnTime.... Calculate every 200 milliseconds. Is there a way?

    Hi Martin,

    Could you describe what it is you are trying to do?

    Mark
  17. Replies
    5
    Views
    523

    Re: run macro on non active sheet

    Greetings,

    Something like:


    Option Explicit

    Sub HideOut()
    Dim BeginRow As Long
    Dim EndRow As Long
  18. Re: VBA Transpose and separate comma separated values

    <b>Sheet1</b><table class="html-maker-worksheet" border="1" cellspacing="0" cellpadding="0"><thead><tr><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr...
  19. Re: VBA - determine if a formula refers to a text-only cell

    Greetings,

    At least for me, presuming you keep the cells' alignment as General, the cells do align as described dependent upon the return of the formula (that is, if the formula returns text, then...
  20. Replies
    10
    Views
    2,107

    Re: Excel VBA bubble sort 2 key sorts

    I would suggest showing the code you are using to sort a single list of values.

    Is this for school? Does it have to be a bubble sort specifically, or just a sorting method?
  21. Re: Open .xlsx File from VBA, the name containing Date & Time which changes.

    Hi Muhammad,

    I am still not sure I understand, but if we are looking to find a filename based upon the current time (or nearly the current time), maybe something like:

    In a Standard Module:

    ...
  22. Re: Open .xlsx File from VBA, the name containing Date & Time which changes.

    Could you please explain that part of your question?

    Thank you,

    Mark
  23. Replies
    5
    Views
    252

    Re: Open workbook debug

    I agree with Jack. Just to add... Rid the parenthesis around source_file unless assigning (in this case, by Set). Also, your code as shown should fail due to the ReadOnly. Maybe something like:
    ...
  24. Re: Use macro button to unhide veryhidden sheets and password protect it

    Thank you. Sorry, I should have asked you to post the code you have that is unhiding stuff. Please use code tags for posting code, like:
    '...your code between the tags

    Have you used/created...
  25. Re: Use macro button to unhide veryhidden sheets and password protect it

    Yes.

    Do you need the password obfuscated while being typed?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4