I am trying to prepare a Workbook for people who don't use excel much. I
need it to open a CSV file, manipulate the data, copy cells and then close
the file before pasting without user input.
So Far I can open the file, manipulate the data, copy the data and close the
file using
"ActiveWorkbook.Close SaveChanges:=False"
But I don't know how to bypass the popup asking if I want to keep the data
on the clipboard.
Thanks in Advance

Hi Bigg,

Try replacing:

> ActiveWorkbook.Close SaveChanges:=False

with

Application.CutCopyMode = False
ActiveWorkbook.Close SaveChanges:=False



---
Regards,
Norman


"Bigg19" <(E-Mail Removed)> wrote in message
news1012681-6DCA-42CA-9286-(E-Mail Removed)...
>I am trying to prepare a Workbook for people who don't use excel much. I
> need it to open a CSV file, manipulate the data, copy cells and then close
> the file before pasting without user input.
> So Far I can open the file, manipulate the data, copy the data and close
> the
> file using
> "ActiveWorkbook.Close SaveChanges:=False"
> But I don't know how to bypass the popup asking if I want to keep the data
> on the clipboard.
> Thanks in Advance

Thanks
I tried it earlier, bit it removes the data from the clipbpoard, and I need
to save it for future pasting.

Bigg19

"Norman Jones" wrote:

> Hi Bigg,
>
> Try replacing:
>
> > ActiveWorkbook.Close SaveChanges:=False
>
> with
>
> Application.CutCopyMode = False
> ActiveWorkbook.Close SaveChanges:=False
>
>
>
> ---
> Regards,
> Norman
>
>
> "Bigg19" <(E-Mail Removed)> wrote in message
> news1012681-6DCA-42CA-9286-(E-Mail Removed)...
> >I am trying to prepare a Workbook for people who don't use excel much. I
> > need it to open a CSV file, manipulate the data, copy cells and then close
> > the file before pasting without user input.
> > So Far I can open the file, manipulate the data, copy the data and close
> > the
> > file using
> > "ActiveWorkbook.Close SaveChanges:=False"
> > But I don't know how to bypass the popup asking if I want to keep the data
> > on the clipboard.
> > Thanks in Advance
>
>
>

Hi Bigg,


'----------------
I tried it earlier, bit it removes the data from the clipbpoard, and I need
to save it for future pasting.
'----------------

Try:

Application.DisplayAlerts = False
ThisWorkbook.Close SaveChanges:=False
Application.DisplayAlerts = True



---
Regards,
Norman

Application.displayalerts=false
'...code
Application.displayalerts=true

However, I would normally copy/paste, then continue with other code, rather
than expecting clipboard data to remain unchanged over time.

NickHK

"Bigg19" <(E-Mail Removed)> wrote in message
news:7CA84D48-BE56-4FB9-954A-(E-Mail Removed)...
> Thanks
> I tried it earlier, bit it removes the data from the clipbpoard, and I
need
> to save it for future pasting.
>
> Bigg19
>
> "Norman Jones" wrote:
>
> > Hi Bigg,
> >
> > Try replacing:
> >
> > > ActiveWorkbook.Close SaveChanges:=False
> >
> > with
> >
> > Application.CutCopyMode = False
> > ActiveWorkbook.Close SaveChanges:=False
> >
> >
> >
> > ---
> > Regards,
> > Norman
> >
> >
> > "Bigg19" <(E-Mail Removed)> wrote in message
> > news1012681-6DCA-42CA-9286-(E-Mail Removed)...
> > >I am trying to prepare a Workbook for people who don't use excel much.
I
> > > need it to open a CSV file, manipulate the data, copy cells and then
close
> > > the file before pasting without user input.
> > > So Far I can open the file, manipulate the data, copy the data and
close
> > > the
> > > file using
> > > "ActiveWorkbook.Close SaveChanges:=False"
> > > But I don't know how to bypass the popup asking if I want to keep the
data
> > > on the clipboard.
> > > Thanks in Advance
> >
> >
> >

Thanks

Your solution Worked

Regards

Bigg19

"NickHK" wrote:

> Application.displayalerts=false
> '...code
> Application.displayalerts=true
>
> However, I would normally copy/paste, then continue with other code, rather
> than expecting clipboard data to remain unchanged over time.
>
> NickHK
>
> "Bigg19" <(E-Mail Removed)> wrote in message
> news:7CA84D48-BE56-4FB9-954A-(E-Mail Removed)...
> > Thanks
> > I tried it earlier, bit it removes the data from the clipbpoard, and I
> need
> > to save it for future pasting.
> >
> > Bigg19
> >
> > "Norman Jones" wrote:
> >
> > > Hi Bigg,
> > >
> > > Try replacing:
> > >
> > > > ActiveWorkbook.Close SaveChanges:=False
> > >
> > > with
> > >
> > > Application.CutCopyMode = False
> > > ActiveWorkbook.Close SaveChanges:=False
> > >
> > >
> > >
> > > ---
> > > Regards,
> > > Norman
> > >
> > >
> > > "Bigg19" <(E-Mail Removed)> wrote in message
> > > news1012681-6DCA-42CA-9286-(E-Mail Removed)...
> > > >I am trying to prepare a Workbook for people who don't use excel much.
> I
> > > > need it to open a CSV file, manipulate the data, copy cells and then
> close
> > > > the file before pasting without user input.
> > > > So Far I can open the file, manipulate the data, copy the data and
> close
> > > > the
> > > > file using
> > > > "ActiveWorkbook.Close SaveChanges:=False"
> > > > But I don't know how to bypass the popup asking if I want to keep the
> data
> > > > on the clipboard.
> > > > Thanks in Advance
> > >
> > >
> > >
>
>
>

Thanks

That did the trick, only I had to use ActiveWorkbook.Savechanges= False.
When I tried ThisWorkbook.Savechanges = False, it closed my destination
workbook (from which the macro was being run)

Bigg19

"Norman Jones" wrote:

> Hi Bigg,
>
>
> '----------------
> I tried it earlier, bit it removes the data from the clipbpoard, and I need
> to save it for future pasting.
> '----------------
>
> Try:
>
> Application.DisplayAlerts = False
> ThisWorkbook.Close SaveChanges:=False
> Application.DisplayAlerts = True
>
>
>
> ---
> Regards,
> Norman
>
>
>