Search:

Type: Posts; User: Volos

Search: Search took 0.02 seconds.

  1. MsOf10 Re: Putting mutliple scroll bars in the middle of the sheet.

    I've thought of trying to use the Index function, but I would want the end user to be able and edit the information as they scroll (and an index would be written over in this case).
  2. MsOf10 Putting mutliple scroll bars in the middle of the sheet.

    I'm working on a COM add in, but I would be happy to have this solved in VB or VBA. I have user reports that are generated based off selections from a database, then the sheet is added into an...
  3. Re: Excel Add-In: Showing UserControl, VS2012

    Ah of course. I knew it was something stupidly simple. Thanks.
  4. [RESOLVED] Excel Add-In: Showing UserControl, VS2012

    So I'm working on learning VB.Net and VBA as additional languages. I must clearly be missing something simple from the MS example, because I can't seem to get my user control to pop up:



    ...
  5. MsOf07 Re: [RESOLVED] Failing Opening Access DB run-time error- '2147467259(80004005)'

    Sorry I need to dig more, before I ask. I really don't know what caused these errors, but I'm on to other methods which seem better do the same thing. Example:


    Dim cn As ADODB.Connection,...
  6. MsOf07 Re: Failing Opening Access DB run-time error- '2147467259(80004005)'

    Ok so clearly I'm way off base on perhaps even the correct way to do what I want. Watching an Excel written macro has led me to:


    Dim DBPath As String
    DBPath = "E:\LacProj\Dummies and...
  7. MsOf07 [RESOLVED] Failing Opening Access DB run-time error- '2147467259(80004005)'

    Hello again,

    So now that I've finished my previous project, and migrated everything successfully to an Excel Spreadsheet, I have been "allowed" time to try and get it working with an Access/Excel...
  8. MsOf10 Re: .SendUsingAccount from Excel, fails with runtime error "-2147024809"

    My bad on that.

    I actually had it on set first--I pulled that when I tried to debug (and was copying the code in the middle of the night). But it didn't throw the error, instead pulled the...
  9. MsOf10 Re: .SendUsingAccount from Excel, fails with runtime error "-2147024809"

    While I still feel the name solutions should have worked, I was able to pull it from looping through all the smtp addresses each time....
  10. MsOf10 .SendUsingAccount from Excel, fails with runtime error "-2147024809"

    So I am yet another person failing with .SendUsingAccount! I look at plenty of purportedly correct uses, yet I'm coming up with RT error "-2147024809" every time.

    so my first shot:


    Sub...
  11. Replies
    1
    Views
    843

    MsOf07 Office Security Check Prompts at Each Email

    I am trying to send out several emails sent from an Excel file. Everything seems to be working but Outlook prompts for a security exception with every single email. RangetoHTML is not my solution,...
  12. Replies
    0
    Views
    4,046

    MsOf10 Sending multiple .HTML tables in .HTMLBody

    I'm trying to send a form email with recipient dependent variables reported in a few HTML tables. I would like the email to be formatted nicely, but I've been having a hard time doing anything but...
  13. Re: Filing emails in a specific folder on C drive using VBA (Outlook 2010)

    I don't at the moment have time to throw any code up for you, but I would use .FindNext (http://msdn.microsoft.com/en-us/library/office/bb219895%28v=office.12%29.aspx) and .SaveAs...
  14. MsOf10 Re: Plan of Attack for VBA Multiple Forms to Multiple Emails, wedged into worse pract

    Ok so I'm moving along in hacking this together in VBA, and I have actually imported the whole DB into one Excel file (turned out to have 12 tables, all of which I put on a separate sheet). I've...
  15. MsOf10 Re: Plan of Attack for VBA Multiple Forms to Multiple Emails, wedged into worse pract

    Access might be a viable option, but at the moment I'm thinking an entirely VB front end that prompts for the daily values and pulls from csv files for client data. Is there any reason that I would...
  16. MsOf10 Re: Plan of Attack for VBA Multiple Forms to Multiple Emails, wedged into worse pract

    Good to know others have the same initial thoughts I did. There are some unfortunate problems. First the poor old server the DB is on is slated to be junked, and a copy of the DB is to be thrown on...
  17. MsOf10 Plan of Attack for VBA Multiple Forms to Multiple Emails, wedged into worse practices

    Hi everyone, I thought I would give this forum a second go. Even if I answer my own questions again, hopefully it might help someone else. I work mostly in computer vision, and thus my language...
  18. Replies
    4
    Views
    1,291

    MsOf10 Re: Trying to do a Wierd Table Pivot

    Ok so the key-command problem cleared up when I saved the file, closed it, went to lunch, and re-opened it.
  19. Replies
    4
    Views
    1,291

    MsOf10 Re: Trying to do a Wierd Table Pivot

    OK so I solved my own problem partially:



    Sub Shorter96()
    Application.ScreenUpdating = False
    Dim platenumber As Integer
    platenumber = Application.WorksheetFunction.CountIf(Range("A:A"),...
  20. Replies
    4
    Views
    1,291

    MsOf10 Re: Trying to do a Wierd Table Pivot

    I suppose I shouldn't keep replying to my own thread, but I see that using .Select is slow. I'm trying to work out a solution with .Offset now, but so far I've failed.
  21. Replies
    4
    Views
    1,291

    MsOf10 Re: Trying to do a Wierd Table Pivot

    Sorry I didn't wrap the code! As soon as I posted it I try to find it to edit it, but I think I lost it to being approved. Here is the wrapped code:


    Dim platenumber As Integer
    platenumber =...
  22. Replies
    4
    Views
    1,291

    MsOf10 [RESOLVED] Trying to do a Wierd Table Pivot

    Hi everyone, first post. I have a fair amount of experience in other computer languages, some in .Net, and I'm just starting out in VBA as part of a new project.

    For lack of a better description,...
Results 1 to 22 of 22



Click Here to Expand Forum to Full Width