TransferSpreadsheet

M

MimiSD

Is there a way for me to run the TransferSpreadsheet macro then have it
automatically pull up the file in excel once the data has been exported? I
like the way that OutputTo works but it only allows me to have one worksheet.
The transferSpreadsheet allows me to input two different worksheets in the
workbook. Do i need to do some VB coding in order to accomplish this? If
so, what code do i need?
 
S

Steve Schapel

Mimi,

You should be able to use a RunApp action in your macro, following the
TransferSpreadsheet, to open the Excel file.
 
M

MimiSD

I tried using the RunApp action and it gives me an error saying "Escalated
Issues can't invoke the application using RunApp action. The path to the
application is invalid, or a component of the application is missing. Check
the path in Windows Explorer or File Manager". I do have the correct file
typed in but it will still not accepting it.

In the command line i type in U:\Escalations\EscalatedIssues.xls, am i
typing in something wrong or missing something. If you could help that would
be wonderful.
 
M

MimiSD

I have actually got this issue figured out now, someone had the exact same
problem in the post right after mine. Thank you for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top