I am trying to do the following:
I have a part numbers listed in Column A. Based on how the part number starts, I want to categorize it appropriately.
Based on the following:
A1 = has part # (PLM123-ABC)
I want B1 to return 1 (for the category)
A2 = has part # (ABC-123-XYZ)
I have the following code that works.
Sub sbVBA_To Open_Workbook()
Dim wb As Workbook
Set wb = Workbooks.Open("C:\Users\testuser\Desktop\export\order1.xls")
My question is... can the current vb code be changed to accommodate any file name?
Meaning I will export one file to the...
Hopefully this is simple.
I have a file. text.xls... tab name is sheet1, I want to print just one page.
I want it to default to do this everytime. Can I add VB code to do this?
Seems like anything I do on the print screen, is not saved the next time I open it up.
I am in an internship in a company, I was offered a job in VBA that I am not able to do, the project's goal is to take a print of all forms of the application and export them to PDF with the data that I was inserting throughout the process and insert those forms in a folder whose name would be...
I currently have this, but don't know how to add it to sum by both colour and another column. Assuming the numbers are all coloured by their status, I need to sum based on that as well as the category in column A - how do I adjust the VBA code below to allow for that?
We are looking to move a certain important document to Google Sheets which contains a hideous amount of VBA for the macros within it, in order to simplify things (they search for very certain information across various ranges of data)...
hello. i have the following code that is working. the only issue i have is that the template file grows in size and gets too large...as my process loops.
i simply want to add code to open, save and close the template file.
here is the code...
I currently have a working vb script in access.
1. Takes a template.. abc.xls
2. opens up the template
3. exports customer data into particular tabs within the template
4. saves and renames the template according to the customer name
5. script then picks the next customer and repeats...
Hello, I'm new here but I have used this forum quite a bit.
I currently have module that calls to the below code any time a cell is is changed in a sheet. It takes a little bit of time to execute the code, a fraction of a second maybe, which is too much for what I'm doing. Is there any way to...
I have an excel macro that loops through table body cells on each worksheet and inserts a cell formula using a combination of text strings. There are three worksheets.
The macro works fine on worksheet 1 and 3, but on worksheet 2, the macro errors out with an application-defined or...
I have never coded in visual basic before. I am trying to create a macro that will graph a ton of data. I made a quick program using the "record" function, then tried to mess with it to get the rest of the data graphed.
This is what I have come up with so far:
I have a column of numbers (in percentages) which is a part of a pivot table. I need to color code this column as follows:
- Percentages above 95% "Good"
- Percentages >= 90% and lower than 95% "Neutral"
- Percentages < 90% "Bad"
I would like to use Excel Styles for colors.
I have written...
I am trying to do the following in VB.
Reference a cell to a IF & Vlookup statement.
Here is what I have currently.
Z is a variable that works...data can range from line 6 to line 1000.
Private Sub Reset_Pricing_Click()
(works) For Z = 6 To 1000
Basically, looking for a start point with this project and what would be the most effective way of achieving it.
I've attached an image of the outcome I'd like to achieve.
I'll have a print out of all these barcodes and what I want to occur is that when I scan for example barcode 1 is it will...
Is there a way to create a collection of JSON Files in a folder based on the content of individual cells in a column in excel?
So basically, I have a spreadsheet with a column starting with cell B12 to B26. Each cell contains a JSON script. I want a VBA that would convert each of these cells...
Excel vba will not recognise that AutoFilter is enabled. However, it works on the initial sheet which the code is run from.
If ActiveSheet.AutoFilterMode Then
I have tried to use vba prior to the above code, to remove and re-add the...
Hi I have a json outfile that looks like this. As you can see both the name "data" occurs twice in the structre, and below "stages" each stage "ID" have the same name "ID" - I am trying to get all the different stage "id"s into 10 different colums (and then go through all objects to fill those...
Hi. I am running the following vb command from access 2013.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "123", "c:\test\test.xls", True
Access 2013 - Excel 2013
The table 123 is created but the external table is not in the expected format appears and when I click on debug...
I hope the title is accurate. Looking for a solution through Conditional Formatting for the following:
Values in cell L14 AND L15 change. (Both values in L14 & L15 shown to user of WB are a result of a formulas placed in those cells that draw from info somewhere else in the WB).
I am a big fan of this forum and have used it to solve many problems by searching through here (I only recently registered). I recently used a Macro created by hiker95 several years back. I am using this macro to sign in/out patients at my facility instead of a paper sign in/out...