Search Results - VBForums

Search:

Type: Posts; User: Daniel Duta

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. A strange error regarding multiple ranges

    Hello all,

    Last week I met a very curious behavior regarding a common method of write a bunch of ranges in a single line, such as objExcelApp.Range("A1, B2:B4, C2:C3").Value = 3. It doesn't matter...
  2. Replies
    13
    Views
    358

    Re: A run-time error 5

    After I spent one day to replace 3 controls dependent on mscomctl.ocx (some progress bars, a tree view and a image list which was replaced with a image strip) the application worked like a charm. So...
  3. Replies
    13
    Views
    358

    Re: A run-time error 5

    Yes, Sam, it was exactly what I had in mind for testing. However, I do not understand why no error trappping didn't work in my procedures. That error seems to be somehow outside of my application.
  4. Replies
    13
    Views
    358

    Re: A run-time error 5

    Maybe you have a serious reason to suspect that control...I will test tomorrow if something is wrong with it. Thank you.
  5. Replies
    13
    Views
    358

    Re: A run-time error 5

    Thank you DataMiser for your reply. I have just found out that we use different versions of IE: my version is 10 while the target PC has 9. But I cannot understand in what way could affect the IE a...
  6. Replies
    13
    Views
    358

    [RESOLVED] A run-time error 5

    Hello all,

    I created an application that requires to be installed by reason of besides the main executable file it has some files that have to be registered. After I packed all files and I tested...
  7. Replies
    1
    Views
    140

    How to detect a new file in a folder

    Hi all,
    I have to monitor an input folder permanently and each time when a new file is created/saved in this folder I should run a small application (an executable file). Is it possible this process...
  8. Replies
    5
    Views
    271

    Re: A space issue in Outlook

    Hi westconn1,
    It seems <&nsp;> solved my issue. Thank you.
  9. Replies
    5
    Views
    271

    Re: A space issue in Outlook

    All these tags fail...The <br> tag inserts a single line break while <p> is designed for paragraph and it can create spaces inside a text written in this paragraph. To create a space between two...
  10. Re: Is there a better alternative for VBA EDITOR in Office 2010

    Maybe I was not well understood. My suggestion was to completely replace the VBA Editor with VB6 IDE. In this case we cannot talk about macros but procedures or functions that run in a different...
  11. Re: Is there a better alternative for VBA EDITOR in Office 2010

    Hi techgnome,
    I have worked with vba in this way for years but I cannot get your point above. Once you have referenced the vba library why should I copy any code from VB6 IDE back to the VBA Editor?
  12. Re: Is there a better alternative for VBA EDITOR in Office 2010

    Hi,
    The most professional IDE for Office, even it is not designed for it is the classic VB6. It is easy to learn and it has COM support, it is flexible, fast enough, with its own compiler, debugger,...
  13. Replies
    5
    Views
    271

    [RESOLVED] A space issue in Outlook

    Hello all,
    Does anyone know how to insert a space between two HTML image tags ? Thank you in advance.
  14. Thread: Time

    by Daniel Duta
    Replies
    4
    Views
    166

    Re: Time

    I think there are many solutions but you could substract any part of time in this simple way :

    Private Sub Form_Load()
    Dim myTime As String
    myTime = Hour(Time) - 6 & ":" & Minute(Time) &...
  15. Replies
    6
    Views
    269

    Re: Open multiple files

    I am sorry laVolpe, I ignored that link because it wasn't pointed out by some words/explanations around such as : "that is all you need", "this function solves your issue" etc. Because I am not a...
  16. Replies
    6
    Views
    269

    Re: Open multiple files

    No, I have not failed to open some files but simply I wanted to be able to open various files using a single command. shell32 library allows us do that but it opens an intermediate window leaving...
  17. Replies
    6
    Views
    269

    [RESOLVED] Open multiple files

    Hi guys,
    I want to find a way to open different files using a single function for this purpose. Let's say I want to be able to open both csv, txt and xls files or even an exe file in the same time....
  18. Replies
    9
    Views
    379

    Re: A PropertyBag issue

    In my particular case I just want to keep in control 8 strings and for this purpose to use a MDB seems to be a heavy solution. The Olaf's approach is closest to the mine and I consider - after those...
  19. Replies
    9
    Views
    379

    Re: A PropertyBag issue

    I have not considered an INI file or other methods based on API functions because I feel the solution should be a little bit easier. The first thing I have in mind is to try an approach considering...
  20. Replies
    9
    Views
    379

    Re: A PropertyBag issue

    First of all I am honored to be within this thread with two of the greatest contributors of this forum.
    I suspect also I have a bug in the Load and Save Content procedures...From this reason I...
  21. Replies
    9
    Views
    379

    [RESOLVED] A PropertyBag issue

    Hi all,
    I try to store 8 strings in a small database and these strings are actually some distribution lists for email. When I have written these strings in the Distribution.dat file everything goes...
  22. Replies
    13
    Views
    448

    Re: [RESOLVED] Instr function

    PS. Honestly, it is one of the most interesting solution I have ever seen. I am sure not many students in informatics or even experienced programmer could solve this problem in a such a simple...
  23. Replies
    13
    Views
    448

    Re: Instr function

    Hello Dille,
    I was about to start a function based on the native Split function when I read your post. It is exactly what I needed. Only to check the presence of a string number in other. So it is...
  24. Replies
    13
    Views
    448

    Re: Instr function

    Hi Arno,
    Thank you for reply. Your function is not very different than other based on Split function, which is even smaller. After that you can loop the array and if n1=n2 than exit for/sub. The...
  25. Replies
    13
    Views
    448

    [RESOLVED] Instr function

    Hi All,
    I need to evaluate if a string that contains numbers has a certain number. For this purpose I thought that I can use the Instr function but it seems the approach is wrong. My example looks...
  26. Replies
    8
    Views
    338

    Re: Saving image not path

    I have just created an empty mdb file and surprisingly it is even smaller than yours that has stored those four pics. I don't understand why but in these conditions I wonder how/why images are going...
  27. Re: Distributing the applications-dependency question

    What about of Setup Factory ? I think you don't use/recommend the native Package & Deployment Wizard.
  28. Replies
    8
    Views
    650

    Re: [RESOLVED] About MSSTDFMT.dll

    It is exactly what I have done. I have set the DataFormat property of a TextBox at design time and the IDE added each time a reference automatically (phenomenon that is easy to check). For this...
  29. Replies
    8
    Views
    650

    Re: About MSSTDFMT.dll

    In my Microsoft Visual Basic 6.0 Tools I have only API Text Viewer and Package Wizard. Nothing related to that Depends.exe. But it is true, my VB6 is not installed via Visual Studio package. Anyway...
  30. Replies
    8
    Views
    650

    Re: About MSSTDFMT.dll

    Hi Dile,
    Thank you very much for your documented reply. It is first time when I experienced something like this and it was difficult to search through all application controls (over 40) to find that...
  31. Replies
    8
    Views
    650

    [RESOLVED] About MSSTDFMT.dll

    Hi,
    I have an application that until now worked without any dependency of this library but today I have noted that each time my app does create a reference to it even I don't remember if I called...
  32. Replies
    23
    Views
    1,132

    Re: A base 0 array

    Hello all,
    I owe you a reply to my thread. I have solved the NullValue issue simply transposing the 2D array obtained with ADO control , via rs.GetRows method. It worked but I have no explanation...
  33. Replies
    23
    Views
    1,132

    Re: A base 0 array

    Hi George,
    I do not understand your argument regarding upper bound changing. As I know only the last array dimension can be resized and you cannot transform/expand directly a 2D array (via Preserve)...
  34. Replies
    23
    Views
    1,132

    Re: A base 0 array

    Hello,
    I am a bit confused. After I tested the Olaf's example it seems that Excel sheet allows to fill a Range from a 2D array (0 based) directly, even in a shifted way : Range("A1").Value=arr(0,...
  35. Replies
    23
    Views
    1,132

    A base 0 array

    Hello all,
    I have a zero 2D array and I have to populate an excel sheet with it. As you know, for this simple task the array should be in 1 base. The question is: is there any way to convert a 2D...
  36. Replies
    1
    Views
    274

    Re: A issue with a csv file

    After many attempts I have found a solution myself. Simply we have to add to the Open method "Local:=True" which is set by default as false. So the below line will allow us to see the date column...
  37. Replies
    1
    Views
    274

    [RESOLVED] A issue with a csv file

    Hi all,
    I have a small csv file with 2 columns and I use Excel 2010 to open it. Each time when I open it with excel it is somehow converted automatically and displayed properly in the worksheet....
  38. Re: How to load properly a text file in an array?

    Hello guys,
    I owe you all a feedback regarding my thread. After I tested many ideas involved in your samples I considered the closest to my thinking and my needs is the passel's approach. So I built...
  39. Re: How to load properly a text file in an array?

    Hi,
    Trying today to bring my csv file in a 2D array I realized that it is not tab delimited but space delimited. The worst thing is these spaces are not constant but variable and I really do not...
  40. Re: How to load properly a text file in an array?

    Hi,
    Thanks for suggestion, Max. An UDT array could be a solution for my needs. I will try tomorrow this approach because it is a bit late to me at the moment.
Results 1 to 40 of 155
Page 1 of 4 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.