HP TRIM records Management VBA commands

[pauluk]

hi all,

Does any one know the VBA commands for HP TRIM records Management.

The company is currently using TRIM but i can't seem to find anything on the net or in other resources about vba commands for use.

When you use the save as command it brings up the TRIM dialog to enter the details for the file and which trim location to save it.

It would be useful if VBA could automate this process but at the moment I can't find a solution. Any help would be appreciated.


Thanks in advance.

Paul

[mojo249]

Paul

Not specifically but have you tried recording a macro? It might give you a starting point.

Dion

[snb]

Please tell us:

- the start situation
- the desired result

- what 'HP trim records management' performs.

And please post a sample workbook.

[Marcol]

This link any good to you?
HP TRIM - Specifications and Limitations

This bit doesn't sound to promising.

When Microsoft Excel is open with an HP TRIM add-in enabled, other applications will
have difficulty accessing Excel’s Save menu items.
Workaround: Close Excel.

[EDIT]
Here's another with some code examples
HP TRIM - COM SDK

[pauluk]

Please tell us:

- the start situation
- the desired result

- what 'HP trim records management' performs.

And please post a sample workbook.

EA sample workbook could be provided but it wouldn't be much use at it would not include the TRIM function as this ia 3rd party software that intergrates with excel. Therefore unless your had the same version of TRIM you would be unable to replicate my situtation.

As for what I wish to do, it is only knowing what if any commands there are for the TRIM SDK for VBA interaction.

[pauluk]

This link any good to you?
HP TRIM - Specifications and Limitations

This bit doesn't sound to promising.


[EDIT]
Here's another with some code examples
HP TRIM - COM SDK

Reading through the documentation you have linked there does seem some hope but however reading through the information has led me to the conclusion that it would cause more problems then benefit. Therefore it is probably wise to place this item of functionallity on the backburner for the time. I doubt that in the near future HP will add this function, as most record management is defunced in my opinion esp with the advent of better models such as CLOUD and other robust databases for the storage and access to records/files.

Thank you very much for taking the time out of your day to answer my query, it is as always greatly appreciated!!

Paul

[kadeo]

I wonder if there's been any movement on this in the years since it was originally posted.

My office is using TRIM too and, as is recommended, documents are stored according to an agreed naming convention. This means that the name of any documents being created by any of my code is predictable and as such should be determined by the code with no need for user input regarding that. Ordinarily, without TRIM, my code would just create a file and save it using the agreed naming convention and the user would not need to do anything further.

TRIM, however, has it's own SaveAs dialog (via HP TRIM Office AddIn). The default value for the document name in this dialog is the current filename of the document being saved, usually something like "Book1.xlsx".

I have created a workaround where my code saves the file locally using a name determined by the code following the naming convention and then when the user clicks "Save As", the TRIM SaveAs dialog will now have whatever filename my code came up with as the default value.

This isn't ideal for two reasons: 1- Saving the file locally first is totally missing the whole point of TRIM; 2- The user's drive space is left with the originally saved, code generated, local copy after they have saved their TRIM copy.

The way I see my problem, I'd be happy with either of these three solutions I think...
1- A way to name a workbook without saving it locally (or at all) so the TRIM SaveAs dialog shows the correct name.
2- A way to invoke and manipulate the TRIM SaveAs dialog using VBA (not very hopeful about that one).
3- A way to clean up any local files that are left behind after the user saves the file to TRIM.

Thanks guys