|
by: OhMyGaw |
last post by:
Hello Excel/automation Gurus,
I am working on an application where I have to keep a centralized
database of all macros distributed to user and save the changes back on
a nightly basis back to one central Excel macro repository.
What would you guys suggest me do?
Should I keep all macros in a centralized unique text file of some sort
or is it best to do with SQL server?
|
by: jeremy.bird |
last post by:
I am looking for a possible solution or bump in the right direction
when working with excel on the web. Currently I am using and developing
in visual studio 2005. Here is the situation I have a lot of
spreadsheets with macros that I would like to deliver to people via a
web application(read only for now maye not in the future).... Some
problems that I am running into are:
1) macros do not work when embedding the excel sheet in the...
|
by: Holger Fitschen |
last post by:
Hi to all,
I want to use the Excel solver in a VB.Net project.
The macro
Sub Makro1Solver()
Application.Run "Solver.xla!Auto_Open"
SolverReset
Worksheets(1).Select
Worksheets(1).Range("B9").Select
|
by: Duncan Smith |
last post by:
Hello,
I am currently implementing (mainly in Python) 'models' that come
to me as Excel spreadsheets, with little additional information. I am
expected to use these models in a web application. Some contain many
worksheets and various macros.
What I'd like to do is extract the data and business logic so that I can
figure out exactly what these models actually do and code it up. An
obvious (I think) idea is to generate an acyclic...
|
by: Mihov |
last post by:
Hi Everybody,
My name is Miho. I have developed number of macros using Visual Basic for Excel. Many of them use FileSearch which worked perfectly before Excel 2007.
With Excel 2007 this is no longer possible, although the same text exists in the Help menu.
Is there a way to solve this problem?
Any suggestions will be highly appreciated.
|
|
by: cloh |
last post by:
I have a form in Access that generates an Excel Workbook with multiple worksheets. Each worksheet is unique to a particular location. The top row of each sheet shows the dates, the left-most column has the times of the day in 5 minute intervals. Let's say the dates range from 7/01/2007 to 9/01/2007
The aim of the form is to eventually create a chart for each date that the user wants. On the form, I get the user to input either a single date...
|
by: BSB |
last post by:
hi,
I was working with excel 2000 contaning macros and pivot tables.It was working fine for years.
My system is updated with excel 2007 now. The macros and pivot tables are not getting refreshed properly...
And it says there is some integrity problem.
Can somebody help me on this???????????
thank u
|
by: =?Utf-8?B?SmVycnkgQw==?= |
last post by:
I have a web site that automates excel.
This site runs in server 2003. iis 6.0 office 2003 installed
I moved this app to server 2008 iis 7.0 office 2003 installed
Now when I try to automate excel I get the error
Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following error:
80070005.
System.UnauthorizedAccessException: Retrieving the COM class factory for
|
by: newnewbie |
last post by:
Hi,
Our company recently transitioned to Office 2007 and one of my macros crashes Excel 2007 - gives "Excel encountered a serious error and needs to close" always at the same spot of the code. I combed the web to see if there are grave differences between VBA in 2003 and 2007 and found nothing...this is the code. I would appreciate any suggestions!
'Application.Run "INTRANET.XLSM!Revenue_Format"
Sub Revenue_Format()
...
|
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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|