Excel automation using VC++ - C / C++ / MFC Discussion Boards

How to open a browse dialog with a specific folder in selected state

V K 214-Apr-09 1:30

14-Apr-09 1:30

Hi,
I am using the following code

BROWSEINFO bi = { 0 };
TCHAR path[MAX_PATH];
strcpy(path, "");
bi.hwndOwner = this->m_hWnd;
bi.lpszTitle = (csTitle);
bi.pszDisplayName = path;
bi.ulFlags = BIF_NEWDIALOGSTYLE|BIF_RETURNONLYFSDIRS;
CoInitialize(NULL);
LPITEMIDLIST pidl = SHBrowseForFolder ( &bi );
if ( pidl != 0 )
{
SHGetPathFromIDList ( pidl, path );

IMalloc * imalloc = 0;
if ( SUCCEEDED( SHGetMalloc ( &imalloc )) )
{
imalloc->Free ( pidl );
imalloc->Release ( );
}
}
CoUninitialize();

This code is always opening browse dialog with My Documents as selected.

I want to open browse dialog and with a specific folder in selected state

Re: How to open a browse dialog with a specific folder in selected state

Hamid_RT14-Apr-09 1:35

Hamid_RT

14-Apr-09 1:35

Do you need to set pidlRoot member of BROWSEINFO?

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: How to open a browse dialog with a specific folder in selected state

V K 214-Apr-09 1:40

V K 2

14-Apr-09 1:40

I have the folder path with me. I would pass the folder path to above code. How to open the browse dialog with the specified folder in selected state. I don't know how to use the pidlRoot member of BROWSEINFO structure

Re: How to open a browse dialog with a specific folder in selected state

David Crow14-Apr-09 2:39

David Crow

14-Apr-09 2:39

VKupunaram wrote:
I don't know how to use the pidlRoot member of BROWSEINFO structure

So have you searched?

Selecting a subfolder from a particular folder[^]

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

Re: How to open a browse dialog with a specific folder in selected state

V K 214-Apr-09 3:03

V K 2

14-Apr-09 3:03

This code is restricting to a particular folder. I need everything should be accesible. User should be able to select any of the folder.

Re: How to open a browse dialog with a specific folder in selected state

David Crow14-Apr-09 3:06

David Crow

14-Apr-09 3:06

The link I provided was merely an example of how to use pidlRoot. It's up to you to actually implement it per your design. Roll eyes | :rolleyes:

Re: How to open a browse dialog with a specific folder in selected state

David Crow14-Apr-09 2:40

David Crow

14-Apr-09 2:40

VKupunaram wrote:
TCHAR path[MAX_PATH];
strcpy(path, "");

While unrelated to your problem, you could replace these two statements with:

TCHAR path[MAX_PATH] = { '\0' };

Excel automation using VC++

Shishir Srivastav14-Apr-09 0:55

Shishir Srivastav

14-Apr-09 0:55

I have created one Automation project to create Excel sheet. In that i used below code block to execute Macro.

VARIANT Result;
     Result = oApp.Run(COleVariant("MACRO1"),  // The "macro" name
        COleVariant(ObjToConvert),  // An array of Variants
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional, covOptional, covOptional, covOptional,
     covOptional  // Run() takes 31 parameters!!
     );

When i am trying to debug its giving exception.
1. Can anyone please tell me what all arguments means here.
2. Do we have any other method through which one can execute Macro through program?
3. Do we have any method through which we can create data validation list using VC++?

Thanks.

What to do with this error message (embedded VC++ 4.0) ?

kapardhi14-Apr-09 0:22

kapardhi

14-Apr-09 0:22

Hello!

I am completely new to embedded VC++. I have installed the embedded Vc 4.0 and the standard SDk for windows .Net that came along withe the CD.
Now i created a sample dialog based application that must be run on a ARM4i device. I build the solution selecting the Standard SDK and WNCE ARM4I and buid the solution when i selected "Rebuild All" i get the following error message :
"An application targeting a Standard SDK for Windows CE .NET and built for the ARMV4I CPU cannot be run on the Emulator device. In order to run this application on any CPU other than the Emulator, you will have to install an SDK that is compatible with the Standard SDK for Windows CE .NET, then target a shadow platform pertaining to that SDK. "

what should be done now ?
Thanks

Re: What to do with this error message (embedded VC++ 4.0) ?

ParagPatel14-Apr-09 0:33

ParagPatel

14-Apr-09 0:33

Have you installed SP3 for VC4.0, and which Pocket SDK you are using (is it 2003)?

Parag Patel

Re: What to do with this error message (embedded VC++ 4.0) ?

kapardhi14-Apr-09 0:57

kapardhi

14-Apr-09 0:57

