load

Hello, I am looking for a spread sheet which will allow me to "cube" a trailer based, either by weight or space. Trailer and pallet restrictions/dimensions will vary depending on the ship to destination. I am targeting an excel based program due to in house restrictions (I have found other...

Hello all! I have a pivot table that has an https address in the raw data, which appears in the drill down results. It looks like: + Supervisor name ....+ Representative name ........+ https:// All this appears in the same column, of course. I've found so many VBA's online that "should" load...

<colgroup><col span="2"></colgroup><tbody> column Z column AA A A01 B A02 C A03 D A04 A05 A06 A07 A08 A09 A10 B01 B02 B03 B04 B05 B06 B07 B08 B09 B10 C1 C2 C3 C4 C5 D1 D2 D3 D4 D5 </tbody> Good Day, Column Z...

Hi all I have a file that I run an SQL connection to a database on load. Whenever the file opens, I get the Run Time 91 error on load - Object variable or With block variable not set. Yet I can end the macro and re-run it without any further error. Private Sub Workbook_Open() Call Load_Sap...

Actually I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values, these time values can vary in number and depend on total number of cars. So e.g. total number of cars are 40...

i have line load in column B, but the line in capped to 100 kW so the load more than 100 kW should be shifted to the cells where the load is less than hundred (can be seen in column D). from the table, we see the accumulated load to be shifted is 25 kW. this should be shifted to the cells...

Ok this is probably a simple fix but I just can't see it. I have a Yes/No msg box with the below code. The problem is if you click Yes OR No it follows the No instructions. Can someone please help me figure out what is wrong? Private Sub CommandButtonContinue_Click() Msg = "Scope...

I'm using this to load a Listbox on a Userform as the form is loaded; ListBox4.RowSource = Range(Sheet5.Range("U2"), Sheet5.Range("U11").End(xlUp)).Address(, , , True) I now need to take this a step further if possible - I now need to load only those values where the value of the 2nd offset...

Hi, i have this VBA script to load data from another sheet but the sheets i load from contain Workbook_Open macros. Whenever i run the script the macro is triggered Is there a way to prevent this? My code below loads up file explorer, i click on my source workbook and it opens Msgbox pops up...

I've used the commandbar to create and remove buttons.... Sub AddNewCB() Dim myCommandBar As CommandBar, myCommandBarCtl As CommandBarControl On Error GoTo AddNewCB_Err Set myCommandBar = CommandBars.Add(Name:="MY_LIST", Position:=msoBarFloating, MenuBar:=False, Temporary:=True)...

Does anyone know if it is possible to have your data and then when you load it back into the workbook it breaks the information down based on a column value? The only way I can see to do is to reference the original data and select each location manually for each new query. but I will have...

Hi! A problem, loading pictures into an image form. I use the image on a UserForm, together with Textboxes, which are loaded by the following code: But I can't get the images to load as wanted. I have set image name for all rows, into Column O (in this case). I get the error message "Path not...

Good day, I am a bit of a neophyte but can follow most times. Right now the issue...I have a home budget program that works on every computer I own also those at work, but it does not work on my laptop. The error message I keep getting is "Could not load an object because it is not available on...

Hello, Is there a way to load only the column heads of a listbox with vba code? I already have a script to load the listbox Just wondering if I can do the above Thanks

Hello All, I have a userform with a combobox that on Initialize the combobox is loaded with about 23000+ items I have a checkbox where it will remove all of them currently 1 by 1 and load another list of only about 200 items When the checkbox is unchecked it will reverse it by removing the...

Hi, unsure how to do this from a Txt file In the following format Name,Country Jim Jones,Australia Bob Frank,UK Want it to load into my sheet "Users" and overwrite current contents. Any help appreciated

Hello, I got fairly easy problem one of you may know the answer too. I just couldn't figure out. I have a userform, when its triggered, text boxes get populated. The data in the text boxes are coming from cell values in another sheet. However when I execute my Macro in the other sheet where...

I'm using a VBA macro to load 15 pictures in various positions in an Excel worksheet. I'll examine those pictures, delete them, then load some more. The process repeats hundreds of times. This works fine if I want to delete all the pictures that I load. However, I'd like to add some shapes...

Good morning everyone: I have to develop a piece of code that calls an useform form two different places. The first one piece of code needs to load an UserForm in memory, so what I doing now if load the UserForm calling forma normal module this way: UFPAR.PPRUE Where UFPAR is the UserForm and...

Zip Codes, the New England section of the United States where the zips are truncated in excel like 01001 or 01002 end up in Europe after I load them into the map. I thought it was because the first zero was truncated, so I formatted cells with 0####. However this still does not work, and the...