Forum

Peter Douglas said Hi I have almost got this all working, I got the code to check is cell C3 is blank if it is does not Print. So now it does not pr...

Make sure the path used in your code is correct.

Found my mistake, sorry: If Ctl.Name Like "Chart*Name" Then should be: If Ctl.Name Like "*Chart*Name" Then

Hi Brian, Just for accuracy, the control name does not contain .Value, that is the method that extracts the value of that control. This line: ...

This line should be updated: ChName = Right(Ctl.Name, Len(Ctl.Name) - InStr(Ctl.Name, "Chart")) replace it with: ChName = Right(Ctl.Name, Len(Ctl.N...

Hi Howard, You can also loop through the main folder subfolders: Dim SbFld as object, FileObject as Object For each SbFld in fso.GetFolde...

Hi Leslie, You start with xlrow=2, but inside the loop you are not increasing the row index, so it will always remain 2. Before next MyAssgn, us...

Just delete that line, that procedure does not exist anymore.

Hi Corrie, The FIFO problem is more complicated than you described, for example, units sold may take prices from 2 imported items, if the quantity ...

Added in the file attached a new version of GetImage procedure. If you don't want code to overwrite table formulas, then just remove those lines of...

Hi Brian, The stages are not uploaded to user form, I guess you just want to display a link to those files in the userform. Add a label with the fi...

That's where you had the printpreview line, made no change to that. Move it between Next j and Next i (between the 14 columns loop and the sheets l...

Philip Treacy said The authorization process for the API is quite complicated and I haven't been able to get it to work in PQ in Excel. You can us...

Hi, you can use their API: Based on their docs, you have to build your query, with Get data from web.

Hi Peter, Sorry for the late reply. Try this: Private Sub cboPrintBus_Click() Dim shData As Worksheet, shGroup As Worksheet Dim arrSh As Va...