For some reason, I can't figure this out.
I'm trying to create a subroutine that will create a text file everyday named by that day's date. Seems really simple - but after I create a variable that is equal to Now - I don't know how to get that into the Open Filename statement:
Dim date1 As...
I pulled the following code from a guy's dHTML site for a rotating banner. Everything about it works great, except that I can't figure out how to manage the scrolling rate.
Here's the part in the <HEAD> section:
<script language="JavaScript1.2">
/*
Horizontal Pausing News Scroller
Copyright...
I'm trying to trigger 1 of 2 different cgi scripts based on the username that the person enters into a form - everything seems to be working fine (the user-specific url stings are getting built just fine) in the below code, except that when I try to do window.location.replace from inside one of...
Hi -
I've linked 2 spreadsheets through a DDE Link. What I'm trying to do is capture the time-lag between updating the cells of one to the other.
I obviously synched both clocks to the atomic clock first.
Then I created a Private Sub as follows:
If Range("a1").Value <> "whatever the hold...
I'm using a drop down menu for my site, and I'm wondering if anyone knows how to get javascript to recognize transpancey for the background color of the menus and sub-menus? - here is the page where the menu is being used - http://www.cherubshoes.com/BC/index.htm I've masked the background color...
I'm using the following code to have users upload files to a directory on my site - every time I test though the process adds about 20-30 bits of data to the file, causing havoc with it - like turning this:
http://www.highwaym.com/walter.jpg
(size: 7951 bits)
into this...
I know I'm doin this really badly, and my code still doesn't work.
I trying to use a flat tab delimited file for a database for a simple shopping site.
Each record has several elements - including color, name, description, type, etc.
I trying to write a CGI that loads all records into...
I'm wondering if it's possible to link workbook cells from one Excel doc. to another over a network dynamically?
IE - A1 on Computer 1 is linked to A1 on Computer 2 and updates dynamically when changed.
Firstly - how would one go about this?
Secondly - what would be the time loss in doing so...
I'm using the following image rollover script, but I would like to add 1 small thing.
When the user clicks the link embedded in the rollover, I'd like the image to be permanently the second image (the rollover) - like the VLINK function in the <BODY> tags (there is also an embedded pop-up...
I'm not a VB guy, so I was wondering if someone out there could give me a quick hit of code . . .
I need to check a directory for a text file for a data query - and if the text file does exist, then to query it (I've got this working) - I just need an if . . . then statement to skip to the sub...
i've got a macro that imports data to some fields, and then rearranges 2 of the columns. Next to the data fields, I'm using a concatenate function to combine 2 of the fields, however, when the macro cuts and inserts the column, it changes the reference cell for the concatenate function.
So -...
I need a way to run either a data refresh, or a macro about every 1-2 seconds - and I can't think of a way to get it done.
the 'Refresh Data' will only run every 1 minute at the most - can anyone think of a clever way to do this - your help is much appreciated!
Ethan Altaratz
Could anyone out there help with this - I'm trying to automate the saving of outlook email messages to a separate, non-outlook directory as textfiles, when the sender is someone specific - if someone could tell me how to do this I would be incredibly thankful.
So for example if the sender is...
Could someone please lay out in very simple terms how to auto run a macro when the workbook opens up - thanks - it seems simple, but I can't figure it out :-(.
I'm in desperate need of help - for a project for my company that I need to get done.
I have a spreadsheet linked to a dynamic data source with cell values changing realtime.
I need to capture the value of the data feed if the data meets a certain criteria - so for example:
The price feed is...
Hi -
I'm telnetted into my web site, and I'm trying to unzip a zipped text file I have through a telnet prompt. I thought that the command line would be this:
gunzip -cd filename.zip | tar xvf -
But it won't unzip - can someone pls. tell me what I'm doing wrong? Thanks
Ethan
Hi - I'm currently running some computationally-intensive perl programs on a shared host server. The number of computations required is really, really intensive, and I'm afraid I'm getting poor results for speed of data analysis.
I'm wondering:
Can I load a perl interpreter on my home PC (Win...
I know this is so simple, but I'm still a real newbie at Perl. I'm trying to search through a space delimited text file, and replace the spaces with comma delimits. The lines of data is as such:
AAA BBB CCC DDD EEE FFF
XXX YYY ZZZ RRR GGG YYY
and I want
AAA,BBB,CCC,DDD,EEE,FFF...
Below is the code for a perl script I wrote, but when I run perl -w it gives me the following:
Use of uninitialized values at the script lines 38, <TESTFILE> chunk 86.
Does anyone have an idea what could be wrong, and what this error means. I've been trying to figure it out for a couple of...
This is a follow-up to a question about parsing data by it's date. First of all, the sample data being processed:
DATE TIME PRICE
20011015,1730,109275
20011015,1730,109250
20011015,1730,109275
20011015,1730,109275
20011015,1730,109250
20011015,1730,109225
20011015,1730,109275...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.