|
I read your reply and was about to point out to you that you had mistyped your shortcut suggestion. Luckily I checked first. I have always used Ctl+K, D.
Nice to learn something new.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Ctl+K,D is still good in the Macro IDE. The other day I was playing with my macros and going Ctrl+E,D "bing" Ctrl+E,D "bing" ??? uhh, had to rediscover Ctrl+K,D.
For the life of me I couldn't remember using it. Shortcuts you do without thinking.
"You get that on the big jobs."
|
|
|
|
|
I have Visual C# Express and the suggested shortcut is Ctlr+E, D.
However I just tried the following:
Ctrl+E, Ctrl+D which works
Ctrl+K, Ctrl+D which works, and
Ctrl+K, D which does not work.
I must get a clever new signature for 2011.
|
|
|
|
|
I always thought Ctrl+E, D was shortcut notation for shortcuts. But you're right, even though Ctrl+E, D works the same as Ctrl+E, Ctrl+D, they are in fact, different shortcuts. Ok, I didn't know that.
"You get that on the big jobs."
|
|
|
|
|
My goof.
I meant Ctl+K, Ctl+D. i.e. keep ctl pressed for both keys.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Hi
I am using one activex component on my project. i want disable double click option this activex component in run time.
Please give any idea or url
Regards,
M.Mathivanan
|
|
|
|
|
Unregister the corresponding double-click eventhandler;
There's some code that gets executed on double-click - that must be an eventhandler. Unregister that one, and the code won't be executed.
I are Troll 
|
|
|
|
|
If the double-click event has been wired up in your code (possibly done by the designer), then you just need to use RemoveHandler to remove it. If the control handles its own double-click event without any intervential from your code, you cannot disable the double-click event. You'd have to modify the code in the ActiveX control in order to do that. If you don't have the source code for it, you're out of luck.
|
|
|
|
|
Private Const WM_KEYDOWN = &H100
Private Const WM_KEYUP = &H101
Private Const VK_BACKSPACE = &H8
Private Overloads Shared Function SendMessage(ByVal hWnd As IntPtr, _
ByVal msg As Integer, ByVal wp As IntPtr, ByVal lp As IntPtr) As IntPtr
End Function
SendMessage(windHandle, WM_KEYDOWN, CType(VK_BACKSPACE, IntPtr), CType(&HC0510001, IntPtr))
SendMessage(windHandle, WM_KEYUP, CType(VK_BACKSPACE, IntPtr), CType(&HC0510001, IntPtr))
Need help with this one! Its not working...
Thank you!
|
|
|
|
|
FeRtoll wrote: CType(&HC0510001, IntPtr)
the hex constant does not conform to the documentation[^], at least bits 31 and 30 are wrong.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Luc Pattyn wrote: the hex constant does not conform to the documentation[^], at least bits 31 and 30 are wrong.
so what should i do?
if you know how can i solve the problem please tell me!
thank you!
|
|
|
|
|
solved it... it was my fault! my function didnt fireing because of some crazy old code boolean!
so if anyone ever need this the above sendmessage works fine for backspace!
sorry guys
|
|
|
|
|
Hi,
I'm currently working on a project for my company that requires the extraction of specific data from a web-interface and put it onto an excel spreadsheet. The page on the web-interface refreshes every several seconds as new data comes in. I'm trying to write a code in Excel Visual Basic that will automatically extract specific data/information continuously as new data comes in. Since I'm new to Visual Basic I'm not really sure how to do that. I've been searching online to find any references or info on how to do that but have not been successful.
Can anyone help please?
thank you
|
|
|
|
|
Ahmed Eastlink wrote: Since I'm new to Visual Basic I'm not really sure how to do that.
Start with learning VB before you use it. If you need to learn while on a project, both the learning and the project won't be going swell.
Ahmed Eastlink wrote: I've been searching online to find any references or info on how to do that but have not been successful.
Search again, with the keywords "VB.NET fetch website" (that's one part of your request) and "Write Excell VB.NET" (the second part)
Then try to combine both examples into a solution. If you get stuck somewhere, check back here with a dump of the relevant source-code.
I are Troll
|
|
|
|
|
Hi,
Normely I use a Folderbrowserdialog for selecting a folder.
Thrue the api
Public Type BROWSEINFO
hOwner As Long 'Handle to the owner window for the dialog box.
pidlRoot As Long 'Address of an ITEMIDLIST structure specifying the location
'of the root folder from which to browse. Only the specified
'folder and its subfolders appear in the dialog box.
'This member can be NULL; in that case, the namespace
'root (the desktop folder) is used.
pszDisplayName As String 'Address of a buffer to receive the display name of the folder
'selected by the user. The size of this buffer is assumed to
'be MAX_PATH bytes.
lpszTitle As String 'Address of a null-terminated string that is displayed above
'the tree view control in the dialog box. This string can be
'used to specify instructions to the user.
ulFlags As Long 'Flags specifying the options for the dialog box.
'See constants below
lpfn As Long 'Address of an application-defined function that the dialog box calls
'when an event occurs. For more information, see the
'BrowseCallbackProc function. This member can be NULL.
lParam As Long 'Application-defined value that the dialog box passes to the
'callback function (in pData), if one is specified
iImage As Long 'Variable to receive the image associated with the selected folder.
'The image is specified as an index to the system image list.
End Type
and all needed dll imports I can have a textbox
the flag BIF_EDITBOX activate ordéactivate the textbox.
Can I do this with a build-in control
Jan
|
|
|
|
|
Use a FolderBrowserDialog : MSDN[^]
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
I fail to see where I can activate the textbox
|
|
|
|
|
If you want to put the chosen directory path into a textbox then just use the following
textbox1.text = folderBrowserDialog1.SelectedPath
Its in the example (one given to you earlier) at the bottom of the page, but it puts the value into a variable instead.
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
I want to type the folder in the dialogbox(copy/paste)
not set the defaultfolder nor the selectedfolder into a textbox
|
|
|
|
|
Not sure what you are after! Is this so you can create a folder at a given location? Then does the create folder button not give you the functionality that you are after?
If for searching you could use the example in the following Stackoverflow article[^] which also covers creating the folder if it didn't exist.
If I'm completely off mark then please expand what you are after with what you are trying to do
As barmey as a sack of badgers
Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
|
|
|
|
|
I placed a picture on the internet
The picture is writen in VBA/Excel with api
On top i can write or copy/paste a path
I don't want to make a new folder.I just want to know: is there a build-in control that also have the textbox and if it exist than what is it name. I can't find that option on a folderbrouwserdialog
Jan
|
|
|
|
|
FYI: that is a ComboBox, not a TextBox.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
there is no arrow next to it.
but even so how can I if I can add it to a folderbrowsercontrol?
|
|
|
|
|
What you have above appears to be the old VB6 (and below) way of doing things.
In VB.net it is as simple as;
Public Sub TestFolderSelection()
Dim FBD As New FolderBrowserDialog
FBD.Description = "Select a Folder;"
FBD.RootFolder = Environment.SpecialFolder.MyDocuments
Dim Response As DialogResult = FBD.ShowDialog
If Response = DialogResult.OK Then
textbox1.text = FBD.SelectedPath
End If
End Sub
|
|
|
|
|
Hi,
.NET does not expose the BROWSEINFO[^] structure for the shell's native FolderBrowser so you are stuck with the options chosen by Microsoft. I quite like the path autocomplete that's available in the native version when BIF_EDITBOX is included in BROWSEINFO.ulFlags but sadly .NET does not provide an enabling property for this.
There was an article posted just a few days ago on this topic and you may want to take a look at that. (FolderBrowserDialogEx: A C# customization of FolderBrowserDialog[^])
Alan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
