Method 2 worked:
Type: Posts; User: MartinM; Keyword(s):
Method 2 worked:
I didn't think I had made any changes, but an icon labelled Recent Places has just appeared on my Desktop.
I don't want it, so I right-clicked to delete it. However the only options which come up...
As ever I've learned something new on the way. From my web research I am beginning to suspect that this is a quirk of 64 bit Windows 7.
Thanks again Maud - innovative as ever !
I wish I could post the URL, but I can't. However it is not a direct file reference. It ends in .aspx?ID=nnnn - I don't know how this works, but it...
It has seemed to make no difference which method I used to get the download. I tried Maud's code and the line below: I was just working on the latter for simplicity's sake - both seemed to give the...
None of Paul's and Maud's suggestions close the IE window.
I thought this might be because Chrome is my default browser, but if I make IE the default the window still doesn't close.
Getting closer :o
The code to open the browser and wait until the download is complete works beautifully, no mattere hhow slow my connection happens to - thanks for that.
But . . . the browser...
Thanks very much Maud - I will be able to work on that later this evening.
Meantime, the earlier method didn't fail due to the length of the pause - I tried it at 20 seconds and watched it...
I had wondered about the timing issue.
Your code nearly works !
Instead of the Excel window appearing, it flashes in the Taskbar, craving attention but still hiding from me :(
Your assumption is correct.
The file is fetched correctly and put in the browser's default location, where I can use it.
I believe I have the API reference and the call in the...
Thanks Maud - but that code doesn't seems to do anything !
Where might I have gone wrong - what can I check ?
Thanks Paul, that's a big step forward.
I changed the Browser settings not to prompt for the download location and the ActiveWorkbook.FollowHyperlink "http://<file location>" works just fine,...
I have an update process which downloads a file using the command ActiveWorkbook.FollowHyperlink "http://<file location>".
This resulted in a .aspx file being opened on my PC, and I took the rest...
Unlike those who, lemming-like it seems to me, rush to install the latest thing no matter what state it is in, I can see no advantage for me in W10 - and plenty of issues.
When my applications and...
Thanks Bruce - I hadn't realised the consequences of using Libraries :mellow:
If I change the properties (such as the sort order, of the type of display eg list, icons etc) in one folder, all my folders follow suit.
That isn't what I want and isn't what I expected. Is there...
Thanks both - good advice.
It was having to use Safe Mode without a mouse that was particularly difficult. I was surprised that it didn't work.
I am away from home, from image backups and all that.
My fairly new Dell Windows 7 laptop appeared to start Windows (the Dell logo then the Windows startup graphics) but then just sat at a blank...
I am not sure I understand your precise configuration and how the users work, but does this help ?
I don't know the answer, but would recommend that you clear out the Properties of a Word document before posting it to the Internet.
I would have PM'd you but you've disabled that :(
Me too :(
it would be MUCH easier to point the validation list at a named range then use VBA to define / redefine that named range.
Doing so once will then be picked up in all the validations that use it.
Enlightening and amusing.
I hate to correct Zeddy, the all-knowing one, but you can do everything in VBA except get it to report when the internal colour of a cell changes.
For those for whom the only data in the world is...
Last Excel in Paris with Module Brando and Macro Schneider :rolleyes: