Recent content by bball88555

That works like a charm. Thanks for your help. That open format was what I needed. I tried using the FileFormat:=wdFormatText instead of the one you supplied for me. Thanks again Josh

Let me try that. It looks great. Here is what I did in the mean time that added another step but it got rid of the prompt. I first copied the original file to the old file and then opened a regular word doc pasted the info in there and then saved it as an html page. However, I think your...

do you know how to use the sendkeys function with document.open. If there is a way to do this then when I open the file and the prompt comes up it will send the keystrokes to the prompt and continue. I don't know if this is possible. I have tried putting the code SendKeys "^{HOME}{ENTER}"...

Also, the information that I am copying is already in html format. I have all the <tags> already coded in so it is a direct copy and paste and no converion. I just need to save it as html not convert to html. I don't know if that will help you at all.

Sub CopyWord(ByVal NTGroupName As String) ThisWorkbook.Sheets("Sheet2").Range("A1:A200").Copy Set wdApp = New Word.Application With wdApp .Documents.Open Filename:="C:\My Documents\" & NTGroupName & "\index.html" .ActiveDocument.SaveAs Filename:="C:My...

It doesn't need word, I just used it because I thought it was the easiest way around. The data that I have is in one column on my excel sheet and the only thing that I am doing is copying that data over and pasting it in the open file. If I can figure a way to use notepad for this I could do...

Just a little clarification. The code executes the open command and opens the html file then it prompts me to select how the file should be opened Plain text, RTF, HTML, etc. then does the SaveAs and closes the file. Then when the code opens the file again it prompts for the same question and...

I open the first file, do a saveas and rename it, just to create a copy. Then I open the original file and clear some of the contents then copy and paste a selection from one of the excel worksheets. This sequence is repeated numerous times for different groups. I hope this helps

I am trying to open html files with a macro from excel. Currently, I am opening the file with word.application and this is causing the word file converter to pop up each time I open a file. I am opening numerouse files so this is not wanted. I am wondering if anyone know how to do this...