Link to home
Start Free TrialLog in
Avatar of Quickstepbr
QuickstepbrFlag for Brazil

asked on

Automatacally save a Excel file with a specific name on Desktop

Hi  there.

I want a VBA code to save the WB in which it is running into my desktop without prompting  using following general format:

CD-"YY""MM"DD".xmls

Example for the file name:
CD-120104.XMLS

- The date for the files name should be get at sheet "Tabela" Cell "b1"
- The file name has to be the date of the day before to cell "b1"

Thanks in advance
Controle-de-devolu--es--em-branc.xls
Controle-de-devolu--es--em-branc.xlsm
ASKER CERTIFIED SOLUTION
Avatar of nutsch
nutsch
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Quickstepbr

ASKER

Perfect. Thank you very much.