Please help with the following problem:
I have a .txt file to be formatted in EXCEL, and a data separation has to be done, data and line numbers may vary in size.
The logic would be more or less this:
If the cell text is ("case1")
Selec...
Strange behavior in Excel VBA!
The code opens a source file, and copies an existing table.
Paste the table into a destination file - in the SUPPORT worksheet - and closes the source file.
In the destination file there is a worksheet named RENT,...
Good morning ...
I need to know how I can get the zip codes and numbers listed in a spreadsheet with VBA, with this information going one by one at a URL and saving results and a new spreadsheet. I know very little about VBA, the code I'm tes...
Good afternoon.
I need a macro to lighten a figure, located on the worksheet, and reverse coloration.
Excel does not record the macro when you change the settings in the "Format" tab. I've browsed Google from end to end as well.
Thank you...
I have a dropdown with information I already have in a excel sheet in Visual Basic, how do I go get that same information? And already make sure there is no repeated information?
Example:
colunaA
a
a
a
b
b
b
b
c
c
d
e
e
And t...
Good morning,
I have a macro that accesses a website, I enter the data and performs search, but I can not get it to click the "Browse" button, could anyone help? Follows page HTML and macro code;
<div class="row">...
I'm using Access 2007 to develop a garage control form, which provides travel information made by drivers.
I need to calculate the total amount of time for each trip, and this period can be longer than 24 hours.
I was able to calculate without p...
I have a table with hundreds of values and these are divided between product name and date of sale.
I've filtered the type of product (in the example, blouses and shirts) and now I want to get the quartiles for each month.
Example
Nome...
Another Hardcore challenge, I do not know if I can explain it well, but there it goes.
In the table below, I have the "X" feature, where he has already made 8 contacts (5 completed and 3 unfinished) and I would like to automatically count which...