I made this macro to create folders and subfolders automatically, but I need to save the file I'm editing inside the created pasture ... can anyone help me?
Follow the script
' MACRO PARA CRIAR PASTA DE ANO/MES/DIA
Public Const sCaminho =...
Good morning, I need some help.
I have this macro it is working perfectly but I need to add 1 things to it.
When it runs and generates the new file with the tabs that I selected, I need to open Outlook, this new file is attached to it.
Can...
I have this bit of code:
Range("F8").Select
For Each m In Range(Range("C8"), Range("C" & rows.Count).End(xlUp))
If ActiveCell.Offset(0, 0) <> " " Then
ActiveCell.Offset(0, 7) = Application.vlookup(ActiveCell, Sheet...
I have a list of male and female names that I need to determine in the front cell of the gender of the name.
The logic that analyzes the name and says if it is male and female is ready, however, I need to create the following logic, but I do...
I am performing a migration service from a database with a SQL Server server in a company, but have asked me to intermediate the migration in Excel Spreadsheets, because they want so in this first phase to advance some treatments in same work...
I'm trying to do a GET in VBA in Excel, and found several examples, below what I'm using:
Sub http()
Dim MyRequest As Object
Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
MyRequest.Open "GET", "http://www.google.com",...
I made several attempts to execute a macro when starting Excel as indicated in the searches I did, although these indications are very simple, in my case they did not work.
I followed the following script:
Double click on "This_work_fold...
Does anyone know if there is any way I can create a hyperlink in a cell in excel where the value specified in this cell is passed to the id value of a URL? Example:
Cell with value: 100531, when clicking on it, call a url link where VALORDA...
I need help with vba. When inserting values using linetype, I want to change columns, with each N number of lines.
For each 100 counted rows and values entered automatically, the column is altering and the row count resumes in a new column. I...