Save workbook to 2 different locations macro and rename one of them

[Buns1976]

Good Morning Everyone,

I'm trying to come up with a macro that will save a workbook in two different locations.This workbook gets used ONCE per day so for example, the original file resides on the desktop and I want to save that as the original file "C:\Users\Leasburg Front Count\Desktop\LOTTERY.XLSB" .

The 2nd part of the equation is a little stickier. I want to save that as "C:\Users\Leasburg Front Count\Dropbox\LOTTERY BACKUP\LOTTERY.XLSB"
BUT not overwrite the file from the previous save so maybe it saves as LOTTERY.XLSB(2), LOTTERY.XLSB(3), etc or what would be even better is
if we could save it as the current date so something like this LOTTERY2-25-19.XLSB OR something similar to that.

Thank you!

 

[mumps]

Re: How to save workbook to 2 different locations macro and rename one of them

My pleasure.

 

[Buns1976]

Re: How to save workbook to 2 different locations macro and rename one of them

Hi Mumps,

What would be the best way to use a cell in a worksheet as a search box to search column E:F for a UPC?
I would want to have that search box in Row 1 and freeze that row so its always visible.
The search box would be populated by a scan of a UPC. Once the UPC is found in E:F, I would want it
to go to the cell.

Thanks

 

[mumps]

Re: How to save workbook to 2 different locations macro and rename one of them

@Buns1976
Since your question is entirely new and unrelated to the thread title, I think it would be best if you could start a new thread (according to Forum rules). This would allow all Forum members to respond and increase the chances of getting a working solution.

 

[Buns1976]

Re: How to save workbook to 2 different locations macro and rename one of them

OOOppss! I reposted. Sorry about that!