Posts by Rodrigo Moraes • 26 points
7 posts
-
1
votes1
answer3006
viewsA: VBA x IE - collect data from a table
Hi, Wanderlei! First of all, congratulations on the code, very fine stuff! Incredible as it may seem the problem here is the architecture of the BC page, which only carries the 78 first lines (in…
-
0
votes1
answer27
viewsA: VBA - Redeem the value of a website variable
Hi, Jorge. I couldn’t take the test on your app because it’s pretty vague. But if you want to get the amount of table line tags "" from an HTML code the easiest way is to use .…
-
0
votes1
answer36
viewsA: VBA - How to autocomplete a word in the middle of Textbox
Hi, h2ocampioni! Input validation is always a problem, I do not like to lock or check after each character because it is necessary to think of all possible situations. It is more elegant to check on…
-
0
votes1
answer43
viewsA: How to send dynamic image in the body of the email with VBA
Hi, Talita! That’s a common intuition. I add the image as Attachment and then put it in the IMG SRC body taking it from the same place on the computer and making the HTML render. The problem is that…
-
0
votes2
answers34
viewsA: Active X buttons
Hi, @Hudson! The solution is a little simpler that it seems. Just put a transparent Label on the back, slightly larger than the button can be 2 pixels for each side. This label will be Visible =…
-
0
votes1
answer27
viewsA: How do I change by vba the height of an image in Powerpoint WITHOUT changing the width?
Hi, Felipe! By default the aspect lock is enabled for any object of type Image. The difficulty is that for geometric shapes is not (which creates confusion), and to make matters worse both are…
-
0
votes2
answers28
viewsA: Can I make the document generated in the VBA code below be saved in the source file folder or that it asks to save in a specific location?
Hi, Marcus! To meet your option just use the property Activeworkbook.Path, which is the attribute that says where the spreadsheet is saved (from the premise that it is not a file not yet saved) So:…