I donot know the technical details of the device, as i am new to it , but i heard terms lie ARM 4I, WIN CE 4.0 device
will this help or do you need any specific data

Re: What to do with this error message (embedded VC++ 4.0) ?

Divyang Mithaiwala14-Apr-09 1:20

Divyang Mithaiwala

14-Apr-09 1:20

Better to ask this question in Mobile Development[^] forum.
You may get quick response.

Do not trust a computer...
Always check what computer is doing

regards,
Divyang Mithaiwala
Software Engineer

can anyone give code in vc++

N.Ravi Raj13-Apr-09 23:47

N.Ravi Raj

13-Apr-09 23:47

when a day is given as input then output should be the weekday

eg:06-04-2009 is given output should be 'monday'

Thanks
RaviRaj

Re: can anyone give code in vc++

_AnsHUMAN_ 13-Apr-09 23:57

_AnsHUMAN_

13-Apr-09 23:57

N.Ravi Raj wrote:
when a day is given as input then output should be the weekday

you should refer date time classes in C++ first and then if you don't find a solution, someone here may help.
See GetDay function of COleDateTime

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: can anyone give code in vc++

N.Ravi Raj14-Apr-09 0:20

N.Ravi Raj

14-Apr-09 0:20

urgent please code in vc++
thanks

Re: can anyone give code in vc++

Rajesh R Subramanian14-Apr-09 0:51

Rajesh R Subramanian

14-Apr-09 0:51

If your query is urgent, you can go to rentacoder[^]

It is a crappy thing, but it's life -^ Carlo Pallini

Re: can anyone give code in vc++

Hamid_RT14-Apr-09 1:32

Hamid_RT

14-Apr-09 1:32

He can waits for Palini.

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: can anyone give code in vc++

CPallini14-Apr-09 5:08

CPallini

14-Apr-09 5:08

Hamid. wrote:
Palini

Wow, It's me? Uhm.....No, I'm Pallini!
Big Grin | :-D

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.

This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong.
-- Iain Clarke

[My articles]

Re: can anyone give code in vc++

Hamid_RT14-Apr-09 8:42

Hamid_RT

14-Apr-09 8:42

Yeah thats right. Big Grin | :-D

btw may I ask a quetion?

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: can anyone give code in vc++

CPallini14-Apr-09 9:12

CPallini

14-Apr-09 9:12

Hamid. wrote:
btw may I ask a quetion?

You know you can. Big Grin | :-D

Re: can anyone give code in vc++

Hamid_RT14-Apr-09 9:40

Hamid_RT

14-Apr-09 9:40

I was watched mvp.support.microsoft.com last night and I saw name of some members of codeproject(btw I saw your name CONGRATULATION Calro Big Grin | :-D

) I want to know is this depend to mvp that we could to get of codeproject or its different (I only got a mail chris 1 jan)?
Thanks Smile | :)

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: can anyone give code in vc++

CPallini14-Apr-09 10:44

CPallini

14-Apr-09 10:44

Hamid. wrote:
I want to know is this depend to mvp that we could to get of codeproject or its different (I only got a mail chris 1 jan)?

So far I've posted only on Code Project so I got it thanks to Code Project. I think you should be noticed by your local Ms MVP leader in order to get the award.
Good luck & best wishes!
Smile | :)

Re: can anyone give code in vc++

Hamid_RT14-Apr-09 20:23

Hamid_RT

14-Apr-09 20:23

Well I think its not possible so I need to do it myself.

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

Re: can anyone give code in vc++

_AnsHUMAN_ 14-Apr-09 1:14

_AnsHUMAN_

14-Apr-09 1:14

I gave more than what you asked for in your query. Now it's up to you to use it.

You need to google first, if you have "It's urgent please" mentioned in your question.
Wink | ;-)

_AnShUmAn_

Re: can anyone give code in vc++

pallaka14-Apr-09 0:02

pallaka

14-Apr-09 0:02

It should be in maths blog.Anyway Use the logic given below.....i hope it will help u

The Basic Steps

The basic steps for a date in the years 2000-2099 are as follows:

Example date July 13th, 2004

1. Take the last 2 digits of the year and add a quarter onto itself. (04 + 1 = 5)
2. Get the corresponding code for the month. (January = 6, February = 2, March = 2, etc. See month codes for details). July = 5
3. Take the day. (=13)
4. Add the numbers together (5 + 5 + 13 = 23)
5. Take away 7 (or multiples of 7) until a number from 1-7 is left. (23 - 21 =2)
6. This number corresponds to the day of the week. (1 = Monday, 2 = Tuesday, etc.) In this case 2 = Tuesday

