SOLUTION below: Thanx to MJTNet support for solution // // This script exists to convert TEXT files located in the "Curent" folder to EXCEL // This cript focuses on SAP reports which are TEXTs and the deliminator is "|" // VBSTART Dim xlApp Dim xlBook Sub OpenXL(file) Set xlApp = CreateObject("Excel...

G'day, I'm trying: 1- Import a TEXT file 2- Convert the first column "Text -> Column 3- Save file as EXCEL. Below is the script that that currently have. I having problems with the VBA call... I KNOW I got something wrong with the VBA call to EXCEL but can't put my finger on it. Help would be apprec...

SOLVED - Used this macro within the PP document. ' --------------------------------------------------------------------- ' Copyright ©1999-2007, Shyam Pillai, All Rights Reserved. ' --------------------------------------------------------------------- ' You are free to use this code within your own...

G'day, This question is similar to " EXCEL: How to break all links before saving" http://www.mjtnet.com/usergroup/viewtopic.php?p=30570 I have PP with links and wish to BREAK all links before saving. Original file: My_PowerPoint_with_links New file: My_PowerPoint_without_links Thanx ... Michel PS: L...

Brilliant-!

Thanx JRL

This is a follow up question to a "LiveLink" query http://www.mjtnet.com/forum/viewtopic.php?t=6986 I have a shortcut icon of type .LNK on my desktop to a Livelink folder Right click properties on said shortcut I obtain something to the effect for "Target" Target : "L:\LiveLink system \Drop report h...

The properties of LiveLink Short cut is as follows: Target Type: Livelink/Livelink/Enterprise Workspace/Support... See image here: I'm able to copy files to standard folder.. but not to Livelink.. yet-! LiveLink is an OpenText repository. The reason LiveLink is used it is because it have version con...

Idea #2 - Brilliant-!

I just had the epiphany on idea #1

Merci JRL

G'day, How does one know when an MS Access Macro has completed-? To start a macro is as follows: http://www.mjtnet.com/usergroup/viewtopic.php?t=5283&view=next However, if for example I'm exporting a table to EXCEL file - I need to know when the export is completed before: - KillProcess>MSACCESS.EXE...

I have an official repository – Livelink ( http://www.opentext.com/2/global/products/products) I have an EXCEL or PDF file I wish to copy from PC to the LiveLink folder I have a SHORTCUT (.LNK file) to said Livelink folder In MAIN folder I have: My_EXCEL.xls Shortcut_to_Livelink.lnk I wish to copy...

Found it... after trail and error

Add a single quote after the BACKSLASH

From:
\\My Server\MY_folder


To:
\'\'My Server\'My_folder

G'day I'm sending an email to clients via outlook where in the body of the email the following would be common text: --------------------------------------------- Hello, You can find a copy of your report: \\Server_name\METRIC SYSTEM\Reports\Customer Experience \HRSC\Weekly Report Thank you. -------...

Brilliant-!

Thanx...

Brilliant.

Yep that did it...

Beginner's stumbling around.

Thanx.

I've open an EXCEL via the following command:

XLOpen>%PathFileName%,0,XLBookHandle

The EXCEL has several links.
What's the best way to BREAK all links and save file as
PathFileName_no_links

Thanx.
... Michel