|
by: nivas.meda |
last post by:
Hi,
I have an excel sheet with a graph and cells.If i change the value in
the excel cells the graph will reflect.Now i am going to implement this
functionality in html page.I successfully saved this as interactive
html page.Now my requirement changes a bit.The excell cells will not
visible to others.i have a text box,If i change the value in text box
the excel template cell value need to change.
I did the follwing steps for creating...
|
by: cor |
last post by:
In Access(97) I am able to have a cell to be a hyperlink referencing a spreadsheet,
a cell, a column or a database's table or query. When I click on it It opens
on such reference program. The content of such cell is not the content of the reference
but a 'display text' value that I assign. Since the database does not see the
referenced value it can not be used as a query value.
My question is is there a way to have a visible cell...
|
by: Frank M. Walter |
last post by:
Hello,
I have made an small AddIn with udf for excel 2003.
I use vs2003.
The point of view is the function __T()
I call it in excel sheet writing =__T()
I am not able to set a value to a given cell.
region.Value2="qwe"; //bumm!
A exception will be trown. On all PCs with excel.
HRESULT 0x800A03EC
|
by: ane1717 |
last post by:
I am trying to write a code that runs when the user clicks a picture within another excel spreadsheet. I need it jump to a specified cell by searching for the contents within the cell "152Z33XX". I can get it to search through the other sheet and find the cell, even highlight, but I often have to scroll through 120000 lines to find the highlighted cell. I would like it to jump to and select the cell within the window everytime the user clicks...
|
by: tarvold |
last post by:
I am new to VBA and am trying to get this project done, so any help would be appreciated.
I am trying to create a userform that will input the total hours worked by an employee into an excel sheet. there are many sheets, each for a particular task. The first two selections are listboxes in which the user will select the employee's name and the date.
The worksheets all look the same, with the names in the "A" column and the dates on "5"...
|
|
by: Maninder Karir |
last post by:
Hi,
I have a workbook with around 28 worksheets, I have put together a macro which imports the data from each of the 28 different textfiles into it own sheet. Each sheet is named after the text filename.
I want to create a sheet which pulls all the data together. But I need the data in a particular order. In column A I have listed the file names in the order I need. These filenames correspond to the sheet names. I want Column B then...
|
by: =?Utf-8?B?THluZXJz?= |
last post by:
Hello All,
We have a VB.NET application writen using VS 2003. This application apens an
excel file from a vendor, reads the data and performs whatever functions it
needs. We recently upgraded our sytems to Excel 2003 from Excel 2000. Our
application started erroring out because it was having a problem with opening
the Excel file.
From troubleshooting, the exact problem is in Excel 2003, it does not like
the sheet name (even though the...
|
by: Monusonu |
last post by:
Hi Expert,
I am trying to get the value from excel formula cell using POI. My code works fine for less complex formula cells, but fails or returns error code for complex formula cells.
Following is the code I am using to get values:-
public class POIMain{
public POIMain() {
}
public static void main(String args) {
try{
|
by: DWHTHS |
last post by:
Hello, this is a VBA query relating to Microsoft Excel 2007.
I am trying to run a macro that copies the current sheet and deletes some of the content to provide a new blank sheet.
Ideally I want this to use a value that is shown in a cell within the new sheet. I had tried to acheive this by copying the cells contents and then pasting as a value within a macro, however this worked on the first sheet but the second time I ran the macro, the...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|