rest

Hey guys, how do I run the macro through the hidden worksheet, and the result will make the worksheet visible and the rest still hidden. Help is much appreciated! https://ibb.co/hgP1dx

I have currently this code: Call Shell("("C:\Folder\WinSCP\WinSCP.com /ini=nul /script=""C:\Folder\WinSCP\Remote2local.txt"" ", vbHide) Application.Wait (Now + TimeValue("0:00:10")) Rest of the code ... The problem with this code is that if the computer is slow, it will...

I use excel to project production across a 12.5 hour shift. The chart is broken down by hours (rows) and columns for projected volume per hour and the actual volume for that hour. I'd like to figure out how to make the projected volume for each hour increase or decrease as the previous hour's...

Self explanatory, but for clarity... 1. Row 1 has 5 columns of data (A to E). I want only the 5th column data. The rest is to be deleted. That 5th column data would now be in column A. 2. Row 2 has 10 columns of data (A to J). I want only the 10th column data. The rest is to be deleted...

I have FEW TABELS in my sheet except this boxes i need rest for the cells need to be Grey color (if cells have value it should be not change) is it possible?

Given that a start time and end time . Like 8:30- 10:30 , so I can calculate the duration (minutes) -->120 the situation : every 45 min , a short 5 mins break will be given . It will be 8:30-9:15 (first session) (45min accumulate ) ,9:15-9:20(1 rest time) ,9:20-10:05(2 session)(90 min...

Hello I have a vertical column that I want to add and have a total at the bottom. How do I set up the formula so I can just do it once and copy it down the rest of the column so I don't had to manual click on every one of them? Thank you

Howdy folks, So this is my dilemma....I have 2000+ rows of information and A-T columns. I am trying to simply insert information into column O line 176 without disturbing any of the columns/rows to the left...Is there a way to do this? I have tried inserting but it always creates a blank cell...

I have the following macro, but instead of MsgBox I want to color the cell and stop the macro: Sub verificaCNP() ' ' verificaCNP Macro ' Dim lr As Long lr = Range("A" & Rows.Count).End(xlUp).Row For Each c In Range("G3:G" & lr).Cells If c.Value <> "" Then c.Activate...

I have an Excel sheet with a number of combo boxes. The one I need to rest the value for is called "Store". How do I reset this Combox to the first value in the Named Range?

Hi everyone! I have a VBA question that is stumping me. I need a formula that looks at the date and based on how many days there are in the month divides the number next to it and allocates the rest of the amount to the following month. like for example: If these are the date ranges <tbody>...

I have seen this type of characters "<>$-* and gaps between values 456.789- *568.658 --etc I need only values like this 425.368 rest of the special charecters need to remove

So I have a macro, but if a certain condition is met, I want the rest of it to stop running. How do I fix the code below? Currently, it keeps going. Sub ABC() If Range("D1") = "XXX" Then MsgBox "WARNING" Application.EnableEvents = False End If [rest of macro] End Sub

I have a long spreadsheet that does comparisons, if the comparisons are true column K is highlighted yellow. what im trying to do is then change the highlighted cell to a test that reads "Already Monitored" using VBA. the rest of the cells should stay blank. Any ideas on this? thanks

Hello all, I have been using the site BrickLink for the past year and would like to use their API to get information from their catalog, etc. I have some basic VBA knowledge, but I am stumped when it comes to using it for this task. I think I have a good grasp of how to use the various methods...

I am developing a tool to assist my sales team in the quotation process. Majority of our quotation is done in Excel, as part of when the quote is generated it saves the quote as a PDF and I would like it to automatically upload all the quote data and a copy of the PDF to our CRM package using...

Hi, I'm gonna try to pull data into MsExcel using an API. I have the choice between REST or SOAP, what's best? Any code example somewhere? Although, to call the API I will need to provide my password in clear. Is there a way to protect (password?) the part of the code running the API? Thank you

Hi, I'm consuming a rest service from a SAAS platform and I need to find a way to read the XML returned back to the worksheet. I've gotton as far as loading the XML into an MSXML2.DOMDocument. The XML is indicated below : <?xml version="1.0" encoding="UTF-8"?> <response success="true">...

hello everyone, I have a question regarding a datalist I want to clean and was hoping that someone may help me. As follows, I have a list with a filter containing 10 columns with headings and I want to delete all obeservations that are less then the maximum value for a specific name and date...

I'd like to post data to a web service from an excel sheet... is there a VBA equivalent of cURL? What I would like to do is something like: $ curl http://rifgraf.heroku.com/graphs/sample -X POST -d value=$RANDOM Thanks for any help, Stu