How do I send data in excel(cells) using SMS technology.
I have working knowledge in excel vba but Im at a loss on how to send a few data found in cells using SMS technology.
The scenario would be:
- excel gathers/formats data.
- part of that data should passed on to a number of GSM(SMS)...
hello guys!
how do i disable chkdsk on my xp pro? chkdsk always run after reboot. months ago only drive c: was checked. Now, almost my entire partitioned drives are checked.
any advice? pls.
@MichaelRed,
if each CALLed separate procedure takes 2minutes to finish by the time I reach the 20th CALLed procedure the result of the 1st procedure that was CALLed is already 38minutes old.
any other way?
thanks.
I'm a newbie in VBA. I have a simple VBA code that I used to get status/utilization of certain ckts on a particular GSM network element...hosted on a unix server. It is still in its raw state. At least it may give you an idea or something...
hope this helps.
Option Explicit
Dim Reflection2 As...
how do I execute several VBA codes using only one mother VBA code. Timing is critical because I want to retrieve data from several sources at the same time. If not possible...a few seconds difference is acceptable.
Is this possible?
Thanks for the response.
I made a VB code that will access a remote machine thru Reflection2. My problem is if the PC that is running my code has no Reflection2 installed it cannot execute the program.
What is the code or object that I will use to use telnet running in windowsXP/2000.
My code for opening Reflection2...
These codes don't do the monitoring but based on them in action, I can see that VBA is faster than VB6 in terms of populating excel cells...(data extracted from very large text file).
@strongm,
I don't see any difference in the codes. As what I've said, I only copied the VBA code in the VB6...
@kodr, that is exactly what I did. But how will you do it if you are monitoring circuit status of 10 or more networks? The graphical interface is just an added feature, what I am after is the formatted data for post processing.
I created separate sheets for each network, but again my problem is...
thanks Roy.
I am trying to use VBA to monitor cellular network/circuit status. what I really wanted was monitor several networks, so I need to shift between several sheets...unfortunately, VBA does not allow me to manually click on other sheets while it is still running.
Or, is there a trick...
the compiled version only improved by around 10%. Negligible.
Since most of my work is populating excel cells with variables extracted from large text files,
I also noticed that when VBA is running, I cannot mess with the excel file. But when VB is the one populating cells, clicking on one cell...
I created a VBA that reads a text file(sequential,very large file) then puts the values in excel cells. Out of curiosity and as practice coding, I copied the VBA code into VB6 and tried running it. I noticed that VBA does it faster(90% faster) than VB6.
is VBA really faster than VB6 when it...
it does transfer other files from phone to PC. but for this particular tinygps.cdb, file conversion does not work or an error appears 'the remote procedure call failed'
something to do with my msoffice2003/access2003 app? but, it is the updated version.
or maybe i have to activate something in...
I have office 2003 running on winXPpro.
I use activesync3.8 to sync my smartphone to my PC.
Tinygps is running on my phone which creates a tinygps.cdb file.
When I try to transfer the tinygps.cdb file from my phone to my PC using activesync, I get the error...
"cannot convert file 'tinygps'...
Procomm plus is already under symantec, right? but I can't find it in their website. I am planning to purchase procomm plus 4.8, but I don't know where to buy it?
If I purchase it, who will I turn to for support?
any ideas?
What I have in mind is to let excel(VBA) dial telnet, then capture data, process and paste in excel range.
Or, VB6 code to access telnet, capture data, process data, then paste in excel.
I know something in the process/paste part, its the telnet part I don't know how.
Please tell me how. :)
How do I delete or hide a macro from users after it executes?
This macro just extracts data from several text files and pastes(formatted) it in the worksheets.
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.