Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    120

    Re: Excel 2016 error

    Your workbook is linked to another file (probably another Excel workbook) and one of the two of them has a problem. The cell range "A187:R187" mightbe referring the other workbook, and that error...
  2. Re: Read external file properties (date created) using VBA

    Ah yes - the spreadsheet-photo-renamer-worksheet. I bet that's a commonly hand-built tool; I once put together something of my own... and it ended up being far more complicated than I expected since...
  3. Replies
    3
    Views
    16,431

    Re: Transparent text in a shapes("TextBox 1")

    <code>
    With ActiveWindow.Selection.ShapeRange(1)
    With .TextFrame2.TextRange.Font.Fill
    .Transparency = 0.5
    End With
    End With

    Full answer at the source.
    </code>
  4. Replies
    3
    Views
    4,042

    Re: Writing to Zip file from VBA

    Old post but nonetheless - as far as I can tell, your linked code uses the same method at the first one you posted, and it just longer and more drawn-out with error handling, etc.
  5. Re: Is it possible to view a VBA project without opening the excel file

    FYI, if you don't want Auto_Open and other event procedures to execute automatically when opening/manipulating an Excel file programmatically, you can wrap the call to the Workbooks.Open method in...
  6. Re: restore a resized worksheet Picture to original size with vba

    Handy piece of code. Thanks!

    B...ut why force the "1" to Double ("#") when a Single ("!") is expected?

    It seems to me that since type conversion isn't necessary (or commonplace) with static...
  7. Replies
    11
    Views
    23,976

    Re: Can VBA Code detect time zone?

    Thanks!

    ...but note that the declared api sub GetSystemTime is unused in the code sample (and therefore extraneous). ;)
  8. Re: How do you set up a scatter plot with 2 variables?

    Unfortunately I think this method is now out of date. No Chart Wizard in Access 2016, and no Scatter Charts.
  9. Replies
    5
    Views
    974

    Re: Textbox text (Shape)

    A decade late but figured I'd pass on my solution as well, for VBA Word Wrap.

    Defaults to width of 115 but you can optionally specify whatever. Split with CR + LF.



    Public Function...
  10. Replies
    6
    Views
    2,780

    Re: Power status - updated VBA

    Updated code and showing all properties (and fixed typo):



    Option Explicit

    Private Declare Function GetSystemPowerStatus Lib "kernel32" (lpSystemPowerStatus As...
  11. Replies
    104
    Views
    219,864

    Re: VBA Macro For Already Open IE Window

    ...works great, and it loads to a very convenient demo page, lol.
  12. Re: If Chip Pearson's website ever helped you, please jot a note...

    Ah so you're the "other mystery caller" who the hosting company wouldn't identify! I was getting worried that someone was going to try for financial benefit by resurrecting the website as a business...
Results 1 to 12 of 13