Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Calling Excel sub with parameters (VB6 and Excel)

    Yes, obviously it is a special kind! Unfortunately, our present usage is calling it from another spreadsheet, and from another spreadsheet you CAN find RunWorkbook in ThisWorkbook. And because of a...
  2. Re: Calling Excel sub with parameters (VB6 and Excel)

    Sorry for late response; didn't get usual email about your reply.

    You're right in what you say, and it was something I'd tried, with no success. However, I have now discovered that the reason...
  3. Re: Calling Excel sub with parameters (VB6 and Excel)

    Thanks, Hans - got your email that time! Yes, you're right, I think now. In the short time between posting the reply and getting your new reply, I tried putting the RunWorkbook routine in a Module...
  4. Re: Calling Excel sub with parameters (VB6 and Excel)

    Sorry for tardy response, but I didn't get the usual email for some reason and only found your answer when I looked back at the site.

    Sorry, Hans, but I think I confused you a bit - though the...
  5. Calling Excel sub with parameters (VB6 and Excel)

    In a VB6 application I'm developing, I need to open a number of Excel spreadsheets and kick off the VBA within them. As they also stand alone, they do this by opening a Login form to gather userid...
  6. Re: Crystal Reports parameter with formula field (Crystal Reports)

    Thanks for that Hans. However, the type libraries and programming mentioned in the article are only available in a VB project, not within Crystal itself. So from such a project, it shows how you can...
  7. Crystal Reports parameter with formula field (Crystal Reports)

    Sorry to ask for something that's not strictly Office related - I'm using the standalone version of Crystal - but it does have a loose connection and many people on this site will be familiar with...
  8. Re: Adding Outlook attachment - can't find this file (XP Office 2003)

    Yes, sorry, I did also code :

    On Error Resume Next

    Only way to do it!
  9. Re: Adding Outlook attachment - can't find this file (XP Office 2003)

    Later..... Actually, Hans, it only works sometimes, but more often not! Very strange! However, I have devised a loop that DOES seem to work, and it is :

    Do
    objMail.Attachments.Add strZipFile...
  10. Re: Adding Outlook attachment - can't find this file (XP Office 2003)

    Thanks, Hans! In tests so far, it's working, although the Winzip invocation is occasionally failing on a password error - but that's a different matter. Still don't understand why the...
  11. Adding Outlook attachment - can't find this file (XP Office 2003)

    This one is driving me crazy!! I've got a little bit of VBA behind a command button on an Access form. Click it and what should happen is that a Shell command creates a zip file, and then Outlook is...
  12. Re: Open Office documents outside IE (XP Office 2003)

    Thanks, Hans. Would you believe that I had literally just stumbled across the KB item (162059) stating that very same thing as your reply arrived? The KB item also details a Registry change procedure...
  13. Open Office documents outside IE (XP Office 2003)

    Hi. Can anyone tell me how you can open Office documents on a link on a page in IE in the correct application and not within the browser window? That is, see a link to, say, an Excel spreadsheet,...
  14. Re: Javascript - altering table element background

    Thanks, John. You're right of course, and I am using a FOR loop, just not showing it! The code shown is at the end of the loop. My problem was that, while iterating around on values of i, I couldn't...
  15. Javascript - altering table element background col

    I'm very new to Javascript (much more at home with VB), and I'm currently writing a bingo app for our divisional intranet. I'm trying to write a routine that will alter the background colour for each...
  16. Re: Coding a Union query in VB6 (VB6 and Access)

    Thanks, Charlotte. I was using a Data Environment command to reference a union query in the Access database (since I couldn't get a command to accept the union SQL at all), but couldn't figure out...
  17. Re: Coding a Union query in VB6 (VB6 and Access)

    Thanks, Hans. Passing parameters to the DataEnvironment proved beyond me for a Union query (the Data Environment didn't seem to want to accept a Union query in a command), and in the end I got what I...
  18. Coding a Union query in VB6 (VB6 and Access)

    I have a Union query in an Access database (SELECT a FROM b WHERE c <= [param1] UNION SELECT d FROM e WHERE f <= [param1]) and this works well.

    In a VB6 project which has a Data Environment...
  19. Replies
    5
    Views
    3,013

    Re: MSHFlexGrid refresh (VB6)

    I've tried that, Charlotte, but it made no difference. The statement 'Set de1.rstDocuments1 = Nothing' is invalid, though 'Set de1 = Nothing' is allowed - but apparently meaningless! Anyway, the act...
  20. Replies
    5
    Views
    3,013

    Re: MSHFlexGrid refresh (VB6)

    Hi Charlotte - thanks for looking at this. I'm using the MSHFlexGrid (yes, the hierarchical one) simply because it's a quick and easy way to get an Access table shown in a VB6 application (tying it...
  21. Replies
    5
    Views
    3,013

    MSHFlexGrid refresh (VB6)

    Has anyone a definitive answer as to how to get a MSHFlexGrid to refresh properly and show updated information? There's a lot of stuff about this returned from Google but no-one seems to have a real...
  22. Attachments in custom forms (2000 and 2003)

    I'm quite inexperienced and certainly untrained in designing custom Outlook forms, so forgive me if the answer to this query is obvious to you all.

    The form I'm designing is a news submission...
  23. HFlexGrid not updating (Win2000 Office 2000 VB6)

    Hi. I'm having trouble getting a Hierarchical FlexGrid to update what it shows when the underlying data is updated.

    I show a HFlexGrid on a form (using just as datagrid - getting data from a...
  24. Re: Using ShellExecute to start Excel (Access 2000 VBA)

    Doh! You're right about the appExcel reference, Hans. I was just about to reply that I knew that (there are mentions via a Google search) and it wasn't that when I thought that I'd better just check...
  25. Using ShellExecute to start Excel (Access 2000 VBA)

    Within an Access form, I have a button that, when clicked, creates an Excel spreadsheet (with a pivot table, although that's not important). I used to then make Excel visible and just destroy the...
Results 1 to 25 of 190
Page 1 of 8 1 2 3 4