Thank you gentlemen, stars for all of you!
XWB, to answer your question, there was a single instance of Excel open in task mgr after running the script.
After exploring the options/suggestions, this is what I ended up with, which seems to do what I need.
Set ExcelObject =...
Forgive me, I dont know vbs, I searched and searched for what I have so far and feel like I am very close to a solution on this.
All files are in the same folder, currently on my laptop.
The task at hand is...
1.Take 3 xls files and convert them to txt
2.Combine the txt files into a single...
I'm on 2010.
I saved this to the hidden Personal workbook like I do all my other macros so I can use it with any workbook...I see now, I would have to type in "=PERSONAL.XLSB!Strip_Dashes(A1)"
What should I have done differently to just type in "=strip_dashes(A1)"?
Its not a big deal really...
A star to both of you for helping me with this...I saved both versions and so far they both work well.
It did take me a bit to figure out how to actually run the function as I was still thinking in terms of a macro with an assigned keyboard shortcut. Once I zoned in on the fact that this was a...
Andy,
Definitely yes that sounds appealing. You might have to walk me through it...I use macro's but havent looked at the actual VBA code in a long time.
...deadline was somewhat self-imposed.
Actually I think I've got something that will work now..I dont know why I was trying to cram all that into 1 formula.
I added a column to do some of the math so now my main formula is down to...
=IF(AND(G2="M",H2="A"),K2*I2,IF(AND(G2="M",H2="E"),L2*I2,N2/I2))
Im sorry for the lack of detail in my questions...I was overwhelmed and really needed this finished yesterday and was scrambling to find an answer. Funny but now that the deadline is past I feel better about it.
Database is a Unix platform running Activant Prism software...I can create reports...
...be blank in the Pricing Plan data).
Maybe it would be easier to read like this...
If Markup/Down = "M"
If Price to be used = A
Multiply Price A * (Percent/100)
else
If MArkup/Down = "M"
If Price to be used = "E"
Multiply Price E * (percent/100)
else
Wait a minute...would it make more...
...more "IF" added to it...Ive never created a formula this lengthy but I thought I could do 7 "IF's" without a problem.
here is the formula...
=IF(VLOOKUP(H2,A:E,5,TRUE)="M",IF(VLOOKUP(H2,A:G,7,TRUE)="A",(VLOOKUP(H2,A:F,6,TRUE)/100)*O2)...
I have several remote sites that are connected to our database via Frame Relay...they also have local Internet access.
I used the solution found in this article to connect the PC's to both networks.
http://www.tek-tips.com/viewthread.cfm?qid=1006195
Now I have a SOnicwall at 3 of these...
I created a shortcut to Microsoft Word(several different ways) and every time it is not visible on the desktop but I can see all the shortcuts when I explore the desktop folder.
I checked the shortcuts properties and they are not hidden.
Theres probably a good/easy explanation for this but this...
Thanks Chip, I didnt know you could use the Win2k Recovery Console in NT 4.0 either but it sure is good info to have. I appreciate all your suggestions...I didnt have access to ERD Commander or I would have tried it too.
I finally got this machine back up and running. It didnt have a cd drive (floppy and 2 sided dvd) so I temporarily installed one and tried several things...UBCD wouldnt boot up, Bart PE wouldnt boot, my Win NT disc would work and I got into the repair section but didnt change anything because...
BSOD is a little off to the left of the screen but I believe it says...
CK(?)Mode_Exception_not_handled
Address 8011f5a2 has base at 80100000 - ntoskrnl.exe
I'll try to reboot it again...I believe it said something about ntoskrnl.exe but I'll look again to make sure.
I forgot to mention I tried removing the NIC yesterday, still BSOD.
We have an old Windows NT workstation that is a voice/phone recorder that records all phone calls on 10 different lines(Audiolog).
While attempting to get this PC visible on our network, it seemed that the network card wasnt working or maybe the driver wasnt loading. I changed the startup...
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.