Excel 2010 :: Hyperlinks With JPG Files Using Internet Explorer Do Not Show Pictures On Win7
Jan 26, 2013
In Excel 2007, Hyperlinks in cells pointing to jpg files in a subfolder display with internet explorer. On my WinXP/Intnernet Explorer 8/Office 2007 system these links work fine.
When sending the excel and jpg files to another person with Win7/Office 10, jpg hyperlinks work and launch Internet Explorer but come up blank. (Hyperlinks to PDF files work fine and show up in Acrobat, just the jpg's come up blank in Explorer.)
What is causing this, a setting in Explorer/Win7 or Excel?
Can I change Excel hyperlink default software to use something other than Explorer to display the jpg files?
I have been trying for some time to be able to download a file from what I believe to be a FTP site. There are three user input fields which I have been able to identify there names. After these fields are complete there is a button to push which I have also identified it's name.
Once the process of pushing this button is done, an unspecified amount of time must occur for data to be gathered and the option of Open, Save, or Canel appear in a Download window. I would then need to Save and Overwrite an existing file.
No Login or Password is required.
I have been able to automate the open of I.E. and input to the three select fields as well as the necessary button push.
However, I am unable to identify how to automatically save the file into a specified location, with overwrite privileges enabled. Below is my progress
I am trying to automate a website which I use for daily office related work. I am navigating the website, selecting some options and clicking on download button using vba code. When I click on download it opens a new internet page. Now I have to click one more hyperlink on that newly opened internet page. How to do that?
I have a macro that opens a web page, copies data from the page, then paste the data into a worksheet in excel. All that works just fine. however I cannot figure out how to close the connection to the web after I copy the data
I am trying to write VBA code which will go to a web site, SelectAll, make a Copy and then close the IE connection. In my code, Set objIE = CreateObject("InternetExplorer.Application") works, objIE.Navigate "https://www.whatever.com" works, and objIE.Visible = True works. What's the objIE code for "Select All" and "Copy" ? I can't seem to find any reference to these commands in the posts anywhere.
im working on a project that has exposed myself to something. I am familiar with navigating through many IE websites in VBA, but this one has me stumped. I have entered all my information via code, and now I need to progress to the next screen. Here is the button I need to click.
I am not sure if this can be done but I couldn't find it in the forum. I need a macro which will open a web page and on that page fill a search box with a value from cell A2 and click the search button. The macro I have now opens the webpage. I need the rest. The search box is like the one on google homepage, I mean when the webpage is opened, the cursor is automatically inside the search box.
Every day I gotta enter information in my work's website (intranet), however I dont know that much about manipulate with VBA the Internet Explorer application, for example once I enter information in the website, I gotta enter an ID after that I gotta select the date, then I gotta give some clicks in some checkboxes, then I copy some information from excel and enter that information in the navigator, and finally click on save. The thing is that I do not have access to that website in my home so is impossible for me to provide you with the link... what kind of codes do I need to do it, or where can I find a manual where I can learn to manipulate another application like the Internet explorer with VBA.
I have some problems with VBA. So the problem is that there is this page Page (if you want to get to this page with the program you have to write "Krateris" into the msgbox) and I want that the program would click the link in the first result or selected result
So this code is working just I need to expand it to get the result which I wrote above. I am writing this code in module not in worksheet.
Code: Sub test()
Dim btnInput As Object Dim IE As InternetExplorer
Set IE = CreateObject("InternetExplorer.Application") company = InputBox("write company name")
I have a VBA project that navigates to a website and then clicks on a link. When I click the link in my code a new IE Browser opens with a form that I wan to fill out. I know how to update the form, but I don't know how to reference the new browser window that was opened when I clicked on the link.
'Open End User Multiple Selection Set tags = myIE.document.getElementsByTagName("A") For Each tag In tags If InStr(1, tag, "'multiple_selections.htm','EndUser'", vbTextCompare) > 0 Then tag.Click Exit For End If Next when I try to reference the document in the popup window, it is still referencing the previous window. How can I set my "myIE" object to reference the new pop up window?
I have been searching for ages for a solution/reason to this problem. Either i am using the wrong search terms or the information is not out there. I have created an intranet type series of pages for the laboratory i work in. These pages contain information on current orders, chemical lists, stock lists etc. The vast majority of these lists are kept as excel spreadsheets.
The problem i am having is that when you open one of these sheets in internet explorer you can not always have acces to all the menus (format, data, insert etc). All you can get is file, goto, favorites and help. Sometimes you have full access to all the menus and other times you do not. Originally i thought this was due to a copy of the file being open on another computer already but this does not seem to be the case.
I want to create a macro to open a webpage, and with that webpage fill out the fields on the webpage and then hit enter and move to next record. I am having great difficulties with establishing Internet Explorer as my object and maneuvering around inside of it. My data would being in column A so i would expect to use the string below when referencing my data.
Do Until Workbooks(2).Worksheets(1). Range("A" & row) = ""
I have some code I'm running that works flawlessly when running it in excel. The problem arises when the generic user opens the file via a website I have running, if they chose to run the file in internet explorer rather than saving the file I get the following error:
runtime '1004' error application-defined or object-defined error
The problem occurs in this code:
Code: If Not Intersect(Target, Range("B2")) Is Nothing Then Load UserForm1 UserForm1.Show vbModeless
I have similar code for refreshing specific pages with the "RefreshAll" being changed to "RefreshTower1" for example and I run into the same error.
How to have a macro bring up a website (an internal document website) locate the correct frame uncheck a box, fill in a field with a cell value (from A2) click submit, jump to the next frame within the same website and click a link. my main problem is it looks as though there are nested frames and iframes which im not familiar with. since the website is internal and you wont be able to access it, i have taken snips of the website itself, along with snips of the html and posted them to photobucket. [URL] .......... if you look at the snip of the website the fields i need to be referenced or filled are...
in the frame "frameSearchCriteria" (which i believe is itself within an iframe) "My Loans Only" box unchecked (html name is "xMyContainers") "Loan Number" field filled with cell A2 (html name is "xObjectSearchValue") "Search" button clicked (html ID is "xSearchSubmit") after these steps have been taken it would then jump to the next frame "frameSearchResults" and would click the row (html name is "xRowClickAction")
I realize this would be difficult without access to the site, however the posted html and a snip of the website. heres two versions of code i have so far.
Code: Public Sub IE_Automation() Dim baseURL As String Dim IE As InternetExplorer Dim HTMLDoc As HTMLDocument Dim mainFrame As HTMLIFrame [Code] ....
Code: Sub Xdoc()
Dim oIE As InternetExplorer Dim HTMLDoc As HTMLDocument Dim frmCol As FramesCollection Dim HTMLFrame As HTMLDocument Dim htmlColl As Object Dim htmlInput As Object
I have used VBA in Excel to open IE, browse, capture web pages, etc. for several years. Now with Vista, IE 7, and Excel 2007 they no longer work. The createobject does create an IE window, but when using the .navigate method it opens a secondary window. The IE object is no longer accessible after the navigate is executed.
Sub GetKBArticles() Dim IE As Object Dim sURL As String Dim i As Integer
When selecting multiple excel files in explorer, you can right click and choose to print the selected documents. All documents gets opened and printed but the files stay open and you have to manually click on YES or NO to save the changes.
Is there a way not to see this window appear. So documents get opened and printed and closes itself without asking anything. Maybe it can be done with an option in the preferences. I'm not sure.
By the way the documents where created with excel vba just in case it's relevant. Also the version of Excel is an older version, I think it was Excel XP or 2002/2003.
Two months ago our employer seriously limited the size of our mailboxes. We are "forced" to store emails as msg files on our network. PST archives are not allowed. This naturally sucks, as in Explorer you only have the file names and dates to look for that one particular email amongst hundreds (thousands) of msg files. I was able to compose a program in Excel 2010 that generates a list of msg files from a selected folder, together with metadata (sender, receiver, etc.) and so on.
In a test the program worked fine with 6,710 msg files I could post the code here, but the comments and many of the variable names are in Dutch (I never expected it to work in the first place). There is one thing I would like to add to the program. Sometimes I want to add an email to a new email as an attachment. Nowadays I have to look for the right msg file in Explorer by hand, which is a pitty, because I have the paths and filenames in my worksheet. I can put that in a string variable and let VBA do the looking up.
But I don't know how. I would like to be able to let VBA look for the file in Explorer, select it and then stop. I could then drag and drop the selected msg file in my new email. But all my attempts to find example code end up with code that enables a user to select a file and immediately open it. That is one step too far for me. If the msg file is opened, I cannot add it to a new email as an attachment anymore.
I have a question with regards to a file on the internet hyperlinks, in which the file name (not the path) is subject to change. eg. [URL] to [URL]. is there a way to set the hyperlink in that if the filename changes slightly like the example that the hyperlink will still work?