×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Attachemate Macros To Excel & Back To Attachmate

Attachemate Macros To Excel & Back To Attachmate

Attachemate Macros To Excel & Back To Attachmate

(OP)
Hey guys,

I'm using Attachmate's Reflection for the Web 2008. I export one of my macros to a TXT file and opened it in Excel. I replaced part of the macros with formulas to auto-calculate from another sheet. I then save the TXT file and re-import it back into Reflection for the Web 2008. After trying to re-import, I get an error. Also, I notice that formatting (tabs) is different from when I exported and when I imported. Is there an easy fix?

RE: Attachemate Macros To Excel & Back To Attachmate

hi,

Quote:

I then save the TXT file
Save the excel as a .PRN text file

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Attachemate Macros To Excel & Back To Attachmate

(OP)
That doesn't seem to fix the issue. When I try to import the macro, I get the following error:
'An error occured while trying to import the macro.'

RE: Attachemate Macros To Excel & Back To Attachmate

Why would you be importing a macro?

Are you not importing DATA?

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Attachemate Macros To Excel & Back To Attachmate

(OP)
Here is what I'm doing:

We have a process in Reflection for the Web 2008 that is lengthy and the process is dependant on information in an excel file we receive. I made a macros of the process and exported it (came out as a TXT file) and I opened it in Excel. I created a ton of formulas in the macro that gathered all the needed information from the excel file. I then resave the txt file and import it back into Reflection for the Web 2008 to run it (cutting down the actual process time by a LOT).

RE: Attachemate Macros To Excel & Back To Attachmate

was there a question or clarification of a questiom in there?

Please post the macro that you are importing and explain the method of performing this import/

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Attachemate Macros To Excel & Back To Attachmate

My guess is opening the macro file in excel has added some formating the compiler doesn't like when your trying to open the modified macro file. There could be other formatting issues beyond just the change to tabbing your seeing. Maybe try opening a new macro and then cut and pasting the code from the .txt file in to see if it clears up and compiles? May even be a syntax difference between the excel formula and the language your macro is in?

Sometimes you gotta leave your zone of safety. You have to manufacture Inspirado. You gotta get out of the apartment. You've got to run with the wolves. You've got to dive into the ocean and fight with the sharks. Or just treat yourself to a delicious hot fudge sundae........ with nuts. - Jack Black

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close