Problem with Macros!
 

First of all I would like to say hi to everyone! I can't wait to use
this site to help my understanding of excel.
I run a restaurant and my register dumps data into a computer upstairs
everyday. I already use excel to manually plug in my sales info, etc
for records. I wanted to make a macros to insert the data for me by
clicking a button and entering the date of the file to be imported. So
I have been using another macros formula to try and edit it to fit my
own needs.
The formula originally was made to pull the info for a one week period
so it also had a formula to check and make sure the day (mon, tue,
wed,etc.) matched up with the date inserted.
For my macro I need it to be able to pull data for the whole month.
Could someone give a look at the files and see if you can see why I'm
getting type 13 mismatch errors. I did install latest windows update
also. I have excel 2003 on my computer. Thanks in advance for any
help!!-- Mike


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile: http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=556797

Problem with Macros!
 

Hi Buzz,

Try posting the problematic code, indicating the errors encountered and the
Highlighted lines.


---
Regards,
Norman


"buzzharley" wrote
in message ...

First of all I would like to say hi to everyone! I can't wait to use
this site to help my understanding of excel.
I run a restaurant and my register dumps data into a computer upstairs
everyday. I already use excel to manually plug in my sales info, etc
for records. I wanted to make a macros to insert the data for me by
clicking a button and entering the date of the file to be imported. So
I have been using another macros formula to try and edit it to fit my
own needs.
The formula originally was made to pull the info for a one week period
so it also had a formula to check and make sure the day (mon, tue,
wed,etc.) matched up with the date inserted.
For my macro I need it to be able to pull data for the whole month.
Could someone give a look at the files and see if you can see why I'm
getting type 13 mismatch errors. I did install latest windows update
also. I have excel 2003 on my computer. Thanks in advance for any
help!!-- Mike


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile:
http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=556797

Problem with Macros!
 

Thanks for your reply. I attached the almost original macros and the
modified version in the first post. I'm really not sure where the
problem is occurring. If I try to type in any day number past 7 it
says it says that, that date has already been used, cancel, or
continue. When I continue I get the type 13 mismatch error. I'm
pretty lost as to where the problem lies.


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile: http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=556797

Problem with Macros!
 

Hi Buzz,

In this newsgroup few would be prepared to open unkmown attachments.

Try pasting the relevat code into a reply.

I note that you have posted via ExcelTip. This newsgroup is a peer-peer
newsgroup which is hosted on Microsoft servers. ExcelTip is a commercial
site which piggybacks onto the ng. For more information see:

http://www.cpearson.com/excel/DirectConnect.htm


---
Regards,
Norman


"buzzharley" wrote
in message ...

Thanks for your reply. I attached the almost original macros and the
modified version in the first post. I'm really not sure where the
problem is occurring. If I try to type in any day number past 7 it
says it says that, that date has already been used, cancel, or
continue. When I continue I get the type 13 mismatch error. I'm
pretty lost as to where the problem lies.


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile:
http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=556797

Problem with Macros!
 

I'm trying to alter a macros that is used to gather the info from a
register sales journal, and put the data into the right day of the week
in an excel sheet.
I need it to put the data into a the days of the month instead of a
week. So I figured out most of the macros but I'm having a problem
with one if statement.


Code:
--------------------
' Empty Data Sheets If There Is Evidence of Previous Import
If Worksheets(sSheet_IS).Cells(1, iQtyCol).Value < "" Then
If MsgBox("Do You Wish To Continue Import?", vbOKCancel, "Data For This Date And Shift Has Been Previously Imported") = vbCancel Then
Worksheets("SALES").Activate
Exit Sub
End If

Worksheets(sSheet_IS).Activate
Columns(sQtyCol & ":" & sQtyCol).ClearContents
Columns(sNetCol & ":" & sNetCol).ClearContents
Columns(sGrossCol & ":" & sGrossCol).ClearContents

Worksheets(sSheet_ID).Activate
Columns(sQtyCol & ":" & sQtyCol).ClearContents
Columns(sNetCol & ":" & sNetCol).ClearContents
Columns(sGrossCol & ":" & sGrossCol).ClearContents

Worksheets(sSheet_IM).Activate
Columns(sMiscCol & ":" & sMiscCol).ClearContents
End If

Worksheets("SALES").Activate

--------------------

I assume this formula is saying that if I hit the cancel button then it
will end the macro. If I hit the okay button then it will continue to
Code:
--------------------
Worksheets(sSheet_IS).Activate
--------------------
section. <-----What is this section doing? Is it saying if there are
no contents in the columns then continue? Do I need this in my macros?
I just want it to write over the old info. If I don't need it then how
can I delete it without getting a code break error or type 13 mismatch
error? Thanks for reading and thanks in advance if anyone can help
me.


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile: http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=556797