Francesca has attended:
Excel VBA Intro Intermediate course
Excel macros
Is it possible to create a macro doing automatic updates of Excel files to be downloaded from the internet?
RE: Excel macros
Hi Francesca
Thanks for getting in touch. Good to hear from you.
It depends how the files are downloaded. Are they pulled from a secure location? Or is the data pulled into an existing spreadsheet?
Both are possible but it depends on any security in place.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Excel macros
Hi Gary,
many thanks for your prompt reply.
To answer your question, the files are publicly available in Excel format.
Best regards,
Francesca
RE: Excel macros
Hi Francesca
Thanks for your reply. Unfortunately with the setup you've described will be very hard to achieve in Excel VBA. File management of this sort is better handled by scripting languages such as PowerShell.
Sorry I couldn't be of more help.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
