Search Results - VBForums

Search:

Type: Posts; User: dmaruca

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. 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:
    ...
  2. Replies
    3
    Views
    199

    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.
  3. Replies
    17
    Views
    433

    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...
  4. Thread: Test code post

    by dmaruca
    Replies
    2
    Views
    429

    Test code post

    testing a larger block



    End Function
  5. Replies
    3
    Views
    770

    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.
  6. Replies
    10
    Views
    922

    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....
  7. Replies
    10
    Views
    922

    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...
  8. Replies
    10
    Views
    922

    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...
  9. Replies
    9
    Views
    528

    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...
  10. 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...
  11. Replies
    12
    Views
    851

    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...
  12. Replies
    9
    Views
    1,127

    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...
  13. Replies
    3
    Views
    12,426

    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,...
  14. Replies
    4
    Views
    1,004

    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...
  15. Replies
    4
    Views
    1,004

    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.
  16. 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...
  17. Replies
    7
    Views
    405

    Re: Decimal to Binary

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

    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...
  19. Replies
    7
    Views
    405

    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.
  20. 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.
    ...
  21. MsOf07 Re: Access 2007 VBA - Looking For A Better Way

    Ecniv, your code is less readable than the OP.
  22. Replies
    11
    Views
    1,968

    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...
  23. 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...
  24. 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...
  25. Replies
    2
    Views
    287

    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...
  26. Replies
    10
    Views
    442

    Re: [Excel] Output issues

    I hope I never end up in one of your classes.
  27. Replies
    10
    Views
    442

    Re: [Excel] Output issues

    Select Case t And mph

    Juicy, I think this is your sticking point right now. You're trying to code in English, but that's not how the computer thinks. "AND" is an operator to the computer. Read...
  28. Replies
    10
    Views
    442

    Re: [Excel] Output issues

    I would love to hear some tips from you, incidentals. I have recently started giving a class to workmates and I find it hard to go back and see things from their perspective. I started off by...
  29. MsOf07 Re: [WORD2007] Is this possible and if so how?

    Hey don't be too hard on the guy. I used to have pages in large documents like this when I worked for insurance companies. Pages in these documents become their own entities and repagination would...
  30. Re: [VBA Excel] PivotTable SourceData - Union of Ranges

    A union is a range in the form of $B$1:$C$2,$D$1:$E$2. This is not a valid range for a pivot table. You can't even do that if the ranges touch and are the same size.

    You are correct that filtering...
  31. Replies
    10
    Views
    442

    Re: [Excel] Output issues

    Use a select case if you want it to follow english more...


    Select case wc
    Case 40 to 50
    'code
    End Select
  32. Replies
    10
    Views
    442

    Re: [Excel] Output issues

    If 50 > wc > 40 Then

    I don't think this line does what you think it does. Remember operator precedence and execution order. In this case I think 50 > wc would evaluate to true or false and then do...
  33. Re: *** Help with Refreshing Data between VBA and SQL via ADO! ***

    This is going to be nearly impossible to troubleshoot through the forums. All I can say is double check your table names and connection string.
  34. Replies
    3
    Views
    496

    Re: Data logger @ boot up

    As far as I know you can't run it in the background using a command-line switch. You could write an external app to call excel using its com interface. You could even use vbscript to do this if it is...
  35. Replies
    2
    Views
    358

    Re: Compilation of office COM Add-in solution

    As long as the 32/64 bit versions of the COM addin and office are the same, they should work together. Also ensure the COM addin is registered on the system through either self-registration or...
  36. Replies
    2
    Views
    292

    MsOf07 Re: Data display help

    access creates the tabledefs locally and they are cached in the database. refresh the tables in your linked table manager (database tools tab) and the update should propagate.
  37. Re: Dim and Copy and Paste issue in VBA

    You have to assign something to the worksheets you dim.


    Sub StatSig()
    Dim FirstSht As Worksheet
    Set FirstSht = Worksheets("NAMEHERE")
    ActiveSheet.Name = FirstSht
    Dim StatSigSht As Worksheet...
  38. Re: Shell and wait File not found error WHY???

    You could try the library in my signature.
  39. Replies
    7
    Views
    1,207

    Re: Fed up with Dlookup's

    Check out some examples here.

    http://msdn.microsoft.com/en-us/library/ee336041%28v=office.12%29.aspx

    This is how to iterate rows in the most basic fashion. They are editing fields here, but the...
  40. Replies
    7
    Views
    1,207

    Re: Fed up with Dlookup's

    You certainly can't speed up the round trip time of the network backend, but you certainly can cut down on the number of trips is has to make. That is a lot of DLookups. I would seriously consider...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.