[Mcneilius]

Hi all

Excellent site! :up: I know I should check for duplicate queries, but couldn't find the search feature as I'm new here and this is my first ever post...

I have two files 'Expenses Analysis' and 'Expenses Form' whereby the user fills out his / her expenses in the analysis file and then transcribes the summary figures into the form on other file, which is then sent off to the finance department.

I've created a simple macro that transcribes the figures between the files when they are both open, but I want it to be clever (=more fool proof) than that. I would like to embed the Expenses Form file into the analysis file, and get the macro to launch the file and enter the figures in one go. (I need to do it this way, rather than combine the functionality, as the Expenses Form is owned by another department and I can't unprotect it etc... ).

Sounds very simple, but I've trouble finding resources on it, as it seems people misuse this functionality for viruses and the like :down: . If another could help me, I'd be much obliged!

I would like to find a way of launching Expenses Form from the Expenses Analysis file, bearing in mind that both files contain macros and a security warning pops up in between.

Kind regards

Neil

 

[Rollin_Again]

What application are you using? Can you post some sample files?

Rollin

 

[Mcneilius]

Hi, thanks for your reply...

Application is Excel XP Pro running on Windows XP Pro.

Will try to upload the files, but need to 'cleanse' them a little for company specific info, etc...

 

[The Villan]

Neil
As you haven't posted your details yet, I just thought that the following may be a possibilty for opening the files in one go. Not a lot of people use this feature. Not sure if it will help.

Save workbooks in an arranged workspace
When you open a workspace file, Microsoft Excel opens each workbook saved in the workspace.

Open the workbooks you want to save in a workspace.
Size and arrange the workbook windows as you want them to appear when you open the workspace.
On the File menu, click Save Workspace.
In the File name box, type a name for the workspace file.
Tip

To open the workbooks each time you start Excel, save the workspace file in the XLStart folder in your Excel folder. Save only the workspace file, not the workbook files, in the XLStart folder.

The macro can run once loaded.

Its also assuming the file names and location will always be the same.

Les