Hi All,
Quick question:
Got a bunch of people who are supposed to first copy a WorkBook, then perform work-related activities - must be able to save when finished. Trouble is, no matter how ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_103...
Zones:
MS OfficeDate Answered: 04/07/2000 Rating: 9.4 Views: 0
I am writing an application using MFC. I need to create a new Excel File, and then Write data to Worksheet. Also need to open an existing Excel File and read data from each cell in a workbook.
...
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_20084247.htm...
Zones:
Windows MFCDate Answered: 05/09/2001 Rating: 6.2 Views: 0
Excel 97 Macro.
macro in one workbook calls another macro in another workbook that requires variable. Can't get it to work.
w/o the variable, the line would be:
Application.Run "TYSEXMPT.XLS!Tra...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
Zones:
MS OfficeDate Answered: 08/02/2001 Rating: 9.6 Views: 0
I have run into a snag and I do not know if it is solvable or not. I have an Excel Spreadsheet where some of the cells are locked and others are not.
As you know, to enable the locked cell, the w...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
Zones:
MS OfficeDate Answered: 11/16/2002 Rating: 9.6 Views: 0
I share a workbook for serverall workstations.
From time to time I start from a certain workstation a VB macro in this workbook. In order to perform the macro correctly it has to access the most r...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
Zones:
MS OfficeDate Answered: 02/12/2003 Rating: 8.2 Views: 0
From VB I would like to get a list of all the runnable macros in an Excel workbook. This is so a user can select from a list in my external project and run the macro from there.
I have searched ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_205...
Zones:
MS OfficeDate Answered: 02/22/2003 Rating: 9.2 Views: 0
I need help with creating a macro to copy rows of data from existing spreadsheet into a new file(s) for each change of the value in one of the columns.
pls let me know if you need more details
...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_205...
Zones:
MS OfficeDate Answered: 02/28/2003 Rating: 7.0 Views: 0
Is there a way to check, and validate, what is in the clipboard before it is pasted into the target cell? I have both data validation and conditional formatting set up for a range of cells. The o...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_206...
Zones:
MS OfficeDate Answered: 02/13/2004 Rating: 7.4 Views: 0
Hi,
Quick question. I have a shared workbook and I want to show list of all users that are currently on the file.
I mean the ones that have this workbook open.
I know that I can see them list...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_207...
Zones:
MS OfficeDate Answered: 08/23/2003 Rating: 8.4 Views: 0
I want to delete some sheets in a workbook.. I want to use the sheet names to delete them not the count or sheet number
'open the workbook
for i=1 to totalSheets2delete
'select sheet with na...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20769036.html
Zones:
Visual BasicDate Answered: 10/17/2003 Rating: 8.6 Views: 0
