Hello,
Say i have a collection of cells, A1:A30 which i want to make a simple line graph from. Simple. But then each day I add some new cells to the list, it could be any number of cells.
E.g Monday I add 5 cells, A1:A35, or wenesday I add another 15 which makes it A1:A50
How do i make the...
...'
' ImportstandardMacro Macro
' Keyboard Shortcut: Ctrl+a
'
MyPath = "C:\temp\import\"
With Application.FileSearch
.LookIn = MyPath
.Filename = "*.xls"
.Execute
End With
With Application.FileSearch
For i = 1 To .FoundFiles.Count
Workbooks.Open Filename:=.FoundFiles(i)
Myfile =...
Hello,
Wow this is just the ticket (i think!)
Few questions:
A) When you say catalog, do you mean folder?
B) Range of cells to be copied. The range stays the same that i need to copy out each day, say A2, B16 and C13. Each needs to go into the main spreadsheet as a new column or row, i don't...
Hello,
Background:
Every day i have an instrument which measures some chemicals and outputs them into an excel spreadsheet nicely.
What I want:
I need to take some selected cells (always constantly the same ones) and import them into a spreadsheet so that they reamin permantly in that...
Hello,
I have a folder with pictures (to which i know the names of) on a server, and I want to import these into mysql database.
Anybody know of a script?
Jimuni
Hello,
I have a table called "forum" in a database with 6 fields:
Forumname
Username
Topic
Topicdata
Date
Delete
And basically i want to copy all the data from all fields where the date say is older then 30 days and copy it into a new table called "archive" with the following fields...
Hello,
Whats wrong with this syntax and what should it be please?
COPY C:\runonce\runonce.bat C:\Documents and Settings\%username%\runonce.bat
Something is not correct, the %username% is in there because I need it to copy itself to the username folder of the documents and settings
Jim
Hello,
I need everyone (about 40 users on a PC) to all have the same settings for IE, most importantley, that they all have a autoconfig script (tools>connections>lan settings)
How can this be done without having to log in as each and every user?
Jim
Hi,
Say the username is "bob"
When I login, i want a dos batch file to run and make a directory called the username, in this case "bob"
What command is required please??
Jim
Hi,
I have about 30 users who have a windows 2000 setup. However their login name has just changed and hence we now need to set them all up on email again.
Is it possible to move the old exchange profile on there 2000 box to the new user login on the same machine, and if so, how do you do it...
Hi,
I have created my own SWF file on my desktop and transferred it to the IIs server.
I have the following problem:
It works fine on the my desktop.
It works fine, if I map the drive on the IIs server
It does not work if access the file via the web.
All thats not working is that its not...
Hi,
Say I have 3 boxs, each one has a text file which is imported for it and say each holds the variable: &color= where = is the colour of the box
I now want to when I roll over the box, for this text to come up in a box.
This I can do, but as soon as I try to have more then 1 import, it just...
Hi,
I am trying to make a graphic symbol (I have a map that I want) but each time I copy and paste the map into the new symbol it creates also a new bitmap in the library which if I delete, deletes the map out of the map graphic symbol.
What am I doing wrong?
Thanks
james
Hi,
Upto now, I have been using simple HTML to write a a href link with a ASP ending (carries a variable string) so that it would look like <a href="me.htm<%=variablestring%>">Click Here</a>
Now I have been tinkering with me code and now do a dynamic A href link but having problems...
Hi,
I want the variable to be nothing, aka null aka ""
I want the string to be sent like this (edited for shortness)
&Access=&Switch=on
And for it come back in the string as
&Access=on&Switch=
But at present, I am having to click the link (which has the string attached) twice...
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.