|
Hello,
Can I get the name of the sheet from any method of a Worksheet ?
Can I use CRecordset to open a sheet from excel file whose name(sheet's name) is not known.
Thanks for your help.
Prithaa
|
|
|
|
|
The most recent MSDN I have is Jan2002
wherein you drill down as follows
Office Solutions development
Microsoft Office
Microsoft Office Xp
VBA Language Reference
Microsoft Excel Visual Basic Reference
Objects
W
Worksheet Object
Name Property
no I dont think you can CRecordset a sheet whose name is not known (but I could be wrong)
|
|
|
|
|
I'm having a windows forms application project. On the form there's a datagridview with data of a table out of the datasources. The connectionstring in the datasource is made by the add new datasource wizard and is : Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test\Tabel-XML.mdb
Changing it in the _Tabel_XMLDataset.h file doesn't do anything and changes after a new build.
Now I'd like to know if it's possible to change my data source, so make it variable. I saw something about the use of app.config but how do i have to do this then so that the data source of my datagridview is changed without rebuilding my project it each time after creating a new databaseconnection. I'd like to define the databaseconnection in an external file (like app.config) and then use this databaseconnection for my project. How is this done?
Thanks for helping me out
-- modified at 10:26 Friday 26th October, 2007
|
|
|
|
|
I want to draw some characters with underline, strikeout or overline, I've known how to get the first two, but how to do with the overline, please?
I'm using VC++ 2005, GDI+.
thanks~
Thanks all!
|
|
|
|
|
When you make your font with CreateFont you can set these parameters for it.
|
|
|
|
|
BOOL CreateFont(
int nHeight,
int nWidth,
int nEscapement,
int nOrientation,
int nWeight,
BYTE bItalic,
BYTE bUnderline,
BYTE cStrikeOut,
BYTE nCharSet,
BYTE nOutPrecision,
BYTE nClipPrecision,
BYTE nQuality,
BYTE nPitchAndFamily,
LPCTSTR lpszFacename
);
you mean this?
sorry, I don't see how to set over-line here, any suggestions?
thanks a lot~
|
|
|
|
|
Hello friends I am creating the application that provides the multiple desktop. I am using CreateDesktop and SwitchDesktop API for that. And also getting new Desktop throught that, But has several problem with new Desktop.
I search a lot for that but not getting enought help.The problem are as follows.
1) Windows shortcut ( Hotkeys ) are not working in new Desktop.
i.e. If I press the WIN + R to open the RUN Window it don't open in the new window, But open in the Default window.
2) Not able to open the TASK MANAGER in New Desktop. It also opens in the Default desktop.
3) As I am creating the new instance of Explorer before switching to new desktop. Not gettting current Tray Icons From defult Desktop to new Desktop.
Is there any way I can Solve the problems. Are any Hint on how I can solve it.
Thnx in advance.....
|
|
|
|
|
How to parse VBA script file in MFC ?
I want to extract following information from the VBA script file,
1. Number of modules in the script.
2. Name of all the modules.
3. All the function names in the given module.
Is there any scripting engine ?
Any help would be appreciated ?
Regards,
Paresh.
|
|
|
|
|
Look into LEX & YACC... It's been awhile since I used them, but they could help if nothing else does.
Though there must be a more modern alternative!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />
Peter Weyzen<br />
Staff Engineer<br />
<A HREF="http://www.soonr.com">SoonR Inc -- PC Power delivered to your phone</A>
|
|
|
|
|
Thanks for your reply.
Could you please give some reference to start with ?
Regards,
Paresh.
|
|
|
|
|
There's a HUGE documentation about bison and flex, Google is your best friend.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
|
Hello,
I am reading an excel file in VC++ where I have read the first sheet though IDispatch.But I cannot read the 2nd sheet and find the name of the sheet.
Any ideas
Prithaa
|
|
|
|
|
How are you reading an excel file ?
I think I have a similar problem, could you please help me for finding the solution ?
How to parse VBA script file in MFC ?
I want the following information from the VBA macro file,
1. Number of modules in the script.
2. Name of all the modules.
3. All the function names in the given modules.
Is there any scripting engine ?
Any help would be appreciated.
Thanks and Regards,
Paresh.
|
|
|
|
|
Hello,
I am not aware of VB.What I have done is just read an excel sheet which comprises of row and columns and put those values in my variables.
Do you want to know this?
Thanks
Prithaa
|
|
|
|
|
Yes. Could you please share the code sample ?
Regards,
Paresh.
|
|
|
|
|
|
|
|
Hi Hamid,
I have an issue[^]. Could you please help me in solving this issue ?
Regards,
Paresh.
|
|
|
|
|
|
This is not solving my purpose.
My requirement is load the script in the object (I guess, it may be engine). After loading the VBA script, Extract all module names in the script, function names in respective module, etc.
I hope you understand the requirement. Please let me know if you need more information.
Regards,
Paresh.
|
|
|
|
|
This made me chuckle maybe someone in microsoft has a sense of humor. See the urban dictionary definition of hosed[^]
Article title 'clean' translation "How to add add support for broken VBScript to your MFC application"
|
|
|
|
|
Good catch .
Regards,
Paresh.
-- modified at 3:31 Thursday 25th October, 2007
|
|
|
|
|
Paresh Chitte wrote: Good catch .
shhhhhhhhh:->
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
Never mind - my own stupidity is the source of every "problem" - Mixture
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
Support CRY- Child Relief and You
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
