Ask Question Forum:
Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by duncanb7
at 2024-03-27 07:34:48
ModifyPoint:250 Replies:12 POST_ID:828452USER_ID:11059
Topic:
Visual Basic Programming;;
I would like to make my person web broswer not(using IE) in Excel VBA.
I google it there is a lot, but they always tak about useform., and I get confuse
on those not complete code
Could you provide me a good website about make a web broswer from in Excel 2003 VBA for tutorial ?
Please not on Micosoft 2008 VB
Please advise
Dunca
I google it there is a lot, but they always tak about useform., and I get confuse
on those not complete code
Could you provide me a good website about make a web broswer from in Excel 2003 VBA for tutorial ?
Please not on Micosoft 2008 VB
Please advise
Dunca
Expert: BlueDevilFan replied at 2024-04-12 17:24:39
You're welcome.
Author: duncanb7 replied at 2024-04-12 16:20:55
THanks for your reply, it works fine
Assisted Solution
Expert: BlueDevilFan replied at 2024-03-27 16:22:46
62 points EXCELLENT
Are you talking about resizing in design mode or when the form is being used?
Author: duncanb7 replied at 2024-03-27 14:14:30
how to use VBA code to control the userform frame size and web broswer size inside of userform?
Author: duncanb7 replied at 2024-03-27 14:12:23
when goto those four corner of the userfrom and dragg it, but no any response, Why ? I am using 2003 Excel VBA
Assisted Solution
Expert: BlueDevilFan replied at 2024-03-27 13:47:01
62 points EXCELLENT
You can resize the form and the controls just by selecting them and dragging the handles.
Author: duncanb7 replied at 2024-03-27 13:13:32
Sub TestWB()
Dim objWB As New frmBrowser
objWB.Show
End Sub
Now I get it, I just run the code at thisworkbook and now it works fine ,
how to set the width and height of the broswer in userform. Could you tell me ?
Dim objWB As New frmBrowser
objWB.Show
End Sub
Now I get it, I just run the code at thisworkbook and now it works fine ,
how to set the width and height of the broswer in userform. Could you tell me ?
Author: duncanb7 replied at 2024-03-27 13:02:35
in other words, how to run userform in VBA?
Author: duncanb7 replied at 2024-03-27 13:00:46
how to use VBA code to control the userform frame size and web broswer size inside of userform?
Assisted Solution
Expert: BlueDevilFan replied at 2024-03-27 12:56:53
63 points EXCELLENT
If you plan to use the webbrowser control, then yes you have to have IE. You won't see IE (in other words you won't see any IE windows), but the webbrowser control uses its functionality behind the scenes.
Yes, you can accomplish what that video shows (or at least the part I watched) in VBA. All you need to do is create a new user form, add the web browser control, add other controls as necessary, and write the code that ties it all together. I've attached an example.
Yes, you can accomplish what that video shows (or at least the part I watched) in VBA. All you need to do is create a new user form, add the web browser control, add other controls as necessary, and write the code that ties it all together. I've attached an example.
Author: duncanb7 replied at 2024-03-27 12:41:22
So, I look at the tutorial for VB 2008 at http://www.youtube.com/watch?v=sBrL0ps5s5U,
From what you said, we have to have IE to do our browser, Right ?
If I am using IE, could I make the similar code in Excel 2003 VBA intead of VB 2008
From what you said, we have to have IE to do our browser, Right ?
If I am using IE, could I make the similar code in Excel 2003 VBA intead of VB 2008
Accepted Solution
Expert: BlueDevilFan replied at 2024-03-27 12:33:31
63 points EXCELLENT
Hi, duncanb7.
You cannot make a web browser form in Excel without using an installed browser (typically IE). You can create a user-form and place a web browser control on it, but the web browser control uses IE. In order to avoid IE altogether you'd either have to find a control that handles all the things that IE normally handles, or you'd have to write all of that yourself.
You cannot make a web browser form in Excel without using an installed browser (typically IE). You can create a user-form and place a web browser control on it, but the web browser control uses IE. In order to avoid IE altogether you'd either have to find a control that handles all the things that IE normally handles, or you'd have to write all of that yourself.
