vba & code

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

I have a worksheet that has multiple dropdowns. There is one column (B6:B35) that has several values in the dropdown but if a specific value is selected in one cell I need to force 3 other cells in the same row to be set to a specific value. Example If B6 is changed to "Cloud Provider", I need...

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

Hi, I have 3 worksheets in a workbook. Spreadsheets named EXCEL, PDF and CSV in the TEMPLATE workbook. ( different details on each tab). I want to save off the Excel tab as its own excel workbook and the name based on the value in B1. I would like to save to the C Drive in a folder called Macro...

Hello, I am trying to copy values from Columns R, W, X and Z from the Template (red pic) into columns A, B, C, D. I need a VBA to go through these columns until there is a blank row and then paste it into A,B,C as so it creates a nice list going down. I will need this code to continue multiple...

Is there a way to change the naming of the JPG from Capture.JPG to whatever text is in cell V3 and then .JPG?

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

Hi since i updated my code the error 70 "Permission Denied" keeps me from activating my search form. Const SEARCH_BLANK As String = "[BLANK]" Sub FilterData() Dim ws As Worksheet Dim i As Long Dim lastRow As Long Dim matchCriteria As Boolean ' Change "Sheet1" to the...

I am extremely new to VBA, so I hope that this is easy to do and I am just missing the obvious. I have code that defines a named range as the active row, and another that does the same for the active column. How to I combine the two into one sub so that I can automatically calculate active row...

I am new in learning Userform VBA code, I created a Userform having labels,textbox and multipage with ClsTabMenu,Module1 and Userform Codes but on clicking run to load on VBA home, it displayed Run-time error "91" Object Variable or With block variable not set find codes below clsTabMenu...

Dear, I have an excel file that have an expiration date, and I would like that when the date is -15 days before expiring it send an email automatically based on some cells information to the outlook email once the system logged in. I have add a code but it is not sending auto email and I have to...

Hello all I have the following VBA code Sub Create() Dim application If Not IsObject(application) Then Set SapGuiAuto = GetObject("SAPGUI") Set application = SapGuiAuto.GetScriptingEngine End If If Not IsObject(Connection) Then Set Connection =...

Hi I need help about vba macro, The thing is if any cell in column "c" has web link, it will be spared all other cells would be deleted (shift cells up) Just this is my required! Now I do know vba, but not that much to be able to write a code by myself so if any friend could help me here...

Hi all, Need an urgent solution to the below please, if possible. It is beyond my VBA capabilities. I have created a new Excel workbook and inserted a macro button name "Import NC Data". What I need the macro VBA code to do it to ask me to select / specify a specific folder (folder and...

Hello Everyone. I will truly appreciate your help. My aim is HTLM text from column A to be copied in column B as normal text, after each word "см" i would like a new line(enter) to be created. That operation should be done via VBA code. Many thanks in advance for your cooperation. AB1Copy...

I would like the following code to create a duplicate window, tile these windows vertically, follow the reference from the originally selected cell, then select this cell's referenced cell in the second window. Everything seems to be working correctly until the last line of code where it will...

Hello all! Hoping that someone could help me or even tell me if this is possible! First time poster but have been looking at posts in the forum for a long time! Column B - I have levels that have a code assigned to them based on column E, and column G are my expected results. If the level...

Hi Guys, I need your help, Please note I am trying to use the value from a Textbox (Have a formula an extract a cell value (number with format as percentage) to convert to integer or number in order to proceed with a condition to determine if the value is X1 < 0 , X1 > 0 or X1 = 0 (This part...

Hey everyone, I have a macro that checks to see if the excel file open is the latest version for my technicians. I am able to successfully check, download have it rename everything. But once I get to the Kill it gives me the good ol' You don't have permission to delete that error. I have posted...

Hi hopefully somebody can help. Using Conditional Formatting I've built a workbook which checks for a number in a series of columns on one worksheet and if it finds a it in a grid (named range 'Grid'), formats the cell to a particular colour. This works great, but I have 150 CFs so the whole...