i have this 2 macro for excel to jpg convert and work perfectly , but my workbook have 10 sheets and i must repeat this code for every sheets . i need change these codes
macro a :
1-for do it for entire workbook automativally and with no question
2-every export jpg file name is same...
Firstly hope everyone is staying sfae.
I have a list of excel rows with cells like this:
Product ID: 3943, Product Qty: 1, Product SKU: LPFL-B, Product Name: Gloves Latex Powder Free Size Large (BLOSSOM), Product Weight: 0.0000, Product Variation Details: , Product Unit Price: 14.95...
I looked at a question posted in the forum which intrigued me to wonder if there is some way to abort the closing down of a workbook within the excel AutoMacro Auto_Close .
Something similar to setting the Cancel arg to True in the Workbook_BeforeClose event.
Any thoughts ?
I need a goal seek to run every single time the value in cell F1 does not equal zero. When this cell equals zero, that means my numbers tie, if it does not then I need to create a "plug value" to make that value in F1 equal zero. The cell that needs to change is cell D21.
I need some help please if possible, is anyone able to write a code for me? I've had a look around online but struggling to find anything that can do the trick for me.
I would like a script on excel to run when i receive a certain email in my inbox which goes to a specific folder. The...
I have a piece of code that runs and creates an output Excel sheet that currently has the run date as a suffix for the automatically generated file name. However, I now sometimes have to run this report multiple times in one day, which currently means overwriting the previously run...
Hello, im trying to trigger a macro from a barcode
im scanning bar codes
cell4: NEXT<------ this imput triggers a MACRO called newsheet()
is it possible?
Thanks in advance.
I'm really hoping someone can help me. I have searched and searched and I cannot find a solution that works for me.
Our network at work has an issue that when we share an excel file, if anyone on Windows 7 (most of us are on XP) opens the file, it will automatically unshare it.
I want to have each row on a spreadsheet lock when I'm finished filling in the information. Basically after the cell in the last column is populated, I want the row to lock to any further editing without a password. So far I've taken bits and pieces of code and tried to make it work for 1 line...
I have a .txt file from monitoring data.
it comes in following format
1) The data is in groups of 3 .. but comes as ONE string with commas.
2) 2nd number has a reference table for description in another Excel table
673 | RRRRR
I am having some trouble making a macro that adjusts a graph with a dual axis. I did some research and found one that only adjusts a normal x and y axis graph but I need one that can do both x and a secondary x-axis.
I have the sample document...
I was given the code below but I cannot make it work. Even I placed an x in the A1 cell of blankSheet, I can go to another sheet and make a minor change before blanksheet is again activated. I am using this as a form of protection for intruders. What am I missing? Could someone help me with this...