Hi,

Is it possible to run MS from a USB stick, i think I remember in nthe distant past that it was possible!.

Thx,

John

Hi,

Thanks for the code. I am getting a type mismatch for 'FormatDateTime', any ideas?

Thx,

John

Hi,

Thx for the reply, all I need is the macro to loop through D7:D30, would the code be different as I am getting a few errors at the moment?.

Thx,

John

Hi Guys,

I have re-installed MS and it is now working fine, thanks for all your suggestions.

Thx,

John

Hi,
I have tried copying and pasting using
ctrl C and V as well as the normal copy and paste. I've tried copying from any other software to MS but it doesn't do it. If I copy and paste to anotherprogram it works fine!!.

Thx,

John

Hi,

I'm trying to copy and paste to the editor but it doesn't seem to work. I select what I want to paste, go into the editor and paste but nothing appears. Can anybody advise??. I'm on windows 8.1

Thx,

John

Hi,

Is it possible to take a time in a cell (00:02:30) for instance and change it to 2mins 30secs in a macro?

Also, is it possible to blank a cell where the time is 00:00:00?

Thx,

John

Having spent some time googling this I don't think personal.xls is opened by default when Excel is instantiated as COM object. Try opening personal.xls as well, e.g.: VBRun>OpenAndRun,C:\Users\User\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xlsb,TestMacro But I guess you might actually need t...

Try specifying the following for the macro name: PERSONAL.XLS!Name of your Macro here Hi Marcus, the code is below: BSTART Sub OpenAndRun(xlFileName, MacroName) Set xlApp = CreateObject("Excel.Application") xlApp.visible = true Set xlBook = xlApp.WorkBooks.Open(xlFileName) xlApp.Run(MacroName) End ...

Hi,

I have a macro saved to personal.xls but when I try to run it via a scheduler it says that the macro can't be found. Is there a problem with running macros in personal.xls?.

Thx,

John

Hi,

I've just encrypted a macro to see what it looked like. I then unticked the encrypt box but the script still looks encrypted. Any ideas?
Regards,

John

Thx Marcus - that works great!!

Yes it is possible. Use the ReadIniFile command to read the variable from the INI file. Replace the literal used in your WebRecorder code with the name of the variable. I have this at the beginning of the script: ReadIniFile>z:\websites login.ini,url,parm1,StrName Let>username=StrName THis is what ...

Hi,

I'm trying to insert a username as a variable into a webrecorder script but I can't get it to work, is this possible. The script works already but I would like the option of changing login details via an ini file?.

Thx,

John

Thx marcus - it works a treat.

John