location

Hello, so I have a code to download a google sheet as excel to my computer. I'm getting the following error in my code and can't figure out what's wrong: (line highlighted in red) Sub ImportGoogleSheet() Dim URL, Location, FileName As String Dim objWeb, objWrite As Object URL = "Google...

Hello, I am trying to make an ifs statement that works with data validation. I want it to be IFS(A1="Location1","Fred",A1="Location2","Mike",A1="Location3", *drop down of 3 names*) (If A1= Location 1 then A2 autopopulates to Fred, same with location 2 and Mike, Location 3 I want a drop down of...

I'm using a Multipage (13 pages) on a UserForm and on each page I have 8 text boxes. These text boxes get calculated and the resulting value is entered into a cell on the worksheet. I have one set of controls (Enter, Calculate, and Clear) on the UserForm section. The 13 pages represent...

Hello all, I have the following code that i have been piecing together in order to use excel cells to fill in a word document i have several text form fields. Now this is a sub macro within a larger program. The main information that come in is the Target.row information which gives us the...

Hi Everyone, I been banging my head over 2 days trying to figure out how to forecast the amount of sensors. The data I have has column B (Locations) But this location doubles up based on the different branch it has. So some location can have up to 10 entries. from C to AC are dates that each...

Greetings, Thanks, in advance to those who might be able to help. I'll make it as concise as I can while providing context when needed. Scenario: I work for a Distribution Centre with about 10,000 unique location in the warehouse (4 different sizes and storage capacity [full, half, quarter...

I have a workbook that processes data and puts it into a usable format for people in my department. The workbook pulls data from about 12 other workbooks. Currently, my script points to a location on my hard drive. I'd like the file location to be a variable so...I can hand this workbook off...

Hello, I am looking to create a Survey inside excel. I have 45 different locations and I would like to know what locations the customer has been to. I have created a check box list of all the locations. I would like the customer to select all the locations they have been to and then on then on...

Hi, I need some help with creating a macro, that can move a open workbook to a new location and delete it from the original location. Is that even possible? regards, Hawjeen

Hi, We are setting up new location in our warehouse and need to assign items to those locations. Some items will have multiple locations. Each location has a maximum number of cartons that can go in that location. I have a SKU number, number of cartons for that SKU, item locations, and...

To whom might be able to help. In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...

I am researching my Great Great Grandfathers time during the Civil War. What started to be a simple Excel file has grown to a large file, 25000+ rows. Not what I planned for but the further I got in the research the more I expanded to included all members of his units. I am new to VBA and...

Hi I have one sheet in a workbooks, and that sheet I can call it 1) Sheet1 2) Sheets(1) or Worksheets(1) 3) Sheets("sheet1") or Worksheets("sheet1") Sheet1, Sheets("sheet1") or Worksheets("sheet1") will always refer to that sheet no matter what except if the sheet name has been changed then...

Hi, I've got a workbook with multiple sheets, which is used to facilitate operational processes. I'm almost done with the "tool" except for one more thing. I am looking for a vba code to save the sheet called "Input CW1" as CSV with the following side notes: - I wish to save the file under the...

anyone know how to get excel an open workbook without specifying an exact address?

Hi Everyone, I am a newbie to this forum, though not necessarily new to the rules. I have a very simple task to complete, yet no matter how many youtube videos I watched and how many different forums and pages I have read, none of them are this simple. I did see a function called...

Hello all, hope you're doing fine.. So I made this dashboard with some data I insert every once and a while, and in the table that contains all that data I have two columns stating the some locations. It's a simple table where I insert the pickup location in one column and the delivery location...

I have a folder that is a template for multiple forms. I wrote a code that open the forms and publishes to another location. Works fine. My problem is that since this is a template that my users use to make a new file the location changes The area in red font is my issue. my simplistic...

I have a set of docs in a folder that is used as a template. Our people Copy template into a different location. Everything works but a macro that opens files. Below is my template location and name. How do I structure the Macro to adjust to new location? Workbooks.Open Filename:= _...

Below is my code and works perfectly. Only problem I have is if I email this "Temp folder" where this spreadsheet is located, you can see it will be looking for my desktop specific location on my computer. What I would like to do, and not sure if it's possible, is to write a pdf copy to...