Hello. It finaly worked with your help. But now i have another problem. I have other xls files but every each file has no sheet1 but the name of the xls file.
can anyone help me rebuiding the script bellow ?
thanks
Eg of sheetname: dealers0a26
Sub test()
Dim wb As Workbook
Dim sht As Worksheet
Dim r As Integer
Set sht = ActiveSheet 'sheet for results
r = 2...
tmorariu
Last Activity: Jun 15 '10, 04:57 PM
Joined: May 30 '10
Location:
-
if so, i am getting the text from a1 and not the url behind the text :)Leave a comment:
-
I mangaed with help to put on every excell file the link. Eevery link is at A1 cell of every file like this : Mylink ( and it is hyperlinked with the link )
I have the script bellow, I just need to complet it with that A1 in my final xls. Can you help me guys ? i am a newbie
Thanks
...Code:Sub test() Dim wb As Workbook Dim sht As Worksheet Dim r As Integer Set sht = ActiveSheet 'sheet for results
Leave a comment:
-
HTML files to XLS
I have 1800 html files wich i extracted from a website with HTTrack. In this files are some infos that i need to put in a xls file.
A friend of mine tried to help me but ( he knows programming and stuff ) but told me it is to difficult.
So i start google-ing and this is what i came up with.- I used a software for converting html files to xls.
- Searched this forum for a vb script and actualy worked very well. i have all
No activity results to display
Leave a comment: