amonaghan

Depending upon which version of MS Word you are using, you could try the method in my link to merge all the .doc files into one long file then Ctrl+A to select all then paste it into Excel from the clipboard. Depending on the contents of each original file of course. If there is more than 1 line of text in the original documents, they will be given more than one cell in Excel though.

Link here: https://support.microsoft.com/en-us/kb/2665750

I find it sometimes (randomly) hangs Windows Explorer under Windows 10 Home 64 bit. This requires stopping MX Pro and re-starting it.

I haven't reported this, as it is too random to find any likely cause. Incidentally, Windows 8.1 had the same behaviour.

I have an alphanumeric one too which will blow the mind.

Slightly off topic, but just to prove the point about proof reading:-

Terry,

You could try this. I haven't tried it yet myself yet.

http://www.mrexcel.com/forum/excel-questions/285128-st-nd-rd-th-format-date.html#post1400910

OR THIS

http://www.cpearson.com/excel/Ordinal.aspx

Good luck.

Alan Monaghan

Terry, an easier way would be to just change the format in Excel from 'dddd dd mmmm' to 'dddd d mmmm'. I use 2007, but assume this will work in 2000 too.

Alan

Caveat: I haven't supplied a bug report for this yet as I have some more testing to do before confirming that this is being caused by MEP.

Having received a shiny new Windows 8.1 PC, I transferred my copy of Macro Express Pro over to it.

After a little while I began to notice that the PC was hanging and unresponsive after opening File Explorer (formerly windows explorer NOT internet explorer).

I first noticed this while doing some music file editing using Windows Media Player 12. I would right click a track and select 'open file location' and after 2 or 3 times, I would be presented with a completely blank File Explorer with no left or right panes or ribbon along the top. Worse still, I was unable to access any other running program or taskbar items. The only course of action was to Ctrl-Alt-Del to reboot PC. After a few frustrating times, I decided to try selective start ups to isolate the program causing the problem. Unfortunately, it looks like it is MEP. When the issue happens now, opening Task Manager and forcing MEP to close returns the PC to its working state.

Has anyone else encountered this issue before I send in a bug report?

PS. I have uninstalled MEP for now to do more repeat testing, but so far, all is working correctly.

Subject Header is missing 'unresponsive'. Sorry!

I think you need to change the following line:-

Window Activate: Access*

with

Window Activate: *Access

or

Window Activate: Microsoft Access*

Likewise with your 'Wait for Window Title' line.

Regards

Alan

I did something similar to that Cory several years ago for lengthy work projects, but can't seem to be able to find it anymore, sadly.

That's odd. I haven't used Office 2010, but below comes straight from Excel 2007 help pages.

Can I customize the Ribbon?

The Ribbon, which is part of the Microsoft Office Fluent user interface, is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups that are collected together under tabs. Because each tab relates to a type of activity, such as writing or laying out a page, it is not possible to customize the Ribbon without using XML and programming code.

Things you can't do

Add to or rearrange the commands on the Ribbon

Change or remove a command or group on the Ribbon

Add tabs to the Ribbon, unless you use XML and programming code

Switch to the toolbars and menus from earlier versions of Microsoft Office

Things you can do

Minimize the Ribbon to make more space available on your screen

Move the Quick Access Toolbar to position it below or above the Ribbon

Customize the Quick Access Toolbar to add buttons that represent the commands that you frequently use

Use XML and programming code to extend the Fluent user interface by adding custom tabs, buttons, check boxes, or Dialog Box Launchers. For more information, go to the Microsoft Developer Network (MSDN).

It works fine (kills and restarts), but a DOS-ish window appears saying "Process ending "MacExp.exe" successful".

Is it possible to suppress that window?

 

Thank You

Alexandra

A quick search threw this up:-

http://www.winhelponline.com/blog/run-bat-files-invisibly-without-displaying-command-prompt/

I recently had to do a clean re-install of my Vista system and now have an issue. Previously I had a macro open up my online banking site using the 'Web Site' command, which would open up Internet Explorer then fill my details in to logon.

After the clean install, when I run the macro, Intenet Explorer remains flashing in the taskbar rather than taking focus and allowing text entry.

I doubt if this is a bug, so I thought I would try here to see if others have come across this issue and know of a workaround. I know I could use 'Launch ...' etc, but why has this stopped working?

You could try puting the following line before the Text Type commands -

<KEYSTROKE SPEED Delay="10"/>

A quick test of the following looked promising:

 

