Search:

Type: Posts; User: JimWyseTech

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    953

    Re: VB6 can't show Office Help.

    Hi Zvoni,

    No, I'm using VB6 to manage Office, i.e. Excel and Outlook.
  2. Replies
    1
    Views
    496

    Can't use Excel.exe as .dll

    I have an app that I created, that runs fine on my PC at home, but throws up the error "Run-time Error 48: Error in loading DLL" when I try to run it on a similar machine in my office.

    At the top...
  3. Replies
    3
    Views
    658

    Mid$ not working to label.caption

    Hello,

    I have a situation where I need to replace a single character within a form's label.caption.

    I have figured out a way to do it, using a string variable,
    (solvstr is a string variable,...
  4. Replies
    2
    Views
    953

    VB6 can't show Office Help.

    I run VB6 Pro, on Windows 10 64bit.

    F1 help in VB6 works just fine, but if I'm working with Excel for example, using what amounts to VBA code, F1 just throws up "Unable to display Help".

    Do I...
  5. Re: [RESOLVED] Closing Excel Worksheet after completing VB6 Process

    WOW! Thank you, Zvoni.
    I changed my "close excel" code to this:


    oWb.Close Savechanges:=True
    Set oWs = Nothing
    Set oWb = Nothing
    oXL.Quit
    Set oXL = Nothing
  6. Re: [RESOLVED] Closing Excel Worksheet after completing VB6 Process

    I have a similar situation, but it is not resolved by the resolution shown here.
    My application opens Excel to record temperature readings throughout the day, so I wish to open and close Excel at...
  7. Re: Microsoft excel 15.0 object library missing

    Thanks, Tyson, that sorted it!
    I found the .vbp file was pointing to C:\Program Files (x86)\Microsoft Office...
    I edited that to remove the (X86), and it now works!
    Cheers!
  8. Re: Microsoft excel 15.0 object library missing

    Yes indeed, it was Microsoft Excel 16.0 Object Library that is "Missing", but trying to replace that with Excel.exe doesn't get saved.
    I use the same path as you: C:\Program Files\Microsoft...
  9. Re: Microsoft excel 15.0 object library missing

    Thanks for your reply, Tyson.
    No, only Office 365 on this PC. (It's new, just setup two days ago.)
    Office 365 (Company account), Windows 10 Pro 20H2, VB6 via VS6.
  10. Re: Microsoft excel 15.0 object library missing

    I have an issue like this.
    My project reports the missing object library, but when I browse to Excel.exe and use that, the IDE won't save it!
    The project runs fine that time, but when I open the...
  11. Re: Outlook signatures created via VB6 won't show images.

    Many thanks for that link. That sorted it for me!

    Dead simple, really! I just had to add a .Getinspector line to make Outlook create a blank message with the default signature, locate the...
  12. Re: Outlook signatures created via VB6 won't show images.

    Hi,
    I've tried both!
    Initial attempts left the path in the .htm file as it was, i.e. local to Outlook.
    Subsequently, I tried changing the path to the full local path, e.g.
    C:\Users\<my...
  13. Re: Outlook signatures created via VB6 won't show images.

    Thanks, I tried that, but no change!

    Here's my updated code:



    Dim strbody As String
    Dim SigString As String
    Dim Signature As String
    SigString = Environ("appdata") &...
  14. Outlook signatures created via VB6 won't show images.

    I have created a small application, using RobDogg88's example, to create e-mails automatically, when needed.
    I have tried without success to get the correct signature appended.
    The signature itself...
  15. Re: variable not defined at Make time, but OK in IDE

    OK, problem resolved.

    Somehow, I had managed to make a copy of the StartCamera routine in the Form1 section, so it was trying to use this instead of the correct one that is in the UserControl. :o...
  16. Re: variable not defined at Make time, but OK in IDE

    It's all part of one project, that USED to compile into one exe.
  17. Re: variable not defined at Make time, but OK in IDE

    Thanks for the link, Sam.

    I'll investigate, and report back!

    (Interestingly, this code used to work! I don't know what has changed to stop it!):confused:
  18. Re: variable not defined at Make time, but OK in IDE

    Hi, and thanks for the quick responses!

    The StartCamera Function is a member of the UserControl.

    If I move the Variables to Public, in a Module, then the UserControl Functions report the...
  19. [RESOLVED] variable not defined at Make time, but OK in IDE

    My program runs just fine in the IDE, but when I try to make an exe, I get "Variable Not Defined" errors.
    This is where the error first occurs, on fgmVidCap:


    Public Function StartCamera(ByVal...
Results 1 to 19 of 19



Click Here to Expand Forum to Full Width