Search:

Thanks for the replies
That's great!

I have a program which writes loads of data to an Excel spreadsheet
I need to be able to define a name (in Excel it's Insert -> Name -> define from the menus)
Any ideas how I can do this?
The...

I'm using '97 :)

I've managed to achieve what I wanted to do using SendKeys - not quite the silent batch process I was hoping for but at least it's [semi] automated

Excel will be on the PC
I tried to record a macro but no code was created when saving as html
(I was able to create a simple macro ok as in your example though)

Any ideas?

Thanks

I have a spreadsheet which has a graph in it
If I open it in Excel and 'Save as html' it goes though a four-stage wizard and ends up with an html file and the graph saved as a gif

I want to be...

I'm using VB6 to write to a worksheet in a .xls file
The data is then used in a graph on another worksheet.
The problem is that the data I'm inserting is being treated as text (left aligns)...

Not at all!! :D:D:D

I never did get interdev working again and now it's fine! It's like having an old friend back again

Many thanks!:thumb:

Hmm... I don't think it's actually possible

Thanks

I have a webpage loading into a webbrowser control but the webpage (which I cannot edit) calls a javascript function in the body onload.

I what to stop the onload from firing.

This doesn't...

I want to upload a text file to a webpage but not write it to the file system.
I onnly need to load it into a variable

Any clues?
I cannot use any additional DLLs etc


Thanks

Yay thanks!

I had to takeout the first 'Document' though so I had:

doc.frames("name-of-frame").Document.documentElement.innerHTML

I can grab the page contents of a webpage easily enough using the following code:




Private Sub WebBrowser3_DocumentComplete(ByVal pDisp As Object, URL As Variant)
Dim doc As HTMLDocument...

As soon as I run it I get:
http://www.vbforums.com/attachment.php?attachmentid=68105&stc=1&d=1230105710

and when I click 'click here' I get:
...

I've been using interdev (from VS 6 ) for years.
However, it now crashes when I try to run it.
I removed and re-installed it but it still doesn't want to play

Anyone had a similar problem?

...

Thanks for the replies... I've been a bit tied up with something else today but I'll check it out when I get a chance.

Thanks

My [vb6] app inserts data into an Excel spreadsheet but it looks like there's a limit of 255 chars per field

Why is that?
I can paste more than that directly into Excel!

I need to have about...

It's a .vbs and it works fine on two computers just not on the third one!

Jeeze!

If it was failing at the point where I open the connection string, that could be possible; but it should still create the connection object surely. I create the connection object in the same way...

Tried that! I downloaded MDAC 2.8 and when I ran the install it said that the components were already included in the version of the operating system (or words to that effect) :(

I have a .vbs file which works fine on two PCs but not on a third.
It fails when it gets to this line:

Set cnn_to = CreateObject("ADODB.Connection")


All three are running XP

Error: The...

Ah! That might be it.

I set them all as admin because when I installed Office 97 the spell checker couldn't find the libriaries, and setting all users to admin seemed to fix it.


Thanks, I'll...

Our home PC (running XP 'Pro') has four users on it
If one user changes the default webbrowser, it changes for every one
Why?

OK I know why: because it's Microsoft

How can I maintain separate...

I want to grab a series of images from a webcam running on a public website

What I've got so far is:
load the page into a webboresercontrol
grab the whole screen and load into a picturebox
save...

OK, I can do it using sendkeys but it's not the most elegant solution...

Any other ideas?

Thanks

If I save a page in Internet Explorer, I can save the html file complete with images etc.

How can I do this in VB (using a webbrowser control)?

So far I have only been able to save the plain...

You can all stop looking now! :)

I think I've found what I was looking for
...

I have an ASCII file which is intended to go to an IBM 6500 printer

The first character on each line is a control character
I've deduced that + means start a new page but I can't find out what...

I am currnetly using this connection string within an asp but if fails if someone already has the spreadsheet open.

ConnString="Provider=Microsoft.Jet.OLEDB.4.0;Mode=read;Data Source=" & FILENAME...

OK thanks, I'll give it a go

select drive from tbldata group by drive


select distinct drive from tbldata


Typical values for drive would be:
\\000.000.000.000\Apps (D)
\\000.000.000.000\Data (E)
...

Next question:

How do I a "group by" or "select distinct" on a text field?



Thanks

Yay!
Thanks again:)

These may seem pretty simple questions but I very rarely use SQL Server; more familiar with Oracle really....


:thumb:

What should I use instead?



Thanks

Thanks
That's perfect!

If I had a table in ACCESS with a date/time column and I wanted all records within the last 24 hours I could do this sort of thing:



How do I do this in SQL Server?




Thanks

Looking for one point as I know the unknown point is north of the other two
Statute miles


I've found a solution now anyway

Thanks :)

Points (a,b) (c,d) and (e,f) are points on a map


I want to calculate the co-ordinates of point (a,b)

s1 and s2 are known length (about 3 miles)

Co-ordinates of (c,d) and (e,f) are known

Really?

Perhaps you could show me one that has the source code, doesn't use any other components and doesn't require registering email address etc

Thanks

Just wondering (before I write something myself) if anyone has got some vb or vbscript to convert html to rtf.

It's mainly tables that I need


Thanks

It's daft because it guesses at the format.

I want to pass it a string I know to be in the format DD/MM/YY
so, 59/12/08 is obviously not a valid date.

Nevermind, I'll knock something up...