1. View Source to open a new window. (In Firefox I do that with Right click > View Page Source; in IE I think it's from the menu: View > Source.)

2. In that, search for a line beginning

/>

4. Remove the unwanted end tag.

5. Do whatever you want with the URL.

5. Activate your original page, which should be as you left it.

 

--

Terry, East Grinstead, UK

This looks like another possibility Terry. The problem is it is the login page to my personal banking, so capturing the URL and trying to download the HTML using Cory's method (VBScript) doesn't work. This is when issuing the URL the page returned is different from the original page (security reasons I'm sure).

This used to be easy in earlier versions of IE by using Search for text then a TAB would take you to where you wanted to be on that page. Then you could select text from that point on the page. Later versions don't seem to allow this sadly. So now I have to capture the whole source code and drill it down or do a CTRL+C of the page then drill that down. Oh well, I'm getting there.

Hello everyone!

I've been racking my brains and am all Googled out trying to find what should be very simple. How do you get the full current URL from the address bar and store it as a string variable? I know you can do an <ALT>+<D> followed by COPY but I don't want to navigate away from my current position in the page.

I assume this can be done using HTML / VB Script / JScript (I don't have Autoit installed)?

I've found some code examples on the net, but don't know how to impliment these into MEP. I have tried using Extenal Script, but so far it keeps coming up with syntax errors or hangs the macro.

Does anyone have a simple way of doing this and if so, how do I interface it with the External Script command?

Thanks in advance!

Speaking of Windows Scheduler, I would like to share with you my recent experience of its power...

 

My Windows XP HDD has started to develop "bad sector" just few days ago. I am lucky that I have 3 logical drives on that HDD and bad sector has not developed in C: drive where my Windows XP resites (that is why I can still boot up my Windows)

 

I actually confirm on its problem when I try to create an image backup using Norton Ghost (and I was warned about bad sector) that immediately explains to me why one of my Steam game keep having corrupted game files and required me to reload.

 

My plan is to brute-force a backup using Norton Ghost's -FRO -SURE switches then restore the my Windows XP to a new replacement.HDD. But before that I try to chkdsk /r on the logical drive where my Steam game resites (I hope it will reallocate as much as possible, data from the bad sector area before I backup). Almost as it always will, I was prompted to schedule the check because Chkdsk needs absolute access right while doing its task, I answer 'Yes' (so scheduled the HDD chkdsk... see what happen next)

 

Upon rebooting my WinXP, I notice my HDD indicator blinking intensively (chkdsk is working hard to find and reallocate bad sector data, I know it), and then wtfck, I got a blue screen with error: "c000021a unknow Hard error". i.e. chkdsk /r has triggered a blue screen ... the funny thing is, if I reboot my PC after seeing the blue screen, the same event sequence repeats (reboot-> Chkdsk/r -> blue screen),

 

My Goodness...I now can't even boot up my WinXP because Windows has scheduled to complete chkdsk/r on its next boot up, but that task can never be completed without triggering a blue screen in the mid. So, now what? Why me? $^$*638^%&$^#^ ...

 

Since I am posting in this forum again, as of this writing, sure, I have the above solved. But "how I solved the above" is not my intention of this message. My point is why can't Window scheduler just switch off the chkdsk /r task after it fails to complete in its very first try? Window scheduler is not that POWERFUL, right?

I think you are being a bit unfair on Windows Scheduler there though. If you read the following link it explains how chkdsk is fired up on startup.

Microsoft Support

Anyone know if there is there a command to move the cursor to a specific tray icon?

 

BTW: I'm on Windows 7.

Move Mouse to Tray Icon command works for me. I think it only works if the icon is visible though.

It is found under the Mouse commands.

Don't have Win7 here, but works on XP.

I have a few very simple macros that opens program and does some small things. Sometimes the program freeze and I get a windows that opens and it says *PIL * and a OK button to click. When I click that button Macro Express ends. Does anybody now whats the problem?

This may answer your question:-

See Here

Thanks for the welcome back Terry. I have been back for ages, only I was made redundant back in December, so have had other issues to deal with. Still not in work, but I am hopeful of something very soon. It’s just a pity I couldn’t convince my former employer of the value of the job I did, including massive time (cost) savings due to the use of ME3 then MEP.

Maybe I should have asked my local MP (Gordon Brown) to step in and stop the redundancies. - Oh well perhaps not then

Oh well! 'Onwards and Upwards', as they say.

Alan Monaghan

Kirkcaldy, Scotland

Terry,

Well I know I had several of my early posts deleted after having my account closed. This was after being wrongly mistaken for a spammer after posting to alert people of a spammed message. This may explain it.

Alan Monaghan

Kirkcaldy, Scotland

What I got to work was to resize the ME Pro Explorer window prior to File/Import operation. It still popped up the window beneath the Explorer window, but I was able to navigate to it and import my macros.

Alan, KDY

Sorry, about the double post but the forum software has changed a lot since my last reply post and I made a bit of a mess of things!! How do you delete a mistaken post?

Anyway, George.

I have experienced a similar problem in v3.7a.

When I import from a csv file into a databse using TYPE var it inexplicably changes the case of a random letter within one of the fields. This only appears to happen with data which is all UPPER case and it only seems to do it for one character in the field and it doesn't do it for every record (a handfull in every few thounsand).

I have also checked the integrity of the original data and it is definitely being changed. Given time, I will attempt to test to see if this is happening when reading from the file or when it is TYPEing it out.

Alan Monaghan

Im having a problem on a customers computer and im lost at where to start...

 

When I first installed these scripts on this guys computer all worked fine, then like a few weeks later this odd problem started happening it is xp and ie7

 

When macro express imports data from the clipboard and pastes it into the web into a form in ie7 it pastes exactly perfect

 

when the macro grabs the data from a .csv file and pastes it (about 10 variables) each one has the case changed the $ symbol for us dollars becomes 4 so its like someone is pressing the caps key for thes the first caracter of each variable, its odd...

 

The exact same script without modification works everywhere else but not on this guys computer, I even reinstalled the script again from scratch. verified the csv file looking at in in notepad... why is the first caracter of t1 t2 t3 variables changing... etc..

 

Thanks

 

George

Lars,

One way would be as follows:-

Go to Options / Preferences / Passwords / Password on Edit

Click on [Change]

If you haven't previously set this password, skip 'Old Password' field and enter

your chosen password in 'New Password' field then confirm it, then click on [OK]

Click on [Apply] then [OK]

You should now end this session of ME by going to File / Terminate Macro Express Editor and Player

When you next start ME it will prompt for a password.

Alan, Kirkcaldy, UK

Could you post the URL you are trying to access?

Alan