Search:
Type: Posts; User: gyhu
Search:
Search took 0.04 seconds.
-
Wow, your code is good and has high efficiency, thank you very much.
-
-
Used the code below to read a binary file into byte array.
Private Sub cmdTest_Click()
Dim fileNum As Integer
Dim bytes() As Byte
fileNum = FreeFile
Open...
-
Thank you very much for the demo.
-
Hi fafalone,
I just take "Immediate window" as an example, it seems a lot of controls don't response WM_GETTEXT message.
Best Regards,
Sniperhgy
-
Thank your for your TIP, will have a look.
-
Ok, there is still a way can do it :
Sub Test()
Sheet3.Range("C1:C3").Formula = Sheet1.Range("A1:A3").Formula
Sheet1.Range("A1:A3").Copy
Sheet3.Range("C1:C3").PasteSpecial...
-
Hi Elroy,
In my opinion, the Excel VBA provide a good method to finish this job:
wshSource.Copy Before:=wbDestination.Sheets(1)
wshSource : It's the sheet you want to copy.
-
Hi LaVolpe,
Thank you for your reply. Actually, I don't use FindWindowEx to get the Hwnd. I use WindowFromPoint to get the Hwnd directly. And in VB6.0, "Immediate window" only has one hwnd,...
-
Dear All,
I use the code below to grab text from controls, but some controls may have a title, then the code only can grab title from those controls. How to grab content from them?
Private...
-
Hi fafalone,
Your solution is perfect. Not only Chinese, Japanese, Russian or something else can also display properly. Thank you very much.
Best Regards,
Sniperhgy
-
Thank you very much for the tip. I'll take a shot then reply to you.
-
Thank you very much, I'll have a look.
-
Thank you very much for your demo.
-
Thank you for your reply. But Is there a way to solve this issue?
-
Thank you for your suggestion.
-
Please try to add a Click event to the button you want. Then in that event, you can call the dropdown menu.
-
Thank you for your suggestion. But I prefer the native method in VB6.0.
-
Sure, agree your point. SendMessage will put an byte array into my array "byt". I believe there is a way can let the textbox can display the unicode characters.
-
I'm using the code below to get text from controls, if the text only contains English letters, it works well. Once there are unicode characters involved, then the text becomes unreadable code.
...
-
-
1) Yes, before want to use SetWinEventHook, I tried to use SetWindowsHookEx with WH_CBT, but only can available inside the process, not global.
2) Sure, my propose is : In an Excel file, there are...
-
Hi Victor Bravo VI,
Your code works properly. But there is a point need to be improved: After click the form, VB will call notepad, then the hook will send close message to it. In that moment,...
-
Hi The trick,
Thank you for your reference, but I don't understand Russian T_T.
Best Regards,
Sniperhgy
-
Hi Victor Bravo VI,
Thank you for your demo, I'll have a look first.
Best Regards,
Sniperhgy
-
Dear All,
I want to write some code to determine whether there is a application is started, and if its title satisfies some string, then close it before showing up.
First step, use the...
-
Hi Elroy,
Thank you very much for your help and suggestion.
BTW, I found that if change that statement to With_One_Param(ByVal iType As Integer), it works as well.
Best Regards,
Sniperhgy
-
Hi Elroy,
Please remove this sub, or just run frmMain without compile the exe file.
Best Regards,
Sniperhgy
-
Hi Elroy,
It's my fault, please re-download the attachment from that post, I have re-upload a demo without the dll file.
Thank you very much.
Best Regards,
Sniperhgy
-
Sure, it's my fault. I'm really sorry. And will upload again without the dll file.
-
Hi Schmidt,
I just want to learn the usage of CallByName.
Best Regards,
Sniperhgy
-
Oh, it's my fault. Thank you for your help.
-
Hi Elroy,
Could you please help to check the attachment above your last reply? Thank you.
Best Regards,
Sniperhgy
-
Hi LaVolpe,
I followed your suggestion, tried to create one demo, I found that if there is no parameter, then CallByName can be executed successfully. But if I tried to pass one parameter to it,...
-
Ok, I'll take a shot, thank you.
-
Hi lisagreen,
I'm not familiar with using CallByName. Only now Application.Run in VBA can do what I want.
Best Regards,
Sniperhgy
-
Yes, post #13 is very useful.
-
Hi Elroy,
I have to create DLL, because excel can use import DLL, but can't import EXE.
Best Regards,
Sniperhgy
-
-
|
Click Here to Expand Forum to Full Width
|