Search Results - VBForums

Search:

Type: Posts; User: dmaruca

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    12
    Views
    24,489

    Re: [VBA] Run Application - Capture Output

    I'll try to get to a 64 bit version sometime soon. you have to do more than pointer safe. every pointer has to be a longptr
  2. Replies
    12
    Views
    24,489

    Re: [VBA] Run Application - Capture Output

    Hi guys. Sorry, I did not see the message from November. I just tested in my copy of 2013 and it works fine. What version specifically are you using and what command are you trying to run that gives...
  3. Re: VBA - instantiate multiple ojects using variable name

    OP, it sounds like you want to make a "dictionary" of employee objects. The idea is not to name each variable after employees. The idea is to create an employee object that can be located based on...
  4. Replies
    3
    Views
    664

    Re: VBA Error help for MS Access

    Hi pancakes. In my experience when you start getting compile errors on things that you know are not errors, there is either a missing reference (Tools->References) or file corruption.
  5. MsOf07 Re: IE navigate was loaded, but data is not ready. How to make detect readiness?

    ssal, the two properties you check offered by the IE object are Busy and ReadyState. These properties don't give a complete picture of how the page is loading with sites that use scripts to...
  6. MsOf10 Re: [ACCESS] IsNull() function in Access

    Hi techgnome. I wasn't advocating the use of =Null :) Have a great night.
  7. MsOf10 Re: [ACCESS] IsNull() function in Access

    In your example it could also be false. IS NULL is there so you don't use "[Column]=Null". (I'm not trying to quibble)
    ...
  8. MsOf10 Re: [ACCESS] IsNull() function in Access

    Use the IS NULL keywords... IIF([Column] IS NULL, 'It was null', [Column])
  9. Replies
    6
    Views
    493

    MsOf10 Re: [TIME-CRITICAL] TCP/IP over VBA

    You can use the example in my signature to read back in success/failure if you go the exe DOS route. I would definitely either use exe or dll instead of ocx since that would mean you would need...
  10. Re: [Outlook] Warning message before sending email to external address.

    I agree seeking a commercial product for this. Titus labs also makes one. I would not put my professional reputation on the line for something like this. This goes beyond the scope of VBA. Who will...
  11. Replies
    12
    Views
    24,489

    Re: [VBA] Run Application - Capture Output

    Hi there. There is no license associated with this code. Do whatever you wish with it.

    I've primarily used this class to do pdf to text conversions and 7zip over the years. I've used it for other...
  12. Replies
    12
    Views
    792

    Re: Print tray problems

    Quick glance you are using Select Case Left(ActivePrinter, 11) but the printer names are longer than 11 characters.
  13. Re: MS Word 2010: Increment date in header of microsoft word

    Hi,

    I don't have much to work on, but my first guess would be the header enum could be the wrong one for the type of sections on your document. Try changing wdHeaderFooterPrimary to one of the...
  14. Re: Vba macro code for grouping the data based on 2 hours time...

    You can use a formula to create groupings. I can't open your attachment here at work, but this will work as long as your date data is an actual date (a formatted serial number).

    A formula for...
  15. MsOf07 Re: [Access 2007] VBA procedure for parsing XML database connection

    Hi Smartacus,

    I'm sorry that I don't have time to write a detailed response, but I would recommend using MSXML to parse XML instead of re-rolling your own method. See here for more info:
    ...
  16. Replies
    3
    Views
    389

    MsOf13 Re: PowerPoint Close Automation

    Powerpoint doesn't have autorun VBA. You would need to develop an addin or external application to monitor and close on idle.
  17. Replies
    17
    Views
    1,236

    Re: Using MSHTML Offline

    I see nothing you are doing wrong. I've used this same innerhtml method for years. My only thought since you are getting an object error is that internet explorer is erroring out. Try it on a...
  18. Thread: Test code post

    by dmaruca
    Replies
    2
    Views
    695

    Test code post

    testing a larger block



    End Function
  19. Replies
    3
    Views
    1,690

    Re: Sort Alphanumeric - Excel (VBA)

    The others are correct. Text will be sorted as text. You can keep your sorting column to a single column if you format it as "A0000001" and play with padding zeroes based on data.
  20. Replies
    10
    Views
    2,553

    Re: Using Flexigrid with Excel

    One more thing. I said I would use a browser with a javascript library if I had to, but that also comes with support load. Javascript could be disabled for local sources depending on security level....
  21. Replies
    10
    Views
    2,553

    Re: Using Flexigrid with Excel

    It would run reliably until something changed. A new install or upgrade. Or moving between machines. Then there is a risk of it breaking.

    There was someone where I work made an automatic pdf...
  22. Replies
    10
    Views
    2,553

    Re: Using Flexigrid with Excel

    Keep in mind these activex controls will stop functioning in the future. If this is is something like a production macro I would recommend against using it. So many things can go wrong. Flexgrid is...
  23. Replies
    9
    Views
    1,404

    MsOf07 Re: stuck in Word automation hell

    I do not think this has anything to do with early/late binding. I think it is just an office installation issue. I've run into similar problems before where I work and a repair install usually does...
  24. Re: Find & Replace text in Word document footers across multiple documents

    I haven't coded in Word for almost 4 years now. Here's an example of how to modify that to do what you ask. Westconn suggested using arrays, but I get the impression recommending arrays would be too...
  25. Replies
    12
    Views
    1,555

    Re: General Excel VBA or function differences

    GBeats:

    This is actually an interesting topic and one that comes up at work. westconn1 gives a method using end(xlup), but I generally find that method to be unreliable by itself. The reason...
  26. Replies
    9
    Views
    1,551

    Re: error 9 - subscript out of range problem

    Try Select Case Worksheets(idx).Range(FGRNames_Report.Address).Value instead. FGRNames_Report is a range object and the default property of a range is the value, not the address of the range. This...
  27. Replies
    12
    Views
    24,489

    Re: [VBA] Run Application - Capture Output

    I updated this to work with xcopy. It was failing before because xcopy requires stdin to run. I've also renamed it to CRunApp but works the same as the previous.

    Note: Since this opens up stdin,...
  28. Replies
    4
    Views
    1,460

    Re: Turn off KeyTips in Office 07

    Ok, I tried it and got what you were talking about. It's just bad technique! If I try at a fast speed with good form, I get the dialogue. If I try to go so fast that it's just a big key mash then it...
  29. Replies
    4
    Views
    1,460

    Re: Turn off KeyTips in Office 07

    I can't reproduce that problem no matter how fast I hit ALT-E-S. I am certain your coworkers can adapt. I've never heard of being able to switch that off.
  30. MsOf07 Re: [Word] How to close "Search item not found" dialog

    You don't need to program in a sendkeys hack. It's basically prompting because you told it to. Change this line to be either wdFindContinue or wdFindStop depending on whether you want to search the...
  31. Replies
    7
    Views
    524

    Re: Decimal to Binary

    Sheet1.Cells(13 + i, 4).Numberformat = "@"
  32. Replies
    8
    Views
    1,614

    Re: Parsing Word doc and export to Excel

    You should check to see if the style is H2 first before you loop through your collection. You could save the oPara.Range.Text to a string before looping through the collection so it doesn't have to...
  33. Replies
    7
    Views
    524

    Re: Decimal to Binary

    There is nothing wrong with your code that I can see. You need to format your cells to text or excel will remove the leading zeroes.
  34. Re: Do i need licences if my VB application use excel and access docs?

    If you're going to use .net maybe you could look into doing openxml development... Automating Excel outside of VBA isn't as pleasant of an experience.
    ...
  35. MsOf07 Re: Access 2007 VBA - Looking For A Better Way

    Ecniv, your code is less readable than the OP.
  36. Replies
    11
    Views
    3,230

    Re: IE Download File Prompt

    Hey Tony, is the javascript in the forms the only thing that is keeping you from using a different method? Is the javascript so complex that what it does would be real cumbersome to replicate? The...
  37. MsOf07 Re: Access 2007 VBA - Looking For A Better Way

    If you're looking for style suggestions, I'd say that everything looks fine. It's not sloppy at all!

    The only things I'd point out is that you should probably get into the habit of not assigning...
  38. MsOf10 Re: Password recovery - use someone forgot their password.

    True, westconn1.

    Workbook passwords (to open) encrypt the file contents. I'm sure you could code the macro to brute force the encryption, but you would have to replicate the same things those...
  39. Replies
    2
    Views
    374

    Re: [Outlook] security prompts

    It's not really a case of privileges from my understanding. It's that you are now trying to use Outlook through the API, and Microsoft has nerfed that functionality. Once you try to do something...
  40. Replies
    10
    Views
    614

    Re: [Excel] Output issues

    I hope I never end up in one of your classes.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width