@If

[Jafwiz]

I am not very good at Excel and this Forum has helped me in the past so i am asking another question. I have a file that is created automatically for our Bar Code software and i have to modify the file before i can use it. It has a column with a cost and every cell has a different cost. Some of the cells need to be modified. Example If the cell says $8.99 I need it to be $9.99. The dollar signs do not show on the sheet just shows 8.99. I know there must be a way to do this faster than one cell at a time copy and paste.

 

[Jafwiz]

Here is what happened. I created the price file and i copied and pasted your script went to save as changed to macro enabled then Alt Q to close. Tried to use it it asked where the file was found it ran it worked fine. When i close everything and i open the price file when i use it i get an error says security settings macro have been disabled to run macros you need to reopen this workbook and choose enable macros? How do i do that

 

[Joe4]

Here is what happened. I created the price file and i copied and pasted your script went to save as changed to macro enabled then Alt Q to close. Tried to use it it asked where the file was found it ran it worked fine. When i close everything and i open the price file when i use it i get an error says security settings macro have been disabled to run macros you need to reopen this workbook and choose enable macros? How do i do that

It may depend on which version of Excel you have.
Do a Google Search on "Enable Macros in Excel 2016", changing "2016" to whatever version of Excel you are using, and you should see lots of articles showing you how to do this.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Jafwiz]

It may depend on which version of Excel you have.
Do a Google Search on "Enable Macros in Excel 2016", changing "2016" to whatever version of Excel you are using, and you should see lots of articles showing you how to do this.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I have 2019

 

[Joe4]

I have 2019

Very well. Did you follow my instructions in my last reply and get it corrected?

 

[Jafwiz]

Very well. Did you follow my instructions in my last reply and get it corrected?

I think i did i ran it on 2 file looks like they both did what you told it to. Thanks for all your help this Board is a Lifesaver

 

[Joe4]

You are welcome.
Glad I was able to help.

 

[Jafwiz]

You are welcome.
Glad I was able to help.

One quick question after the macro runs it say complete but the changed file does not open i have to got to the original location and open it is there a way to have it come on the screen after it's done?

 

[Joe4]

One quick question after the macro runs it say complete but the changed file does not open i have to got to the original location and open it is there a way to have it come on the screen after it's done?

I thought you wanted to re-save the file?

If you do not want it to close after re-saving it, then simply remove the line of VBA code that closes the file, specifically this one:

    datWB.Close

Note that I added lots of documentation to the code (all the text in green) so you can follow along what is happening each step of the way.

 

[Jafwiz]

Thanks again