Search:
Type: Posts; User: incidentals
Search:
Search took 0.05 seconds.
-
looking at the announcement it looks like its simply a separately names space that he suggested working in to protect your original workspace.
He set it when opening the IDE and was able to use it...
-
would be nice to see an example how you see avaya information file or otherwise - Its just that anumber of people have been talking about these recently.
Just thinking out loud
-
match with the last 9 characters of the name or 13 of whole name with ext
like
if right(filename,9)="_univ_sqr.jpg" then deletefile(filename)
assuming that you have a deletefile() function...
-
how many months does the main sheet hold - for sanity purposes?
you could trigger the archival process when you enter the month xmonths since first month mentioned...
The process would end up...
-
you could build a batch file and then shell the batch file.
using file deletion and directory deletion commands
RMDIR [/S] [/Q] [drive:]path
RD [/S] [/Q] [drive:]path
/S Removes...
-
(1) why are you only sending the first month to another different sheet? - why are you not sending all of the months to other sheets?
you could simply run down the sheet outputting each line to...
-
you can also abandon the spreadsheet...
save data as csv
process the csv adding column 1 value <comma> column 2 value <return>
simply read the first line in and pass it out to new file,...
-
for fun try...
open second sheet and fill it with this row is 1 minute more than the last
=above+1/24/60
where above is the cell directly above
in the second column put a vlookup that looks...
-
why not fill a sheet with appropriate cells and then find your data within in the sheet and fill column?
hope that makes sense
-
I have obviously been messing in too many languages over the 40years.
I still find the vb cumbersome and clumbsy to read, compared to other languages.
PYTHON OFFERS A NICE CLEAR APPROACH AND...
-
nice piece of work here, but the complexity is why I like to use python and beautifulsoup.
-
first bits done for this project oonly not general solution!
def texter(t):
return(t.text)
# import libraries
from bs4 import BeautifulSoup
output =[]
-
Thats the system up again...
here is some code to explain why its easy to use python for the decode part.
# import libraries
from bs4 import BeautifulSoup
doc =...
-
I would honour you with an example, but, I say this in all honesty!
My F***ing machine has now, and I mean, just now decided it cannot save the scripts from idle to my system so that I can run it...
-
I am going to have to talk about the op and olafs comments together.
op ... you can read the file into your program line by line or as a block
you need to walk through the block to...
-
have you ever written python or used the beautifulsoup module?
-
identify where the data is held and read past all of the stuff befor that point then collect all of the data stuff until end of this data and dump the file.
then walk through the data collecting and...
-
-
you could forego all of the fancy stuff and just read the file in as a chunk and chop out the rubbish leaving only the pieces you wish to process... as long as your data is of a fixed and regular...
-
as always you need to ask a more defined question, possibly with example record attached for a proper answer.
-
PayPal have this all covered Go look at merchant tools like I suggested.
-
enroll as a merchant with pay pal and use the toolset to create donation buttons store the client data and "Bobs your uncle" all documentation supplied by PayPal
-
the process of modifying a thing that comes in is to output the modification
whether the change is made to a line in a file or a placeholder in memory the approach is the same
the op needs to...
-
op does not need to think about errant lines he states all lines are the same structure
so read a,b
will resolve the number with the decimal is b
so format$(b,"###.0000") would be fine
...
-
oops i thought you wanted all of the data - any way the process it the same just amend the output
you can read the lines in as varA and varB
and output varA and varB with separator=space
...
-
the empty cells are in the data before merging or a result of merging?
ie can you fix the table before merging begins and have a cleaner merge if the problem is "pre merge"
here to help
-
you have formed a mutually exclusive zone often termed mutex where the control of what is happening is managed to prevent unexpected/expected but unwanted interactions
a common way to do exactly...
-
add debug.print or a msgbox and use it to expose the app.path so you can see where the stuff wants to go
here to help
-
where exactly are you copying to?
some destinations are prohibited like C:\ for example as the root is where important stuff is kept
here to help
-
I would need to see the format of the data to really help
you can generate a new format that includes all formats and juts use the parts that are stable for the data conversion.
you should try...
-
try triggering the change with another control or with the last control in the sequence.
I have a form that must update when the user needs it to so i have a change control that when changed calls...
-
can i see the form and some data if thats ok?
here to help
-
the first part works fine and I added a wee test to show the selection of "b2"
Excel.range("b2").Select()
nothing but the file placement changed from d:\test.xlsx to c:\test\test.xlsx
...
-
the bullet points will be part of the document layout and they must be seeing the carriage returns of line feeds left by your process
we would need to see a little more code to help
here to...
-
CSV - comma separated values - a comma appears between entries in this file
you could use tabs or any other separator if you push the format your way
simplest capture from csv to excel is...
-
do you email all 20 bits to each email recipient or is each bit for a different email?
here to help
-
I think your explanation is muddying the problem
you have not said what the columns/fields hold and simply saying c and d and now a does not help us to understand your needs
words like unique...
-
there you go a proper combined solution...
well done us!
now do not forget to rate the replies that helped and close the thread ( mark as resolved )
here to help
-
use the cstr version of the code i put underneath
the text wants a string maybe
here to help
-
use passels version with to overcome the differences between .net and vb
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
valTotal = valTotal +...
|
Click Here to Expand Forum to Full Width
|