The basic steps | Other points | Month codes | Leap years | Gregorian calendar | Shortcuts | Examples | Other methods | Books | Links | Whose idea?
Other points to take into account

Apart from the basic steps, other elements have to be taken into account:

* When adding a quarter of the year onto itself, If the quarter of the year is not a whole number, simply ignore the decimals. Do not round up. Therefore 27/4 = 6.75 = 6, and 2/4 = 0.5 = 0.

* Leap years: subtract 1 from the total if the month is January or February.

* Negative numbers. During the calculation you get 0 or negative numbers, just add seven until you get a number from 1-7.

* Different "centuries" *.
o 1700s add 5
o 1800s add 3
o 1900s add 1
o 2100s subtract 2
o 2200s subtract 4

(* For this method we have to consider a '00' year as part of the new century)

The basic steps | Other points | Month codes | Leap years | Gregorian calendar | Shortcuts | Examples | Other methods | Books | Links | Whose idea?
The codes for the months

At first the hardest part is learning the codes for the months. They are as follows:
Jan Feb Mar Apr. May Jun Jul Ago Sept Oct Nov Dec
6 2 2 5 0 3 5 1 4 6 2 4

Try to use some memory system to remember the codes for the months. for example, February is the 2nd month, March 2 music, etc. Try to find associations that will remind you.

If need be, you can add 7 or multiples of 7 to any of these values to help you remember them. For example, August could be 1 or 8, and as it is the 8th month, it may be easier to remember with 8 than with 1. This may be useful if you can match it with a well-known date. You could remember that the code for December is 25 (4+21), or for someone's birthday. The negative aspect of this is that you'll be taking away the 7 (or multiples) towards the end of the calculations, and you'll be working with bigger numbers.
The basic steps | Other points | Month codes | Leap years | Gregorian calendar | Shortcuts | Examples | Other methods | Books | Links | Whose idea?
Leap Years

* Remember that leap years are not always every 4 years. There are exceptions. Years that end in 00 are not leap years unless it is a multiple of 400. Therefore 1700, 1800, 1900, and 2100 are not leap years, but 2000 is.

The basic steps | Other points | Month codes | Leap years | Gregorian calendar | Shortcuts | Examples | Other methods | Books | Links | Whose idea?
The Gregorian Calendar

* The calendar as we know it only came into effect (in England) in 1752, replacing the Julian calendar. Changes included cutting 11 or more days out of the calendar and changing the first day of the year from march 21st to January 1st, and so this calculation method should not be used for dates before this changeover.
* Unfortunately, not everyone agreed to the change at the same time. The change was in fact officially enacted in 1582, but only some catholic countries actually did change at this time. After this other countries took their time before accepting the change. Great Britain in 1752, Japan in 1873 and China (the last) in 1949. In several cases, such as Germany, only some regions changed at a time, and Sweden removed the days one by one over a long time.
* The overall result of this is that for centuries, each country had its own system, and dates did not fall on the same day. if you are looking at a date, you need to take into account if it was before the changeover in that country, and take into account the 10 (or more) days removed from the calendar, the the fact that the years used to start on a different day.

The basic steps | Other points | Month codes | Leap years | Gregorian calendar | Shortcuts | Examples | Other methods | Books | Links | Whose idea?
Shortcuts

There are several shortcuts that can be used to simplify and speed up the process so that you can calculate the result almost immediately.

* When working out the year, remember that as the calendar repeats itself every 28 years within each "century", we can subtract 28 or multiples of 28 (56 or 84) so it is easier to add a quarter on to the year if it is a smaller number. Therefore 1996 is the same as 1996-84 =1912. It is much easier to add a quarter of 12 onto itself, than a quarter of 96. In this way, the greatest number you will have to work with is 27.

* When the year is a multiple of 4, such as 16, it is very easy to add a quarter (16/4=4 16+4 =20.). Some people may have problems when the number is not a multiple of 4. (e.g. 27/4). Because we do not need the decimals in the result, the easiest and quickest way is to take the nearest multiple of 4 below the number, and calculate a quarter of that, adding it onto the year. (e.g. 1927: the nearest multiple of 4 below this is 24. 24/4=6. add 6 to 27 to get 33.) Many people may find this easier than working out the division and then eliminating the decimals (27/4=6.75. eliminate the decimals to get 6. add 6 to 27 to get 33)

* It is good practice to subtract 7 or multiples of 7 at this point rather than adding on the month and the day before doing it. The same is true for the day. This is because it is easier to recognize and subtract multiples of 7 from smaller numbers.

* Simply remembering the final year code for the current year and the coming year makes instant calculations possible, as calculating the year code is the time-consuming process. For the years 2000-2003, the numbers correspond to the last digit of the year. This is a very quick method.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.