I need a macro that copies macro from a webpage and run it once the workbook is opened

**emymeeky** · 03-30-2017, 02:17 PM

I have a workbook that I issue to my customers. Some of my customers request for a trial version before buying the workbook. Because of the loophole in relying on the current date/time in determining when a workbook expires, I'd like a macro which will open a webpage, copy a macro from the page and run it. Whenever I want the workbook to expire, I will simply update the webpage with a macro telling the user the workbook has expired. Sounds weird but I really would like to lay my hand on such code.
Thanks.

**Norie** · 03-30-2017, 02:23 PM

What would stop the user saving the code that's been downloaded?

**emymeeky** · 03-30-2017, 02:43 PM

The code will probably by downloaded to a hidden sheet where it will be called from. The workbook will be protected so the user won't have access to the code... That's my guess

**Norie** · 03-30-2017, 02:48 PM

So you would also need code to unprotect the workbook so you could write the code to it.

Also, the user would need to have their security settiings set to allow programmatic access to the VBE.

The first one is possible but for the second you would need to rely on the user.

**emymeeky** · 03-30-2017, 02:59 PM

Sure. I'll rely on the user. Moreover, since the workbook relies on the macro to function, the user has no option than to enable macro

I need a macro that copies macro from a webpage and run it once the workbook is opened

LinkBack

Thread Tools

Rate This Thread

Display

I need a macro that copies macro from a webpage and run it once the workbook is opened

Re: I need a macro that copies macro from a webpage and run it once the workbook is opened

Re: I need a macro that copies macro from a webpage and run it once the workbook is opened

Re: I need a macro that copies macro from a webpage and run it once the workbook is opened

Re: I need a macro that copies macro from a webpage and run it once the workbook is opened

Thread Information

Users Browsing this Thread

Similar Threads

macro that copies information from a worksheet from workbook A then opens a new workbook a

Use a macro to extract cell data from opened workbook to new opened workbook

Macro which opens workbook, runs macro, copies and then closes

Macro to copy first sheet from other non opened workbook - let user choose which workbook

Macro that copies data from one workbook to another

Button macro that copies and pastes data from workbook to workbook: Ranged Column Q?

[SOLVED] A Macro that Copies from Excel & Pastes into a webpage

Workbook copies itself when opened

Bookmarks

Bookmarks

Posting Permissions