Ask a Question

get all the opened excel workbook names

SudhakarVE
New Contributor

get all the opened excel workbook names

Hi,

 

I'm trying to get all the opened excel workbooks names and save it in different location by save as.

 

The below VBA code does that but couldn't use it in test complete.

 

The VBA code

Dim wb as workbook

For each wb in Workbooks

 wb.name

wb.saveAs

Next 

 

Appreciate any suggestion/idea to retrieve those excel work book names in test complete.

 

Thanks in Advance.

Sudhakar

1 REPLY 1
DWalsh
Moderator

Hi Sudhakar

 

Please review the following community posting which will help answer your question 

 

http://community.smartbear.com/t5/Getting-Started-with/SaveAs-Excel-file/td-p/50173

 

Regards

Damien

cancel
Showing results for 
Search instead for 
Did you mean: