How can I put a process in the back and leave it processing while being able to do other stuff in excel.
Basically, I have 2 buttons...If user clicks button1, it should do some backend processin...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Business Goal: Management has asked us to return the listing of everyone name who is currently reports to them and everyone under them and so and so forth.
Currently, we have an Oracle database...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_22885849.html
I have a ms excel file that has different columns within one cell. I pasted this information into one column of excel from a file. I am trying to transfer certain information from the ms excel file...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/26/2008 Grade: A Views: 25
I recorded a macro to transfer the data (in ms excel)from the one row and splited(each row) into separate columns by creating a recorded macro as follows:
Sub transfer()
'
' transfer Macro
' Ma...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 04/26/2008 Grade: A Views: 5
I have an application where I want to export a query result to a csv file. I have the following code attached to the click event of a form button to export the file:
Private Sub Command0_Click(...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23260613.html
Zones:
MS AccessDate Answered: 04/13/2008 Grade: A Views: 0
Hello,
I am currently working on a project under Access 2003 environment. However, the ADP file (Access Database Project) I am working with is in Access 2000 format in hopes to allow users with ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23499389.html
I want to split a string into a 2 column array. The second column will always have the value of "A" in it.
So for example, I have a string with:
myString = "HELLO,WORLD,MY,NAME,iS,BOB"
I wa...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23528754.ht...
Zones:
VB ScriptDate Answered: 07/02/2008 Grade: A Views: 0
Background: I have an old PDX in my office that sends voicemails to email as .wav attachments. Most of my users check email on their phones, but the phone can't play .wav files. We use Outlook 2...
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_23573950....
I created the simple AutoExec macro shown below inside a new document (not in normal.dot). This is supposed to run every time the document is loaded. After saving the macro I closed the document an...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Word/...
I get the following error when trying to run the following code. I tried dimming the variables
as various data types but it doesn't work
"Run-time Error 13
Type Mismatch"
What data type ca...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...