Import External Full HTML With A Variable URL Set By User?
Import External FULL HTML with a variable URL set by the user?
I'm trying to develop a help tool for my clients at work.
1) Web Query just doesn't seem to want to pull in pictures which are needed as visual references. Everything I have tried just doesn't make them appear into the spreadsheet through VB Programming.
2) The end of the URL that its retrieving the information has to be variable, user defined. Everything at work for error codes must beable to be typed in. With a list of over 10,000 I really don't want to have to create a specific web query for every single one.
The Web Server the information that its pulled from is a Static IP, and the normal Web Query works just with no pictures and lacks the functionality of the variable URL, so only one error is viewed.
The current VB I have on my work computer is 6.3, and Excel of Office XP (2002).
Thank you so much!
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Import External Data In Excel
i would like to import external data to excel, but i facing a problem which is if the colulmns involve "--- Test " that will display as "#NAME?" in excel column. how can solve for this problem? that is possible to solve??
[---- Test ----]
that will separate to 3 columns. which is
column 1 = " [--"
column 2 = " -- Test"
column 3 = " ----]"
that is no problem to display column 1 and 3 but column 2 will display as "#NAME?" how can i control it by coding??
Function For External Data Import Needed -- VBA
Hi all. I have recently been trying to update some logfiles that are commonly used to track data for how much work is processed in a given work area. At present, I have the data writing out to two separate CSV files, which will be feeding into two separate types of reports. What I really need to do now is to make it easy for the processors to get their production data simply by choosing their name and the date they need production data for. I have the form designed and correctly producing the filename string that I will need for importing the data, but the Workbooks.OpenText references that I have seen here are not what I want, because they open the CSV file in another workbook, which doesn't utilize the template that I actually have set up, which will "interpret" the data and give the end results to the requestor (which is all they will need at the end of their day). Few of the users will easily understand how to import the data manually; hence my inquiry here. Is there any easy way to accomplish this? I need to have this completed in about 8 hours, and I haven't slept yet, so the clock is ticking away. Any suggestions on what I need to do to accomplish this? I apologize if this is something simple that I am overlooking, but I have had to teach myself by experience (trial and error) most of the VBA that I know.
Import External Data Via Loop Macro Query
I have developed a macro to import data from another set of workbooks, to allow a comparison in one workbook, based upon cell references that loops until it hits a blank cell but have 2 problems I cannot fix as follows:
1. Data is copied into spreadsheet without any of the original formatting. I want to keep the items that are boldened, or bordered etc.
2. When I save the file as a template file the macro stops working and says it cannot find the destination file. I'm guessing this is due to it being a template and not an xls file????
Macro is as follows, any help much appreciated as I am so close!
B C D
1 Copy From WB
Copy From Range
Copy To WB
Copy To Range
2 f: esta.xls
f: estSummary.xls Sheet2!B1
3 f: est.xls
f: estSummary.xls Sheet2!C1
4 f: estc.xls
f: estSummary.xls Sheet2!D1
5 f: estd.xls
f: estSummary.xls Sheet2!E1
Const msParameterSheet As String = "Sheet1"
Const miWBFromCol As Integer = 1
Const miCopyFromCol As Integer = 2
Const miWBToCol As Integer = 3
Const miCopyToCol As Integer = 4
Dim bFail As Boolean
Dim lRow As Long
Dim rFrom As Range, rTo As Range
Dim sCurWB As String, sTargetWB As String, sPrevTargetWB As String
Dim sCopyFrom() As String, sCopyFromRange As String
Dim sCopyTo() As String, sCopyToRange As String
Dim sAdd1 As String, sAdd2 As String
Dim vaData As Variant
Dim wbTarget As Workbook
Dim wsParamSheet As Worksheet, wsCurFrom As Worksheet, wsCurTo As Worksheet
Set wsParamSheet = Sheets(msParameterSheet)
'-- Get last row of data --
lRow = wsParamSheet.Range("A" & Rows.Count).End(xlUp).Row
'-- Store parameters into array --
vaData = wsParamSheet.Range("A1:D" & lRow).Value
sPrevTargetWB = &H0
'loop thru data, ignoring row 1 --
Application.EnableEvents = False
For lRow = 2 To UBound(vaData, 1)
bFail = False
'-- Open target workbook if required --
sTargetWB = CStr(vaData(lRow, miWBToCol))
If LCase$(sTargetWB) <> sPrevTargetWB Then
sPrevTargetWB = LCase$(sTargetWB)
If Not (wbTarget Is Nothing) Then
.DisplayAlerts = False
.DisplayAlerts = True
On Error Resume Next
If Err.Number <> 0 Then
bFail = True
bFail = Err.Number <> 0
On Error GoTo 0
If bFail Then
MsgBox "Unable to open workbook " & sTargetWB
Set wbTarget = ActiveWorkbook
'-- Open 'Copy From' WB --
If bFail = False Then
sCurWB = CStr(vaData(lRow, miWBFromCol))
On Error Resume Next
Workbooks.Open Filename:=sCurWB, ReadOnly:=True
bFail = Err.Number <> 0
If bFail Then MsgBox "Failed to open " & sCurWB
'-- Process 'Copy From' Range --
If bFail = False Then
'-- Set worksheet & From Range
bFail = ProcessCopyRange(RangeDefinition:=CStr(vaData(lRow, miCopyFromCol)), _
If bFail Then MsgBox "'Copy From' field invalid for workbook " & sCurWB
'-- Process 'Copy To' Range --
If bFail = False Then
bFail = ProcessCopyRange(RangeDefinition:=CStr(vaData(lRow, miCopyToCol)), _
sCopyTo = Split(CStr(vaData(lRow, miCopyToCol)), "!")
bFail = UBound(sCopyTo) <> 1
If bFail Then MsgBox "'Copy To' field invalid for workbook " & sCurWB
If bFail = False Then
'-- Do the copy --
sAdd1 = Cells(rTo.Row, rTo.Column).Address
sAdd2 = Cells(rTo.Row + rFrom.Rows.Count - 1, _
rTo.Column + rFrom.Columns.Count - 1).Address
wsCurTo.Range(sAdd1, sAdd2).Value = rFrom.Value
Application.EnableEvents = True
Private Function ProcessCopyRange(ByVal RangeDefinition As String, _
ByVal WB As Workbook, _
ByRef WS As Worksheet, _
ByRef Rangex As Range) As Boolean
Dim bFail As Boolean
Dim saRangeDef() As String
saRangeDef = Split(RangeDefinition, "!")
Get Full User Name
What I want to do: Get the full user name of whoever is logged into the system. Already found an API that can get me the login name. I was using that up till a short while ago when I realised I was catering for a large amount of users and could not store the data in a table.
Setup: (mostly) Windows XP LAN which uses the full user name as part of its Outlook Global Address Book. Handy for sending mails around the place.
I did have a look around and found a long list of APIs but, please forgive me, I couldn't make head nor tail of them (esp since the code was posted without formatting) they kept going on with "pass in null for local machine" and that kind of stuff. Then there was a form load function with textboxes, whereas all I need is a string to stick in a global variable. Normally I can decipher and use code but this just confused me a lot.
Sorry if I'm asking a lot here but I'm thoroughly confuzzled - even a good link would be fine!!
Full Word Indexing Html Pages And Searching
im having trouble figuring out how to do this, i have a visual basic program that has a search function in it and i want it to search html pages based on what page the user selects to search for certain text also i want it to be able to search a index of all the html pages in the case that the user doesnt select a certain page. im having trouble with this for 1 i dont know a whole lot about visual basic yet, 2 i dont know how to index html pages into one big index and also i dont know how to make it search just one html page for certain words. any ideas or help on this would be very helpfull. sorry for the non-puncuated sentences by the way =)
Get Domain User Name (Full) How To?
I have a program that grabs the currently logged on user name but in the non-human readable format (say Joe Smith = JoeS or Jsmith) anyways - how can I grab the full name of the user?
Getting The Full Name Of The Current User Help!!!
I want to know if anyone can help with this problem:
i want to retrieve the current user's FULL NAME
for example jdoe would be "John Doe". i want to retrieve "John Doe".
is the answer windows NT4.0 / 2000 independent????
Get Computer User Full Name
Is there anybody here who knows how to get the current user name (full name: first name and last name) of a computer using VB 6.0 ( I'm doing this in MS Word and I'm using VB command button)? I know about VBA.Environ("username") but it only returns the log in name and not the full name.
I am using Windows XP, btw, but I also want it so that it works in other OS.
Import Table From Html
ok guys im lost here.
i have searched the forum and multiple websites.. and i still dont know how to do this...
i want to pull a table from a html file and use the cels to fill the array.
this is what i have sofar but it doesnt work...
Private Sub cmdDecode_Click()
Set y = WebBrowser1.document.getElementsByTag("table")(3)
For i = 0 To y.Rows.length
For j = 0 To y.Rows(i).cells.length
dataInCell1 = y.Rows.cells(j).innerHTML
Thanx in advance..
How Do I Import HTML File To VB6
ni want immediate help here,
does any1 know how to import an html filke to VB6 enterprise standard project and does it require any coding ?
i just want the page to be displayed no other manupulations.
pls reply ASAP
VB6: Full-Screen When User Maximizes
Hi; I'm rather new to Visual Basic, so I apologize if this is actually a trivial problem.
I have a form for which I'm looking to intercept all maximize requests and instead full-screen the form. (So if the user clicks on the maximize button, or selects maximize from the taskbar, or double-clicks on the top of the window, it full-screens instead of just maximizing.)
I've already figured out how to full screen the thing (using the borderStyle = none, windowState = maximized method).
I've tried writing an event-handler for the form's resize event, and then checking if it was maximized (and if it was, setting the borderStyle to none and repainting the form). But it didn't work and resulted in some funky behavior when the form was resized later.
Anyway, any help is appreciated, but please keep in mind that I'm a newbie and it may take me a while to understand some things (and will ask many more stupid questions ). Thanks!
Don't Let User Come Out Of Full Screen Mode...!
Can any one pls help......
(This is more of an IE Q.... But i want to impliment it in VB)
- I'm using IE 5 and above....
- Is there any way to not to let user come out of full screen mode (by pressing F11) ?
- I'v tried to find a regiestry solution but only thing i found is the other way arround :
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftInternet ExplorerRestrictions -> NoTheaterMode (1)
- but now i'v thought of launching the browser with only the title bar & am trying to execute the following html page:
- The prob i'm having now is that it asks for confirmation to close the current html browser(it says in scripting manual that it shouldn't if the current page is the only page it has loaded)
- 1) any idea how I can avoid this confirmation dialog... ?
2) Or Any way i can restrict user frm comming out of full screen by pressing F11 ?
GEtting Access To Import A PHP /html Table
I have been monitoring a table on a webpage using access 2000 and xp - but the originator of the webpage has changed the system to PHP.
When i try and link access to the page i get the following error message:
title:link html wizard
info:Cannot update. Database or Object is read-only.
I only want to link to it to import it to analyse the changes.
I have managed a very convoluted automated work around in excel where i can open the file in excel, trim it, save it as html or xls locally, and then have access link to it.
can anybody help me with a more elegant solution?
Is it possible to contol IE, open the page and save it locally as html? which access can then be linked to ( i can do the linking bit)
Get User Full Name By WinAPI Or Registry Reading
I can get the current user id by reading through the registry or using the GetUserName API call. What i want is to be able to get the full user name based on this userid either by searching the registry or by using winapi calls. Can any one offer me some help pls.
Variable Import To 2nd Form?
Is it possible to load a variable into a second opened form?
I make a variable into form1 witch can be turned on and off (AAN=0 or AAN=1).
When oping a second form I want the variable to go with it (choise in form1).
Can anybody help me out?
Capturing An External Variable
This is a very novice question, I am trying to capture the environmentvariable %username% and do a case statement on it, the following is whatI am doing right now, can you tell me where I am going wrong ? guess thequestion is how Do I capture the external Var as an argument ?
On Error Resume Next
Set Userid="WScript.Echo %username%"
Select Case UserId
WScript.Echo "PinNum = " & PinNum
Thanks a lot
Variable External Reference?
say i have an external reference such as 'file1'!a1
i want to make it variable such as: $A$3!a1 where A3 contains the file name
so that i can change the file which this command accesses from within the
Save Webpage Locally/ Import Html Using Vb
is anybody who can help me with this one:
using VB in Access i want to save locally a webpage (html) in order to import it in a table. or can i import it directly from the website? but i need to do that in VB in order not to be a manual process..
Send Variables From Html To External File
I'm new to VBscript and I'm having problems.
I want to make a flash sniffer, but I'm having trouble sending variables from my html file to an external vbscript file (I want to have a generic vbscript that can be used by different files with different vairables).
This is my html:
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<script type="text/vbscript" src="vbflash.vbs"></script>
And vbflash.vbs processes the information, but when I try to run it, I get an error message (unterminated statement, or smething like that...
I've also tried to put the variables inside the script tags, but then I don't get the error message, but nothing happens...
This is the script:
//check for Flash Player X
//script for IE on Win32 systems
on error resume next
checkForFlash6 = (IsObject(CreateObject("ShockwaveFlash.ShockwaveFlash."& version)))
if checkForFlash6 = true then
document.write("<object data="""&file&""" classid=""clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"" type=""application/x-shockwave-flash"" codebase="""&dir&""" width="""&w&""" height="""&h&"""><param name=""movie"" value="""&dir&"/"&file&""" /><param name=""menu"" value=""false"" /><param name=""quality"" value=""high"" /><param name=""bgcolor"" value="""&color&""" /></object>")
document.write("<a href="""&alturl&"""><img src="""&altimage&""" alt=""Sorry, no flash for you!"" /></a> ")
How To Get The FULL USERNAME For A Logged On User For Example John Doe, Not DoeJ
I am working on a program that will write data to text file that will be imported into a Lotus Notes database but the record must contain the user's first and last name. I am able to find the username in NT but not the first and last. Please, does anyone know how to achieve this. I have been trying for days and is unlucky..Please help.
External Data Source Via Ms Query Variable Sql
I use excel as a front-end reporting tool hitting an external data source - passing sql through ms query. I set up a refresh macro which refreshes the data from the external data source then refreshes the pivot table (I know that you could hit a data source with results going the pivot table, but I have formulas that are filled down adjacent to the incoming data). What I would like to do is push the refresh button and have a form popup asking for criteria that would be passed into the ms query sql criteria of the where statement. I know how the form stuff and variables, but I can't seem to see where the sql is stored (it must be with the workbook, because I can save the sheet and open it on another computer and hit refresh and it works. So if I could understand where the sql is stored I think I could change it. Can anyone help....
Passing A Variable To An External Batch Program.
Is there a way to pass a variable to external batch program? For example, I am trying to copy a file on a remote computer that will most likely be in use when I try to copy it, so the FileCopy function will not work. However, I can copy the file(s) using a standard copy or xcopy command through DOS. Is there a way to pass the variable IP$ to the batch program so it knows where to copy?
Preventing User From Using ALT+TAB From An External App
would you know how to prevent a user from doing this?
Basically: I have a VB app that launches an external app. I can get the handle of the new app. The new app is launched full screen. I would like to prevent the user from either:
1) use Alt Tab to switch to an other app
2) allow it but then launch a msgBox asking user if he would like to exit the app
3) Allow it but perform a couple of internal function and be informed when user comes back to the app again.
Any idea for 1) , 2) or 3)?
Project As Variable? Or How To Call External Functions From ActiveX Plugin
I wore ActiveX plugin for my project and i would like to use functions from main app in it.
Simplyest way i could think is somehow to pass Project1 (project name) and then use Project1.Module1.function()
Anyone got any ideas how to use main app's function in ActiveX plugin?
Btw. i know i can pass form and then use Form.Function() but i don't want to put all my functions on form
Checking If User Exists On An External Database
Hi, I am basically looking for the simplist way for a user to enter their name in a textbox and for that to be looked up on a database over a LAN. I have been looking at ADO and can do this for a database on the local machine but am stuck as to how this could be achieved over a LAN. I would love to see some code snippets on this subject too
Controlling External Application W/o User Input
I want to control an external application without the need of the user entering an input. Specifically, when i control the application "Save As" function, I do not want the dialog box to pop up as this will require a user entry before the program can proceed. I have used SendMessage to control this function by am unable to disable the Save As dialog from appearing. I want to control Save As and save files according to a specfic filename determined by my VB6 program. Any ideas how can this be done? Thanks.
Data Entries. User Input. Internal And External Output. Date Bases
Data entries. User input. Internal and External output. Date Bases
I am new to VB. Trying any way possible to learn about it.
I remember when I learned about HTML I have tried to have an application where it would contain INPUT BOXES.
I thought that CAR ownership could be a good way to make this data base.
1.I want to try having “owner’s name”, “manufacture”, “year”, “color”, “door”, “manual/auto”, “kilometre”, …
2.A submit button utilizing UDT (user define data type) and re-dimension array.
3.Each time someone press the “submit button” it should store all the information into a cell in the program. Using “procedure and/or function” (just to save time)
4.Also another button “PTF” (print to file). When it is pressed all information should be stored into an external text excel file/text file.
Note: I think this application should not repeat entries every time buttons are pressed. it should only enter the new info and/or changes into the file and the cells.
I belive this is the best way to learn, experience and exercise Visual Basic.
Code To Import User-defined Fields From Outlook/Task Yields Blank Records
A form was designed within Oulook/Task to record additional information on projects. I found VB code to take the user-defined fields of the form from Outlook to an Access database table. The code runs, but I get blank records in the table. Unfortunately, to make matters worse, the creator of the form used spaces within the user-defined field names AND I am a total novice with VB. Can anyone tell me why the following code yields blank records?
Option Compare Database
' This code is based in Microsoft Access.
' Set up DAO objects (uses existing "ProjectTracking" table)
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("ProjectTracking")
' Set up Outlook objects.
Dim ol As New Outlook.Application
Dim olns As Outlook.NameSpace
Dim tf As Outlook.MAPIFolder
Dim t As Outlook.TaskItem
Dim objItems As Outlook.Items
Dim Prop As Outlook.UserProperty
Set olns = ol.GetNamespace("MAPI")
Set tf = olns.GetDefaultFolder(olFolderTasks)
Set objItems = tf.Items
iNumTask = objItems.Count
If iNumTask <> 0 Then
For i = 1 To iNumTask
If TypeName(objItems(i)) = ("[IPM.Task.Official Project Tracking Form]") Then
Set t = objItems(i)
rst!CurriculumDeveloper = t.UserProperties("[Curriculum Developer]")
rst!ProjectTitle = t.UserProperties("[Project Title]")
rst!Status = t.UserProperties("Status")
rst!DueDate = t.UserProperties("[Due Date]")
rst!Task = t.UserProperties("Task")
rst!Notes = t.UserProperties("[Notes Text Box]")
MsgBox "No Tasks to export."
External Data - Import Data
Been looking follow threads and nothing looks like what i want.
All i want is to use the "Get External Data" - "Import" command through a command button using vb code.
So a user can select the file and type, the worksheet page, the column headings should always be used and import into the current table "Data" i was told to use the "AcCmdLinkedTable" command but i have know idea how to use this command. I thought it was just another - eg "DoCmd.LinkedTable" but its not.
Thanks for ya help
Loading HTML To A Variable
Does anyone has a start point for me?
I´d like to load the html code of a web page into a variable and then perform a seach on it.
VB Variable In HTML Code
My VB application has a segment of HTML code that includes a VB variable string (myStringVariable), how do I include this in the HTML code??
"<TD><B> Value <B></TD> <TD> myStringValue </TD>"
Writing An Html Variable
I am searching for a way to write a variable containing html code
Say I want a variable called mytext to contain:
<table cols = "3" width = "800" border = "0">
Can anyone tell me the right way to do this. I though I knew ie double quotation marks on those parts requiring quotes. But doesnt give correct html.
Any help appreciated
EVER HAD ONE OF THOSE DAYS WHEN YOU FEEL TOTALLY STUNNED
Well this is one for me. Solved the problem, had the right idea double quoting like border = ""0"". I had been getting the whole variable saved to the file in quotes however. Well the problem was I was using Write #1 to the file rather than Print #1, so naturally I got quotes around it.
Assign Html Value To Variable
i have a standard exe project.
i want to assign an input text field value (HTML text field) to a vb variable.
in other words-> on submit i want to pass value from one page to another
how can i do that?
thanks in advance
Read HTML From Variable
Hi, i need to put HTML code in a WebBrowser control from a string varible. How can i do this?
Is WebBrowser the only control for read HTML?
Activex Variable To Html Form
I've written a simple activeX that goes into my web page. What i want is for a variable in the activeX to be passed to one of the form fields on my web form. Does anyone know how to do this?
Loading A HTML Page Into A Variable?
How can I load an html page that is stored on my local harddrive into a variable? I tried using this code but it changes all the html into ???????????????????????????????? marks.
Do While stFile <> ""
intNum = FreeFile
Open (stDir & stFile) For Binary As #intNum
sholder = InputB(LOF(intNum), intNum)
HTML User Interface Help
Hi everyone, im fairly new to visual basic but a expert c++ programmer...
I was hoping one of you could point me in the right direction..
I've seen a lot of programs in visual basic with flashy user interfaces which are very well done.. They appear to be done using HTML..
An example of this is the following game
Looks to me like he is just using an HTML type interface... Any ideas on how to do this or any resources which would help me get started making a similar type interface for my applications? I've been searching for example code or projects like this to learn from but ive had no luck.. Dont know where to start..
Thanks in advance for help
HTML User Interface
I read an article once about developers starting to use HTML in their VB Apps for the user interfaces (Forms, etc.).
I can't remember where this article was. I have an HTML page with buttons, etc., and I have a WebBrowser Control on my VB form. I want my VB Application to respond to the button clicks on the HTML page. This article explained how, but I didn't need it at the time. Now, I do! Please help.
How To Pass Hidden Variable From HTML Email To A ASP Page?
I am creating an VB application where you create Purchase Orders, once the Purchase Order is created you have an option to send an email to the Vendor that a new Purchase Order has been created for them. I'm using CDONTS for emailing. I send the email in HTML format, with a link to a web page which is supposed to show the Vendor the Purchase Order.
My webpage that shows the Purchase Order on the web uses Request.Form so Vendors aren't able to type another PO Number at the end of the Querystring, and accidently look at another vendor's Purchase Order.
HOW do I make my web page to Request.form the HIDDEN VARIABLE in the HTML email? In other words how do I post my Hidden variables in the HTML email to my webpage that shows the PURCHASE ORDER.
I would appreciate all the Help
Good HTML User Group?
Does someone know of a good user group for web page writers? I need some advice for how to solve an issue with our web page setup, and I need to know of a good group.
Print HTML Without User Intervention
How can I print HTML to a file without User Intervention, this is that same as selecting "Print To File" then entering a filename.
I have looked at: http://msdn.microsoft.com/library/e...ml/wb_print.asp
wb_print03 - Visual C source
wb_print04 - VB example using above control
But it's locks up my app (I'm not a C developer, not sure what the code is doing), it works sometime and writes a file "1" as the output.
Could some kind person have a look at the C code and see why it is not working all the time.