Registro de archivos Excel en el inicio de Excel

¿Por qué cuando se abren y cierran archivos de Excel desde una macro no quedan registrados en la apertura de Excel esos archivos?

Como hacer para que cuando uno o varios archivos se abran desde una macro queden registrados como usados en la apertura de Excel

1 respuesta

Respuesta
2

La propiedad AddToMRU en el link que te paso que tiene la ayuda del método Open

https://docs.microsoft.com/es-es/office/vba/api/excel.workbooks.open?f1url=%3FappId%3DDev11IDEF1%26l%3Des-ES%26k%3Dk(vbaxl10.chm203082);k(TargetFrameworkMoniker-Office.Version%3Dv16)%26rd%3Dtrue 

No funciona

Tampoco funciona la macro que viene en esa página web

¿Qué instrucción usas para abrir el archivo?

Utilizo este código para abrir los archivos Excel

Workbooks.Open Filename:="D:\Archivos\Excel dia\1_I+G 2021 cambios.xlsm"

Pues según la ayuda tendrías que poner 

Workbooks.Open Filename:="D:\Archivos\Excel dia\1_I+G 2021 cambios.xlsm", AddToMRU:=True

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas

Cómo habilitar o deshabilitar (25) Grupo de opciones en formulario access

Tengo varias encuestas, cada una contiene de 5 a 30 preguntas y un formulario para llenado con 30 marcos de opciones numerados del 1 al 30. ¿Cómo podría habilitar o deshabilitar estos grupos de opciones de acuerdo al número de preguntas? Ejemplo:...
3 respuestas

How Much it Cost to Develop a Health App?

In today’s world, just having a great business strategy and big ideas are not enough to achieve success. Then what else is required? Well, we are living in the digital world. If your prospective consumers cannot access your brand on their smartphone,...
16 respuestas

Ost to pst freeware software

Stella ost to pst freeware converter software is the excellent software to recover all ost mailbox items in to pst file this software is convert all ost mailbox items like emails items, contacts items, calendars items, task items, notes items and...
11 respuestas

OST to PST Converter Software

InQuit Outlook OST to PST Converter is known for the best email conversion software that quickly convert single or multiple OST files into PST file along with all the mailbox items including – calendars, emails, notes, contacts, attachments, drafts,...
15 respuestas

Great OST to PST Converter Program

ATS OST to PST Converter Tool is the ordinarily protected tool and error-free conversion tool. This tool is great to convert various OST data to PST. It assists to export OST data to EML, and MSG formats. This tool support OS Windows’s arrangement...
12 respuestas

Benefits of Wearing a Silk Robe

There are many benefits to wearing a silk robe, including the fact that silk is a natural fabric that is gentle on the skin, silk is a luxurious fabric that feels great to wear, and silk robes can be worn in a variety of ways. Lightweight and...
3 respuestas

How can I get more youtube watch hrs?

YouTube watch hours are an important metric for everyone on the site! If you’re a YouTube star, or just want to make sure that your video is generating a positive ROI, it’s important to understand the different ways to measure this information.
5 respuestas

What are the benefits of home health care?

¿What are the benefits of home health care? All healthcare is potentially beneficial. But healthcare really needs to be viewed as a whole. There are times when home healthcare is suitable and others where it isn’t. It should be viewed as one of the...
21 respuestas

How Dissertation writer works for you?

¿What is the turnaround time? We understand that most students usually work under tight deadlines. That's why we've chosen sites with quick turnaround times for dissertation, from less than three hours to others that can complete a standard...
8 respuestas

How can I run an IoT enabled business?

Think of an idea in that fast-growing space. Don’t think too hard, and definitely don’t let procrastination slow you down because your idea won’t work anyway.
6 respuestas