Jump to content
Macro Express Forums

Recommended Posts

Hi

 

I'm trying to save clipboard text to a variable but keep getting I/O error 105 no matter what kind of variable name I'm trying to use. Does anyone know what I/O error 105 stands for? I didn't think I was going to struggle with simple things like this when converting from ME3 to ME PRO. Where can I read about error codes? Can't seem to find anything in the Help section about it.

 

Regards.

 

PS. I must ask, I haven't had time to go to this forum the past two years, (I've been helping another company and introducing ME3 to them) but as I recall it was a totally different activity from Insight (Kevin and others)on this forum. What has happened? Are they too busy now a days? Pity, there help and the direct communication was the strenght of this program in my oppinion. Well, well, luckily maybe Cory, Paul, Joe and other brilliant guys can help us instead. :)

Link to post
Share on other sites

Welcome back. ISS doesn't contribute much anymore but I believe they do still monitor. Joe is super busy with his business and I don't think he has the time to hang out here much anymore.

 

This is really a support matter and you should contact ISS Support with this. And you might consider filing a bug report.

 

I see IO Error 32 quite often with files but never 105 or any other error with the clipboard. Can you create a simple macro that demonstrates the problem and post it for us to check out? I use the clipboard a lot and never have a problem. Could be some other program or utility causing a conflict. Might try booting to Safe Mode and disabling all other utilities and close all other applications and see if it happens in that case. If it doesn't start putting applications back until the problem returns.

 

Do you have any macros that are activated by clipboard contents? Might try disabling them.

 

BTW I suggest you change the MEP preference Activations > General > "Use the clipboard hook" to off if you are not in the habit of using clipboard contents for activation.

 

Make sure you are running the most recent version of MEP.

 

I think some applications conflict with MEP and the clipboard. Excel I often have problems with and I think RDPClip.exe, the facility used in Remote Desktop for clipboard transfer support, causes issues.

 

Ciao

Link to post
Share on other sites
Welcome back.
Thx Cory, it feels good to be here again. :)
ISS doesn't contribute much anymore but I believe they do still monitor.
It's a Pity. I think the hole idea with this forum is to discuss different matters and to first check with others if there is something that didn't get right in the script, before posting loads of issues and drowning Insight with things that really isn't support issues. I really hope that Insight would change their mind and turn their heads back and focusing on helping users (like myself) directly with their problems. When struggling sometimes under timepreassure, it has been a comfort to have ISS in this eminent forum. And what better way to sell the program, right?
BTW I suggest you change the MEP preference Activations > General > "Use the clipboard hook" to off if you are not in the habit of using clipboard contents for activation.
Thx for the tip, I'll try if it helps later on.
Make sure you are running the most recent version of MEP.
Check.
Can you create a simple macro that demonstrates the problem and post it for us to check out? I use the clipboard a lot and never have a problem. Could be some other program or utility causing a conflict.
The thing is that I'm trying to understand how this variable evaluation works and I was testing a bit, therefore I wanted to know what the error code was and maybe better understand what I'm doing wrong. I have to admit I don't understand how it works, I've read almost every post in this forum and the ME3 forum and still don't get it. I'm thinking of starting a new thread with my problem even if it has been up on the forum before, at least in the ME3 forum. But no exact way to do it has been presented.

What I'm trying to accomplish should be fairly simple.

In Excel: Copy a filtered cell and save clipboard into %T%N1%%, increase N1+1, jump down and take the next cell, do this repativly from prompt and after that it should be possible to write all the T out with text type into cells in another excel file that is filtered in the same way. Does it make any sence? If you Cory or anyone else for that matter could present me such a macro I could learn from that. Any response to my problem would be highly appreciated.

 

Regards.

+5°C, a bit windy today, the snow that fell has melted away.

Link to post
Share on other sites

I really hope that Insight would change their mind and turn their heads back and focusing on helping users (like myself) directly with their problems.

Have you even tried their support? Just because they do not post here does not mean they are not "focused on helping users directly with their problems." Their support seems very clear to me: Reporting bugs and requesting features.

 

Insight has been helpful whenever I have asked them for support. You should send them an email or call them.

Link to post
Share on other sites

I'm very busy at the moment with work so I can't spend much time here.

 

First off get out of the T habit. Name your variables. Le'ts call the T array %Cell% and the integer %N%, OK? Now first off your syntax is incorrect. A change from ME3. It should be %Cell(%N%)%. This may be the root of your error. Try that and get back to me.

 

While you're doing that I suggest copying the entire column at once. When Excel data is copied into a string var in MEP it's converted to a tab delimited format. Live CSV but with tabs. You can copy and entire column and use the Split command to break it into an array. You didn't mention any manipulation in between the copy and paste but i assume there is because there's no reason not to copy and paste the whole block from the one Excel to the other. So copy, split, manipulate, and paste back. Also if you use the array Join command you can join on CRLF and create an entire column which can be put on the clipboard and pasted in one go in Excel.

 

Finally advice I give to all people messing with Excel. People often use Excel because it's a handy grid for data. If you are not doing a lot of formulas save the files in CSV format instead. Now you can natively access them in MEP using the ASCII File Process and other means instead of using Excel which causes all kinds of problem including data corruption. It often tries to guess what you mean and messes things up. EG an account code "12-4" pasted gets converted to the date "12/4/2011". And you can still open the CSV in Excel and view and manipulate it's contents.

Link to post
Share on other sites

Have you even tried their support? Just because they do not post here does not mean they are not "focused on helping users directly with their problems." Their support seems very clear to me: Reporting bugs and requesting features.

 

Insight has been helpful whenever I have asked them for support. You should send them an email or call them.

 

I don't mean that ISS are not helpful, my point is that solving things "in public" like in this forum helps more people than one personal posted case to support. If you had been on this forum a couple years ago, you would have know what I mean. When ever I have any problem with my macros I intend to keep checking with this forum first and of course I will post it to support when it's necessary. It's not necessary for you to post comments on my subjects, ok?

 

Bye

Link to post
Share on other sites
First off get out of the T habit. Name your variables. Le'ts call the T array %Cell% and the integer %N%, OK? Now first off your syntax is incorrect. A change from ME3. It should be %Cell(%N%)%. This may be the root of your error. Try that and get back to me.

I used [%N%] instead of (%N1%) maybe this is it. I'll test it.

 

While you're doing that I suggest copying the entire column at once. When Excel data is copied into a string var in MEP it's converted to a tab delimited format. Live CSV but with tabs. You can copy and entire column and use the Split command to break it into an array. You didn't mention any manipulation in between the copy and paste but i assume there is because there's no reason not to copy and paste the whole block from the one Excel to the other. So copy, split, manipulate, and paste back. Also if you use the array Join command you can join on CRLF and create an entire column which can be put on the clipboard and pasted in one go in Excel.
Some good tips there! Actually there is no manipulation between copy and paste. I send out a bunch of sheets to different people and the problem is when copying from these sheets to a summative excel book and there is filtered rows it doesn't paste them in the right place, even though the files are filtered at the same way. That's when I come to think of trying this variable thing.

 

Finally advice I give to all people messing with Excel. People often use Excel because it's a handy grid for data. If you are not doing a lot of formulas save the files in CSV format instead. Now you can natively access them in MEP using the ASCII File Process and other means instead of using Excel which causes all kinds of problem including data corruption. It often tries to guess what you mean and messes things up. EG an account code "12-4" pasted gets converted to the date "12/4/2011". And you can still open the CSV in Excel and view and manipulate it's contents.
I'll keep that in mind. Thanks for you're help Cory.
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...