Apologies,but this is a repost from excel section.
Think I need more specialised VB help
So I have the following bit of code (recorded with a macro)
Cells.Select
With ActiveWorkbook.PublishObjects(1)
.HtmlType = xlHtmlStatic
.Publish (False)
.AutoRepublish = False
End With
When this code is run it always saves the file as that given manually.
(.filename...which is hidden somewhere)?
I want to be able to name it with the file name extracted as a strfile in an earlier part of the code,but I have tried all sorts of samples from help file,and from earlier posts.
So far all have failed.
Any ideas how I can get it to accept the "strfile" as the save name pls
Think I need more specialised VB help
So I have the following bit of code (recorded with a macro)
Cells.Select
With ActiveWorkbook.PublishObjects(1)
.HtmlType = xlHtmlStatic
.Publish (False)
.AutoRepublish = False
End With
When this code is run it always saves the file as that given manually.
(.filename...which is hidden somewhere)?
I want to be able to name it with the file name extracted as a strfile in an earlier part of the code,but I have tried all sorts of samples from help file,and from earlier posts.
So far all have failed.
Any ideas how I can get it to accept the "strfile" as the save name pls
