98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel macros
Excel macros
Resolved · Medium Priority · Version 2007
Tue 8 Oct 2013, 15:54Delegate Francesca said...
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?
Wed 9 Oct 2013, 09:29Trainer Gary said...
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
Wed 9 Oct 2013, 13:34Delegate Francesca said...
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
Wed 9 Oct 2013, 14:37Trainer Gary said...
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
Wed 16 Oct 2013: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
