ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   loop though numbers (https://www.excelbanter.com/excel-programming/417553-loop-though-numbers.html)

geebee

loop though numbers
 
hi,

i have code which clicks on a link.. .the only problem is sometimes the
exact link address is not known. for example, the following link works fine:

https://secure.secure.com/Transactio...0CH-20SENT.pdf

i did some testing and it looks lke the first part of the
"5005_46_16_AppServiceUser_20080923200402123_Z Z-2DRLSD-20CH-20SENT.pdf"
(meaning the "5005_46_16_AppServiceUser_200809" and the
"ZZ-2DRLSD-20CH-20SENT.pdf" part stay the same. But sometimes the
"23200402123" part is not known. is there anyway we can do a loop through
the different possibilities or somehting so that we can arrive at the
"23200402123" part? this wil lbe very useful when the exact filename is not
known.


thanks in advance,
geebee



All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com