Search:

Type: Posts; User: Bezzie

Page 1 of 12 1 2 3 4

Search: Search took 0.11 seconds.

  1. Re: Determine which computer is running Excel file

    Where would the best place be to put this code so that it executes on opening the workbook? Don't know what executes when:o

    Not too worry. Found Workbook_Open:D
  2. [RESOLVED] Determine which computer is running Excel file

    I have model in Excel that are run from two different computers (a desktop and a laptop). The model uses a file to import data that is located in a OneDrive folder. The path to that OneDrive folder...
  3. Re: Placing a border around a range of cells in Excel file from VB6

    Thanks guys. Got it sorted now.
  4. Re: Placing a border around a range of cells in Excel file from VB6

    Tried both methods and got both to work.

    With the method of SamOscarBrown I noticed that one should only select the specific cells that will be effected by the line i.e. to draw the left line only...
  5. Re: Placing a border around a range of cells in Excel file from VB6

    I'm going to try it. Thanks.
  6. Re: Placing a border around a range of cells in Excel file from VB6

    Don't really know. Got examples from internet and tried the worksheet creation from my code. Have no experience doing this before.


    Dim oXLApp As Object
    Dim oXLBook As Object
    Dim...
  7. Re: Placing a border around a range of cells in Excel file from VB6

    It's an accounting (currency) value I want to put in the merged cells but it puts the currency symbol to the left of the cell and the amount to the right of the cell. Even selecting the merged...
  8. Re: Placing a border around a range of cells in Excel file from VB6

    The last one (xlRight) you have d3:d3 where the others are all c3:d3

    I tried with my range specified instead of c3:d3 but it still draws lined around each cell in the range.
  9. Re: Placing a border around a range of cells in Excel file from VB6

    Where are the xlLeft, xlRight etc. defined? Compiler tells me variable not defined.
  10. [RESOLVED] Placing a border around a range of cells in Excel file from VB6

    How do one get a border around a range of cells, and not the individual cells in the range, in Excel worksheet created from VB6?

    Everything works when creating the worksheet but for the life of me...
  11. Different MD5 hash for files created on English Windows installed on Chinese Windows

    I check the MD5 hash of a few files when my program is installed. The program is compiled on English Windows version but when we try to install it on a Chinese Windows version it installs but then...
  12. Replies
    8
    Views
    1,429

    Detecting when program/form loses focus

    How do one detect that a form lost focus when program loses focus i.e. user go to another program for instance? Program is open and form is open but I go to another program.

    LostFocus event of...
  13. Replies
    0
    Views
    324

    Custom InputBox error

    I've created a custom inputbox so user can select which data to export (to an Excel ws in this case).

    On my form, that will call the custom inputbox, I have a Listview control that shows a popup...
  14. Replies
    11
    Views
    1,551

    Re: Weird error

    Got it sorted but man was this a crap one to find.

    It turned out to be a call to the database in a function located in sub that was in the Activate event of my main form. So calling the small form...
  15. Replies
    11
    Views
    1,551

    Re: Weird error

    It's just a message that is displayed in a textbox on the screen. I is just a counter from 1 to 10.
  16. Replies
    11
    Views
    1,551

    Re: Weird error

    I narrowed it down to the closing of my database connections (I think:eek:).

    Did a search on the forum and find the following to close data connections:

    If Not myConnection Is Nothing Then...
  17. Replies
    11
    Views
    1,551

    Re: Weird error

    It has to be something before the DoAutoBackup that is causing the problem. I added some code right before the call to the DoAutoBackup just to waste some time and the error pops up earlier now. Must...
  18. Replies
    11
    Views
    1,551

    Re: Weird error

    It compiles a list of the database files to include in the ZIP file and then add them to the ZIP file to have a backup of data files when the user changed some data.

    The Form_Unload event:
    ...
  19. Replies
    11
    Views
    1,551

    Re: Weird error

    There is no code in the FrmMsgWait form.

    In the unload event of the FrmRingneck where the FrmMsgWait is called I set the Caption of the message before FrmMsgWait.Show and after the backup file is...
  20. Replies
    11
    Views
    1,551

    [RESOLVED] Weird error

    Anybody has an idea why the following code will result in the error message below?

    Load FrmMsgWait
    FrmMsgWait.LblMessage.Caption = "Writing AutoBackup file..."
    FrmMsgWait.Show
    FrmMsgWait is a...
  21. Re: Copy table from Access database with M$ Jet

    Great stuff. Thank you.

    For the life of me I couldn't remember that website name:blush: Had to reformat my pc a while ago and lost all my bookmarks:sick:
  22. [RESOLVED] Copy table from Access database with M$ Jet

    How can I export a complete table (structure and data) from my Access database to a new database using VB6?

    Is there a easier way to accomplish this than creating a new database then create a new...
  23. Replies
    16
    Views
    2,184

    Re: [RESOLVED] MSFlexGrid and scrolling

    Thanks for the help.
  24. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    My "problem" is that MSFlexGrid scrolls the whole column at a time.



    Calculating the width of the text in the column (I made the column width as wide as can be displayed visually) with the...
  25. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    There are three MSFlexgrids on the screen. User can select entries and move them in and out of the flexgrids as well as sort the grids so while WordWrap and RowHeight will work it's a lot of overhead...
  26. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    Was trying to scroll to be able to read the full entry when the entry in the cell is longer than what is available visibly.

    Have been trying something else that works a bit better though. Using...
  27. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    Tried the fixed column (had to fix first two cols as there is a col with zero length). The second (first col is 0 length) column then stays visible but when scrolling to the right with the scrollbars...
  28. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    Found it right after I sent the reply so edited the reply. Property is 0 so changed it to 1 but still scrolls the column away. Still busy trying it out.
  29. Replies
    16
    Views
    2,184

    Re: MSFlexGrid and scrolling

    Will try and see how it than behaves.
  30. Replies
    16
    Views
    2,184

    [RESOLVED] MSFlexGrid and scrolling

    My MSFlexGrid has two columns, a short Col 1 and a long Col 2 (or is that 0 and 1) which is partially hidden due to the length being longer than the visible flexgrid. When the user click on an entry...
  31. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    I rename them with:

    oXLBook.Worksheets(1).Name = "New Name"

    Adding the False to the oXLBook.Close sorted that problem of the lockup. Problem was a Save As from Excel that sat behind my program....
  32. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    The lockup happens when trying to rename a sheet that doesn't exist. On my PC Excel opens a workbook with three default worksheets so I renamed the three worksheets to what I need. On another users...
  33. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    Without saving. Only saves the workbook once data is written. This crash happened just after creating and opening the workbook when I tried to rename the three sheets I'm going to use. The crash...
  34. Re: VB6 Add Excel sheet to workbook if sheet doesn't exist already

    Thanks. Got that sorted now.

    Just another question: When the program erred for instance because there is not three sheets available for writing it goes to the error handler and shows the error...
  35. [RESOLVED] VB6 Add Excel sheet to workbook if sheet doesn't exist already

    I need to create a new Excel workbook from within VB6 program and then write to three different sheets in the workbook.

    On my version of Excel it opens a new workbook with three default sheets...
  36. Re: Send email with attachment using default mail client

    Thanks for the input. I've decided to bench the idea. Just too many options to try and cater for.
  37. Re: Send email with attachment using default mail client

    According to what I read in the links provided the syntax will be different for different email clients.

    Is there a way to determine which default email client the user has in order to construct a...
  38. Re: Send email with attachment using default mail client

    Think there might be misunderstandings somewhere.

    My program is a recordkeeping program for birdbreeding hobby. Some of the birds we keep need permits and if we sell of those birds we need to...
  39. Re: Send email with attachment using default mail client

    For info: It's different users each using his/her own combinations of service providers, operating systems and email clients.

    Will have a look at the link you posted.
  40. Re: Send email with attachment using default mail client

    My PC's are 64bit OS and the two with Office365 is also Office365 64bit. The third PC with Win10 (64bit) and Thunderbird I think is 32bit. Not sure.

    My problem is however that if I want to add...
Results 1 to 40 of 473
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width